Query z s dispo inactivatable: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) 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..." |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
{{{PAGENAME}}} is one of the queries used to maintain the [[s_dispo table]]. It has a companion [[Query | {{{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'''. | ||
Revision as of 11:27, 2021 November 2
{{{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.
Related articles
| Related articles: |