Looping on multiple or all databases

[Shawn KennyKeymaster 2015-10-21 at 1:47 PM Post count: 27]

#669

The following query will return the urn,name, and acct.number for all patients admitted(in a room and bed) across multiple MEDITECH ADM databases. This same logic can be applied to any query but the “where” statement would change to reflect the MIS databases you would like to loop on. For example if you wanted to loop through PHA databases – “WHERE MIS.APPL.database LIKE ‘PHA%'”

Query Ex:
`
Select
MIS.APPL.database,
ADM.PAT.urn,
ADM.PAT.name,
ADM.PAT.acct.number
FROM MIS.APPL.main
JOIN ADM.PAT.room.bed.index ON MIS.APPL.main
JOIN ADM.PAT.main
WHERE MIS.APPL.database LIKE “ADM%”
AND { MIS.APPL.database=IF{O(#X),IF{O(%X),%.ADO.OPEN.DB(@MIS.APPL.database,”O(%X)”)}^ADO.ERR,
K(/[“ADO”].DB),M(#DB,/[“ADO”].DB),O(#X),ADO.ERR;MIS.APPL.database} }

• This topic was modified 3 years ago by  Shawn Kenny.
• This topic was modified 2 years, 4 months ago by  Shawn Kenny.
• This topic was modified 1 year, 6 months ago by  Shawn Kenny.
• This topic was modified 1 year, 6 months ago by  Shawn Kenny.

[Author]

Posts