How to change a unit (in DB) - BEXIS2/Core GitHub Wiki

Change unit in a data structure

  1. Important: Do not change or delete directly in the database without a current backup!

Change UNIT

Table datasets

  • Search for data structure ID: SELECT * FROM public.datasets WHERE id = '30948'

Table variables

  • Filter by data structure: SELECT * FROM public.variables WHERE datastructureref = '1329'
  • Change ID under unitref (You can search for the new ID on the page: Manage Units