Database SQL Operation: OrganisationUnit.readDefaultPrinterByPositionID
Description: | Reads a default printer id of an organization unit based on a position id key |
Sterotype: | ns |
SELECT
defaultPrinterID
INTO
:defaultPrinterID
FROM
OrganisationUnit,
Position,
OrgUnitPositionLink
WHERE Position.positionID = :positionID
AND OrgUnitPositionLink.positionID = Position.positionID
AND OrganisationUnit.organisationUnitID = OrgUnitPositionLink.organisationUnitID
AND OrgUnitPositionLink.organisationStructureID = :organisationStructureID
|