S locations allowed collection table: 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: | ||
{{DISPLAYTITLE:s_locations_allowed_collection table}} | {{DISPLAYTITLE:s_locations_allowed_collection table}} | ||
{{LegacyContent | {{LegacyContent | ||
| explanation=Table [[s_locations_allowed_collection table]] was a table used to restrict which [[Service/ | | explanation=Table [[s_locations_allowed_collection table]] was a table used to restrict which [[Service/Location]]s should be available on a laptop based on work allocation. It became irrelevant when we stopped allocating by unit, and was finally removed 2023-11-03 as part of [[Change to having each collector collect both programs on the same laptop]]. | ||
| successor=[[Query s_serviceLocation_local]] | | successor=[[Query s_serviceLocation_local]] | ||
| content= | | content= | ||
Latest revision as of 11:47, 2023 November 3
Legacy Content
This page contains Legacy Content.- Explanation: Table s_locations_allowed_collection table was a table used to restrict which Service/Locations should be available on a laptop based on work allocation. It became irrelevant when we stopped allocating by unit, and was finally removed 2023-11-03 as part of Change to having each collector collect both programs on the same laptop.
- Successor: Query s_serviceLocation_local
Click Expand to show legacy content.
contains info about what should be shown in the Service/Location field dropdown. Query s_serviceLocation_local filters this depending on the the Laptop identifier in Settings (CCMBD.mdb).
Data structure:
- ServiceLocation - linked to s_dispo
- Laptop_identifier - to declare on which laptop this will shwo
- sort - sort order on that laptop, lowest number will be first.
Most of its fields are driven by dropdowns based on s_dispo table.
Removing entries
Removing entries from this table while records still exist on a laptop causes sending problems. See Service/Location field#Retiring an available Service/Location field entry.