Query z s dispo inactivatable: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo 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 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: |