It looks like you're new here. If you want to get involved, click one of these buttons!
We made a kind of stupid mistake when creating our collective access database and started a new identification numbering system. All objects in the database got a new "logic" number which became the idno. The old "irrational" ID's were instead placed in another metadata element called "altID". This has caused problems and I would like to replace the current idno with the values from the element "altID" and create a new element for the current idno values. I figured that this could be done directly in mysql but I don't know how. I took a look at the tables and saw that the values I want (from element altID) is stored in column "value_longtext1" in table "ca_attributes_values" on the rows which has "element_id" set to 22. But from there I don't now how to proceed. Is this possible to do somehow? Maybe I'm one the completely wrong track here.