Query z s dispo inactivatable: 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 lastUsed. This query will show when an entry in s_dispo...")
 
mNo edit summary
 
(One intermediate revision 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 lastUsed]].  
{{PAGENAME}} is one of the queries in [[CFE]] used to maintain the [[s_dispo table]]. It has a companion [[Query z_s_dispo lastUsed]].  


This query will show when an entry in [[s_dispo table]] is no longer used in a profile with [[RecordStatus]]="inactive" in any of the 4 fields this table supplies. This doesn't mean the entry ''should'' be inactivated, it might just be rarely used. But the entry definitely '''should not be inactivated unless this query shows it'''.   
This query will show when an entry in [[s_dispo table]] is no longer used in a profile with [[RecordStatus]]="inactive" in any of the 4 fields this table supplies. This doesn't mean the entry ''should'' be inactivated, it might just be rarely used. But the entry definitely '''should not be inactivated unless this query shows it'''.   

Latest revision as of 12:31, 2021 November 2

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

This query will show when an entry in s_dispo table is no longer used in a profile with RecordStatus="inactive" in any of the 4 fields this table supplies. This doesn't mean the entry should be inactivated, it might just be rarely used. But the entry definitely should not be inactivated unless this query shows it.

Related articles

Related articles: