Template:Location dropdown cleanup: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 31: | Line 31: | ||
Some of these might still be legit just not currently used. Can any be deactivated? Sherry's question made me think that there should be more that should be taken off. It could be that there are pre-patient-follow profiles left that use the old entries, but that's a while ago, so it's also possible that collectors are not using the codes consistently. Sherry, could you give me three sample locations, and the field from which you think they should be no longer available? [[User:Ttenbergen|Ttenbergen]] 10:49, 2021 October 5 (CDT) | Some of these might still be legit just not currently used. Can any be deactivated? Sherry's question made me think that there should be more that should be taken off. It could be that there are pre-patient-follow profiles left that use the old entries, but that's a while ago, so it's also possible that collectors are not using the codes consistently. Sherry, could you give me three sample locations, and the field from which you think they should be no longer available? [[User:Ttenbergen|Ttenbergen]] 10:49, 2021 October 5 (CDT) | ||
}} | |||
== CFE Query == | |||
{{SQL| | |||
SELECT s_dispo.location_name, s_dispo.Site, s_dispo.active, s_dispo.inpatient, L_Log_PIL.CountOfD_ID, s_dispo.previous_location, L_Log_P.CountOfD_ID, s_dispo.s_location, L_Log_SL.CountOfD_ID, s_dispo.dispo, L_Log_D.CountOfD_ID | |||
FROM (((s_dispo LEFT JOIN (SELECT Count(L_Log.D_ID) AS CountOfD_ID, L_Log.Pre_admit_Inpatient_Institution | |||
FROM L_Log | |||
WHERE (((L_Log.RecordStatus)="incomplete")) | |||
GROUP BY L_Log.Pre_admit_Inpatient_Institution) AS L_Log_PIL ON s_dispo.dispo_ID = L_Log_PIL.Pre_admit_Inpatient_Institution) LEFT JOIN (SELECT Count(L_Log.D_ID) AS CountOfD_ID, L_Log.Previous_Location | |||
FROM L_Log | |||
WHERE (((L_Log.RecordStatus)="incomplete")) | |||
GROUP BY L_Log.Previous_Location) AS L_Log_P ON s_dispo.dispo_ID = L_Log_P.Previous_Location) LEFT JOIN (SELECT Count(L_Log.D_ID) AS CountOfD_ID, L_Log.Service_Location | |||
FROM L_Log | |||
WHERE (((L_Log.RecordStatus)="incomplete")) | |||
GROUP BY L_Log.Service_Location) AS L_Log_SL ON s_dispo.dispo_ID = L_Log_SL.Service_Location) LEFT JOIN (SELECT Count(L_Log.D_ID) AS CountOfD_ID, L_Log.Dispo | |||
FROM L_Log | |||
WHERE (((L_Log.RecordStatus)="incomplete")) | |||
GROUP BY L_Log.Dispo) AS L_Log_D ON s_dispo.dispo_ID = L_Log_D.Dispo | |||
WHERE (((s_dispo.Site) Is Not Null) AND ((s_dispo.active)=True) AND ((s_dispo.inpatient)=True) AND ((L_Log_PIL.CountOfD_ID) Is Null)) OR (((s_dispo.Site) Is Not Null) AND ((s_dispo.active)=True) AND ((s_dispo.previous_location)=True) AND ((L_Log_P.CountOfD_ID) Is Null)) OR (((s_dispo.Site) Is Not Null) AND ((s_dispo.active)=True) AND ((s_dispo.s_location)=True) AND ((L_Log_SL.CountOfD_ID) Is Null)) OR (((s_dispo.Site) Is Not Null) AND ((s_dispo.active)=True) AND ((s_dispo.dispo)=True) AND ((L_Log_D.CountOfD_ID) Is Null)) | |||
ORDER BY s_dispo.location_name; | |||
}} | }} | ||
Revision as of 12:46, 5 October 2021
Temporary template to ensure consistent messaging on this topic.
"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.
|
Some of these might still be legit just not currently used. Can any be deactivated? Sherry's question made me think that there should be more that should be taken off. It could be that there are pre-patient-follow profiles left that use the old entries, but that's a while ago, so it's also possible that collectors are not using the codes consistently. Sherry, could you give me three sample locations, and the field from which you think they should be no longer available? Ttenbergen 10:49, 2021 October 5 (CDT) |
|
