Query z s dispo lastUsed: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "{{{PAGENAME}}} is one of the queries 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_..."
 
No edit summary
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{{PAGENAME}}} is one of the queries 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.
'''Follow the instructions in [[Collection stop instructions]] to keep things coherent.'''


== Related articles ==  
== Related articles ==  
{{Related Articles}}
{{Related Articles}}


[[Category:S dispo table]]
[[Category:s_dispo table]]
[[Category:Collection stop instructions]]

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: