| || |
Update SYSTEM_FIELDS Cache
Does anyone know how to programatically update the system fields cache?
I am updating the table SYSTEM_FIELD and that's no problem.
However, the change does *not* take affect until the cache is refreshed (i.e., ALM re-reads the SYSTEM_FIELD table).
The manual way to do this is to go into Tools/Customize/Project Entities and make a change (like add or change anything and Save).
Once saved, ALM re-reads the SYSTEM_FIELD table and the changes made by SQL take effect.
However, I need to do it programatically via OTA and haven't been able to find a way to do it.
So now to answer my own questions, to do it in code (force ALM to update the SYSTEM_FIELD cache), the only way I found was (like manually in the GUI), add a custom user field with OTA and commit it, then turn around and delete that same user field and commit that change. This forces the cache update programmatically.