Template:Location dropdown cleanup: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m moved the todo out of the template include, it doesn't need to pollute the list |
Ttenbergen (talk | contribs) No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 5: | Line 5: | ||
| todo_added = 2020-10-20 | | todo_added = 2020-10-20 | ||
| todo_action = 2022-03-05 | | todo_action = 2022-03-05 | ||
| question = | | question = _regular | ||
* Since no one person knows when an s_dispo item is no longer used on any laptop. Made [[CFE]] query ''z_s_dispo_inactivatable'' to check. Should check that query occasionally to review if other things can be cleaned up. | * Since no one person knows when an s_dispo item is no longer used on any laptop. Made [[CFE]] query ''z_s_dispo_inactivatable'' to check. Should check that query occasionally to review if other things can be cleaned up. | ||
}} | }} | ||
| Line 12: | Line 12: | ||
We can and will remove them, but that can only happen once no more laptops use them. We will need to keep track of this and then remove them when ready. If I removed them now, then any box that currently has them enter would misbehave. | We can and will remove them, but that can only happen once no more laptops use them. We will need to keep track of this and then remove them when ready. If I removed them now, then any box that currently has them enter would misbehave. | ||
{{Collapsable | {{Collapsable | ||
| always= SQL | | always= SQL query of what is currently available | ||
| full= <pre>SELECT s_dispo.location_name, s_dispo.Site, s_dispo.active, s_dispo.inpatient, s_dispo.previous_location, s_dispo.s_location, s_dispo.dispo | | full= <pre>SELECT s_dispo.location_name, s_dispo.Site, s_dispo.active, s_dispo.inpatient, s_dispo.previous_location, s_dispo.s_location, s_dispo.dispo | ||
FROM s_dispo | FROM s_dispo | ||
| Line 20: | Line 19: | ||
</pre>}} | </pre>}} | ||
* query of what is currently used: query z_s_dispo_inactivatable | |||
query z_s_dispo_inactivatable | |||
Latest revision as of 11:12, 6 March 2025
Temporary template to ensure consistent messaging on this topic.
|
_regular
|
|
"Can we remove the items that are no longer Service/Locations, Previous Locations, Pre-admit Inpatient Institutions or dispo locations from the dropdowns?"
We can and will remove them, but that can only happen once no more laptops use them. We will need to keep track of this and then remove them when ready. If I removed them now, then any box that currently has them enter would misbehave.
| SQL query of what is currently available |
SELECT s_dispo.location_name, s_dispo.Site, s_dispo.active, s_dispo.inpatient, s_dispo.previous_location, s_dispo.s_location, s_dispo.dispo FROM s_dispo WHERE (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.inpatient)=True)) OR (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.previous_location)=True)) OR (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.s_location)=True)) OR (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.dispo)=True)); |
- query of what is currently used: query z_s_dispo_inactivatable