Page Comparison

...

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

...

note:

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

...

• 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;

• paths

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

...

• 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:

...

1. Stop the previously running Asta7

   Code Block
   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

   Code Block
   cd asta7-1.61.0 docker compose up -d

5. Regenerate the requisition client secret from Keycloak

6. Put the new client secret in .env and restart Asta7

   Code Block
   docker compose restart