Query z s dispo lastUsed: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
Line 5: Line 5:
Before inactivating a field, you may also want to run [[Query z_s_dispo_inactivatable]] to make sure it isn't currently used.  
Before inactivating a field, you may also want to run [[Query z_s_dispo_inactivatable]] to make sure it isn't currently used.  


Follow the instructions in [[Collection stop instructions]] to keep things coherent.
'''Follow the instructions in [[Collection stop instructions]] to keep things coherent.'''


== Related articles ==  
== Related articles ==  

Latest revision as of 22:06, 21 January 2026

Query z s dispo lastUsed is one of the queries in CFE used to maintain the s_dispo table. It has a companion Query z_s_dispo_inactivatable.

This query will show when an entry in s_dispo table was last used for any of the 4 fields this table supplies. If it has not been used in a while it might be possible to inactivate it to clean up the dropdown. But it might also need to stay because the location simply isn't used very often.

Before inactivating a field, you may also want to run Query z_s_dispo_inactivatable to make sure it isn't currently used.

Follow the instructions in Collection stop instructions to keep things coherent.

Related articles

Related articles: