GGCE Support issueshttps://gitlab.croptrust.org/grin-global/support/-/issues2021-04-19T10:52:19+02:00https://gitlab.croptrust.org/grin-global/support/-/issues/3Addis accession numbers2021-04-19T10:52:19+02:00Matija ObrezaAddis accession numbersAddis does not use `accession_number_part2` (similar to #1) and there is no string prefix at all, just numbers.
```sql
update accession set
accession_number_part2=cast(accession_number_part1 as bigint),
accession_number_part1=''
;
...Addis does not use `accession_number_part2` (similar to #1) and there is no string prefix at all, just numbers.
```sql
update accession set
accession_number_part2=cast(accession_number_part1 as bigint),
accession_number_part1=''
;
update inventory set
inventory_number_part2=cast(inventory_number_part1 as bigint),
inventory_number_part1=''
where
form_type_code= '**'
;
```
I need to check if GG-CE Web allows for a blank prefix (`number_part1`).