XUUFAA (5)    SORT TEMPLATE (.401)

Name Value
NAME XUUFAA
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
DATE CREATED 2019-10-28 13:31:00
FILE FAILED ACCESS ATTEMPTS LOG
DATE LAST USED 2020-01-29 00:00:00