SORT FIELD DATA |
-
- FILE OR SUBFILE NO.: 3.05
- QUERY CONDITION: I D0]]3200129.129999
- DESCRIPTION OF SORT: DATE/TIME OF ATTEMPT from JAN 29,2020@13:00
- SEARCH EFFICIENCY RATING: 1.0000
- PROBABILITY RATING: 1.0000
- DATA TYPE FOR SORTING: DATE/TIME
- FIELD NO.: 0
- FIELD NAME: DATE/TIME OF ATTEMPT
- COMPUTED FIELD TYPE: D
- FROM VALUE INTERNAL: 3200129.129999
- FROM VALUE EXTERNAL: JAN 29,2020@13:00
- FROM VALUE PRINTABLE: JAN 29,2020@13:00
- TO VALUE INTERNAL: z
-
- FILE OR SUBFILE NO.: 3.05
- GET CODE: S Y(1)=$S($D(^%ZUA(3.05,D0,0)):^(0),1:"") S X=$P($G(^VA(200,+$P(Y(1),U,6),0)),U) I D0>0 S DISX(2)=X
- QUERY CONDITION: I 1
- DESCRIPTION OF SORT: All USER (includes null values)
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: S Y(1)=$S($D(^%ZUA(3.05,D0,0)):^(0),1:"") S X=$P($G(^VA(200,+$P(Y(1),U,6),0)),U) I D0>0 S DISX(2)=X
- FIELD NAME: USER
- SORT QUALIFIERS BEFORE FIELD: "5
- FROM VALUE INTERNAL: ?z
- FROM VALUE EXTERNAL: @
- TO VALUE INTERNAL: z
-
- FILE OR SUBFILE NO.: 3.05
- GET CODE: S DISX(3)=$P($G(^%ZUA(3.05,D0,0)),U,3)
- QUERY CONDITION: I DISX(3)'=""
- DESCRIPTION OF SORT: TYPE OF FAILED ATTEMPT not null
- SEARCH EFFICIENCY RATING: 0.0000
- PROBABILITY RATING: 0.0000
- DATA TYPE FOR SORTING: SET OF CODES
- FIELD NO.: 2
- FIELD NAME: TYPE OF FAILED ATTEMPT
|