How to datafix item number and related table ?
Hi,
We create new item, and no other relation, it’s very clear, but naming is wrong, how to fix data on item_number?
I check table agile.item ,fix the column item_number,encode_name, and we can see the information change, but we try to search this item on search bar with no data found, did any other table need to be change ?
thanks.
No need to mess with the database. Just grant yourself permission to modify the item number and update it directly in the client.
You have to deal with context indexing if you change the item number. Like Keith says, just give yourself Modify privilege and change it through the client.