SORT FIELD DATA |
-
- FILE OR SUBFILE NO.: 409.97
- GET CODE: S DISX(1)=$P($G(^SDAUDIT(D0,0)),U,2)
- QUERY CONDITION: I (DISX(1)]]3150100.999999)&(DISX(1)']]3180411.24)
- DESCRIPTION OF SORT: DATE from JAN 1,2015 to APR 11,2018@24:00
- DATA TYPE FOR SORTING: DATE/TIME
- FIELD NO.: 1
- FIELD NAME: DATE
- FROM VALUE INTERNAL: 3150100.999999
- FROM VALUE EXTERNAL: JAN 1,2015
- FROM VALUE PRINTABLE: JAN 1,2015
- TO VALUE INTERNAL: 3180411.24
- TO VALUE EXTERNAL: APR 11,2018@2400
- TO VALUE PRINTABLE: APR 11,2018@24:00
- CROSS REFERENCE DATA: ^SDAUDIT("C",^SDAUDIT(^2
-
- FILE OR SUBFILE NO.: 409.97
- GET CODE: S Y(1)=$S($D(^SDAUDIT(D0,0)):^(0),1:"") S X=$P($G(^VA(200,+$P(Y(1),U,1),0)),U) I D0>0 S DISX(2)=X
- QUERY CONDITION: I DISX(2)'=""
- DESCRIPTION OF SORT: SCHEDULER not null
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: S Y(1)=$S($D(^SDAUDIT(D0,0)):^(0),1:"") S X=$P($G(^VA(200,+$P(Y(1),U,1),0)),U) I D0>0 S DISX(2)=X
- FIELD NAME: SCHEDULER
- SORT QUALIFIERS BEFORE FIELD: ".01
- CROSS REFERENCE DATA: ^SDAUDIT("B",^SDAUDIT(^2
- POINT TO CROSS REFERENCE: ^VA(200,"B",
|