Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Highlights:

AAM-1149: Outline new solution for fragments

AN-2057: ISAD(G) - Statistics - Part 1

AN-2096: ISAD(G) - Statistics - Part 2

AN-2095: Add option to delete orphans from the repository

AN-2141: As a user I want to be able to see the whole title of objects on my separator sheet, even when titles are long

AN-2089: Swagger is not working in Requisition backend after version upgrading

AN-2024: Ingest Asta5 migration data filtering by Institute ID

AN-2188: Project Import job is missing notification

AN-2143: Change datatype of amid to uuid of all fields of Coding Schema Module

Tasks:

AN-2178: Create Requisition Client in keycloak Automatically for existing and new users

AN-2058: Include archive name as a field for portal requisition items from the portal

AM-268: Error in the log when running requisition sync

AN-2151: Write Base Test Cases for Requisition Backend

AN-2126: Add large amount of items to "move"-cart fails

AN-2118: Download statistics xls from client side, not use any job

AM-266: Prepare sql script for asta requisition to solve missisng title and storage unit patha

AN-2111: R&D on Docker Daemon status with Prometheus

AN-2099: Update PrimeNg library version 16.3.1

AN-2096: ISAD(G) - Statistics - Part 2

AN-2095: Add option to delete orphans from the repository

AN-2094: Issues with syncing to repository

AN-2091: Unable to publish an archive

AN-2089: Swagger is not working in Requisition backend after version upgrading

AN-2088: Archivist should be able to publish archives to the portal

AN-2086: Create reusable component for item format change from Rack & Storage Unit page

AN-2085: Searchin the tree is limited to 10 hits. We need to show more hits and add a load more functionality

AM-263: Create azure monitor alert for vm status

AM-261: Send prometheus alert to email.

AN-2081: Access to settings and configuration in the requisition module

AN-2078: Lock all archives

AN-2077: Finding entities based on queries on sub-entities on this item

AN-2076: Migrated portal requisitions fail to download

AN-2061: Fix Bitbucket pipeline for feature branch for prototype

AN-2060: Make it possible to batch delete storage units for Stykke

AN-2059: Add requisition state for requisitions from the portal and add the state In Progress

AN-2058: Include archive name as a field for portal requisition items from the portal

AN-2057: ISAD(G) - Statistics - Part 1

AN-2054: Change linebreak when printing QR-code labels in for the moving workflow in repository and order the printout

AN-2030: Write complete test cases for requisition client

AN-2024: Ingest Asta5 migration data filtering by Institute ID

AN-2018: Add functionality to sync data from Asta7/repository to requisition (e.g. title, restrictions, storage unit, etc)

AAM-1149: Outline new solution for fragments

Bugs:

AN-2188: Project Import job is missing notification

AN-2156: Unable to place units in repository because contentPath = null

AN-2153: Error when creating Aktør relasjon without object reference

AN-2144: Admin client archive editor allows foreign key field change

AN-2143: Change datatype of amid to uuid of all fields of Coding Schema Module

AN-2116: essync not supporting the markdown feature

AN-2107: Admin user unable to list requisitions

AN-2105: Load button should be disabled if the user click it once.

Stories:

AN-2141: As a user I want to be able to see the whole title of objects on my separator sheet, even when titles are long

Tasks with Release note:

  • AN-2178: Create Requisition Client in keycloak Automatically for existing and new users

Need to update value of REQUISITION_CLIENT_SECRET key in .env fie.
Click Regenerate button to regenerate client secret.
Copy client secret and replace default value of REQUISITION_CLIENT_SECRET key  in .env file.

  • AM-266: Prepare sql script for asta requisition to solve missisng title and storage unit patha

Script for empty object title resolution. 

create table am_title(
                         amid uuid,
                         title text
);

insert into am_title
select  _amid, identifikator||' - '||navn
from test2.arkiv;

insert into am_title
select  _amid, identifikator
from test2.serie;


insert into am_title
select  _amid, identifikator
from test2.stykke;


insert into am_title
select  _amid, identifikator
from test2.mappe;


create index idnx_title on am_title(amid);


create table new_object_title(
                                 objectId text,
                                 objectTitle text
);

insert into new_object_title
select object_id, tmp2.*
from requisition.requisition_object_info objectInfo
         join lateral (
    select string_agg( tmp.title2, '/')
    from (select objectInfo.object_id as originalAmid,(select title from am_title where amid = am_ancestor_tree.amid) title2
          from test2.am_ancestor_tree
          where amids @>
                (select amids from test2.am_ancestor_tree where amid = objectInfo.object_id::uuid limit 1)
          order by amids
         ) tmp
    ) tmp2 on true
where object_title = '';

create index idx2 on new_object_title(objectId);

update new_object_title set objectTitle  = 'NOT FOUND' where objectTitle is null;

update requisition.requisition_object_info set object_title = (
    select new_object_title.objectTitle  from new_object_title where objectId = requisition_object_info.object_id
    union
    select ''
    limit 1
) where object_title = '';


drop table new_object_title;
drop table am_title;

  • AN-2054: Change linebreak when printing QR-code labels in for the moving workflow in repository and order the printout

The final implementation includes support for longer archive identifier/name/content path, using ellipses. Currently, a maximum of 4 lines for the content path is supported.

  • AN-2018: Add functionality to sync data from Asta7/repository to requisition (e.g. title, restrictions, storage unit, etc)

create table am_title(
    amid uuid,
    title text
);

insert into am_title
select  _amid, identifikator||' - '||navn
from test2.arkiv;

insert into am_title
select  _amid, identifikator
from test2.serie;


insert into am_title
select  _amid, identifikator
from test2.stykke;


insert into am_title
select  _amid, identifikator
from test2.mappe;


create index idnx_title on am_title(amid);


create table new_object_title(
    objectId text,
    objectTitle text
);

insert into new_object_title
select object_id, tmp2.*
from requisition.requisition_object_info objectInfo
         join lateral (
    select string_agg( tmp.title2, '/')
    from (select objectInfo.object_id as originalAmid,(select title from am_title where amid = am_ancestor_tree.amid) title2
          from test2.am_ancestor_tree
          where amids @>
                (select amids from test2.am_ancestor_tree where amid = objectInfo.object_id::uuid limit 1)
          order by amids
         ) tmp
    ) tmp2 on true
 where object_title = '';


create index idx2 on new_object_title(objectId);


update requisition.requisition_object_info set object_title = (
    select new_object_title.objectTitle  from new_object_title where objectId = requisition_object_info.object_id
                                                               union
                                                               select ''
                                                               limit 1
    ) where object_title = '';


drop table new_object_title;
drop table am_title;

Install-Package:

How to upgrade:

  1. Stop the previously running Asta7

    cd previous_asta7_directory
docker compose down

  2. Download and extract Asta7 1.61.0

  3. Adjust the .env file according to the previous one

  4. Run Asta7 1.61.0

    cd asta7-1.61.0
docker compose up -d

  • No labels