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: | ||
Table [[s_locations_allowed_collection table]] is 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)]]. | {{DISPLAYTITLE:s_locations_allowed_collection table}}Table [[s_locations_allowed_collection table]] is 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: | Data structure: |
Revision as of 16:27, 2023 May 17
Table s_locations_allowed_collection table is 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.