SORT FIELD DATA |
-
- FILE OR SUBFILE NO.: 1.1
- GET CODE: S %=^DIC(DIA,0,"GL"),X=^DIA(DIA,D0,0),X=$S($D(@(%_+X_",0)")):$P(^(0),U,1),1:""),C=$S($D(^DD(DIA,.01,0)):$P(^(0),U,2),1:""),Y=X D:Y]"" Y^DIQ:C]"" S X=Y,C="," S DISX(1)=X
- QUERY CONDITION: I DISX(1)'=""
- DESCRIPTION OF SORT: ENTRY NAME not null
- DATA TYPE FOR SORTING: FREE TEXT
- FIELD NO.: 1
- FIELD NAME: ENTRY NAME
- SORT QUALIFIERS BEFORE FIELD: @
-
- FILE OR SUBFILE NO.: 1.1
- GET CODE: S DISX(2)=$P($G(^DIA(DIA,D0,0)),U,3)
- QUERY CONDITION: I DISX(2)=9.2
- DESCRIPTION OF SORT: FIELD NUMBER equals 9.2
- DATA TYPE FOR SORTING: FREE TEXT
- FIELD NO.: .03
- FIELD NAME: FIELD NUMBER
- SORT QUALIFIERS BEFORE FIELD: @
- FROM VALUE INTERNAL: 9.199999
- FROM VALUE EXTERNAL: 9.2
- TO VALUE INTERNAL: 9.2
- TO VALUE EXTERNAL: 9.2
-
- FILE OR SUBFILE NO.: 1.1
- GET CODE: S DISX(3)=$P($G(^DIA(DIA,D0,0)),U,2)
- QUERY CONDITION: I (DISX(3)]]3040100.999999)&(DISX(3)']]3040427.24)
- DESCRIPTION OF SORT: DATE/TIME RECORDED from Jan 1,2004 to Apr 27,2004@24:00
- DATA TYPE FOR SORTING: DATE/TIME
- FIELD NO.: .02
- FIELD NAME: DATE/TIME RECORDED
- SORT QUALIFIERS BEFORE FIELD: @
- FROM VALUE INTERNAL: 3040100.999999
- FROM VALUE EXTERNAL: 3040101
- FROM VALUE PRINTABLE: Jan 1,2004
- TO VALUE INTERNAL: 3040427.24
- TO VALUE EXTERNAL: 3040427@2400
- TO VALUE PRINTABLE: Apr 27,2004@24:00
- CROSS REFERENCE DATA: ^DIA(200,"C",^DIA(200,^2
|