Query z s dispo lastUsed: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
{{PAGENAME}} is one of the queries in [[CFE]] used to maintain the [[s_dispo table]]. It has a companion [[Query z_s_dispo inactivatable]].  
{{PAGENAME}} 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.  
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.


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

Revision as of 21:41, 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.

Related articles

Related articles: