[613] | 1 | DINIT124 ;SFISC/MKO-SORT TEMPLATE FILE ;1:13 PM 13 Nov 1998
|
---|
| 2 | ;;22.0;VA FileMan;;Mar 30, 1999
|
---|
| 3 | ;Per VHA Directive 10-93-142, this routine should not be modified.
|
---|
| 4 | F I=1:2 S X=$T(Q+I) Q:X="" S Y=$E($T(Q+I+1),4,999),X=$E(X,4,999) S:$A(Y)=126 I=I+1,Y=$E(Y,2,999)_$E($T(Q+I+1),5,99) S:$A(Y)=61 Y=$E(Y,2,999) S @X=Y
|
---|
| 5 | G ^DINIT125
|
---|
| 6 | Q Q
|
---|
| 7 | ;;^DD(.4014,9,3)
|
---|
| 8 | ;;=First ^ piece null, second piece=static part of cross-reference, third piece=global reference, 4th piece=number of variable subscripts to get to (and including) record number.
|
---|
| 9 | ;;^DD(.4014,9,21,0)
|
---|
| 10 | ;;=^^8^8^2930115^
|
---|
| 11 | ;;^DD(.4014,9,21,1,0)
|
---|
| 12 | ;;= Piece 1 is always null
|
---|
| 13 | ;;^DD(.4014,9,21,2,0)
|
---|
| 14 | ;;= Piece 2 is the static part of the cross-reference: ex. DIZ(662001,"B",
|
---|
| 15 | ;;^DD(.4014,9,21,3,0)
|
---|
| 16 | ;;= Piece 3 is the global reference: ex. DIZ(662001,
|
---|
| 17 | ;;^DD(.4014,9,21,4,0)
|
---|
| 18 | ;;= Piece 4 tells FileMan how many variable subscripts must be sorted
|
---|
| 19 | ;;^DD(.4014,9,21,5,0)
|
---|
| 20 | ;;=through to get to the record number, plus 1 for the record number
|
---|
| 21 | ;;^DD(.4014,9,21,6,0)
|
---|
| 22 | ;;=itself. ex. for a regular cross-reference, ^DIZ(662001,"B",X,DA),
|
---|
| 23 | ;;^DD(.4014,9,21,7,0)
|
---|
| 24 | ;;=the number is 2. One for the value of the X subscript, and one for the
|
---|
| 25 | ;;^DD(.4014,9,21,8,0)
|
---|
| 26 | ;;=record number itself (DA).
|
---|
| 27 | ;;^DD(.4014,9,23,0)
|
---|
| 28 | ;;=^^6^6^2930115^
|
---|
| 29 | ;;^DD(.4014,9,23,1,0)
|
---|
| 30 | ;;=The IX nodes are normally derived by FileMan during the entry of sort
|
---|
| 31 | ;;^DD(.4014,9,23,2,0)
|
---|
| 32 | ;;=fields (in routine XR^DIP). However, they can also be passed to the
|
---|
| 33 | ;;^DD(.4014,9,23,3,0)
|
---|
| 34 | ;;=print (^DIP) in the BY(0) variable to cause FileMan to either use a MUMPS
|
---|
| 35 | ;;^DD(.4014,9,23,4,0)
|
---|
| 36 | ;;=type cross-reference, or a previously sorted list of record numbers.
|
---|
| 37 | ;;^DD(.4014,9,23,5,0)
|
---|
| 38 | ;;=Fileman sometimes builds the IX node prior to calling the print, as in
|
---|
| 39 | ;;^DD(.4014,9,23,6,0)
|
---|
| 40 | ;;=the INQUIRE option, where the user then goes on to print the records.
|
---|
| 41 | ;;^DD(.4014,9,"DT")
|
---|
| 42 | ;;=2930115
|
---|
| 43 | ;;^DD(.4014,9.5,0)
|
---|
| 44 | ;;=POINT TO CROSS REFERENCE^F^^PTRIX;E1,245^K:$L(X)>245!($L(X)<1) X
|
---|
| 45 | ;;^DD(.4014,9.5,3)
|
---|
| 46 | ;;=Enter global reference for "B" index of .01 field on pointed-to file. Answer must be 1-245 characters in length.
|
---|
| 47 | ;;^DD(.4014,9.5,21,0)
|
---|
| 48 | ;;=^^7^7^2931221^
|
---|
| 49 | ;;^DD(.4014,9.5,21,1,0)
|
---|
| 50 | ;;=This node will exist only if the sort field is a pointer, if the sort
|
---|
| 51 | ;;^DD(.4014,9.5,21,2,0)
|
---|
| 52 | ;;=field has a regular cross-reference, if the .01 field on the pointed-to
|
---|
| 53 | ;;^DD(.4014,9.5,21,3,0)
|
---|
| 54 | ;;=file has a "B" index, and if the .01 field on the pointed-to file is
|
---|
| 55 | ;;^DD(.4014,9.5,21,4,0)
|
---|
| 56 | ;;=either a numeric, date, set-of-codes or free-text field, and does not have
|
---|
| 57 | ;;^DD(.4014,9.5,21,5,0)
|
---|
| 58 | ;;=an output transform. If this node exists, it will be set to the static
|
---|
| 59 | ;;^DD(.4014,9.5,21,6,0)
|
---|
| 60 | ;;=part of the global reference of the "B" index on the pointed-to file. (ex.
|
---|
| 61 | ;;^DD(.4014,9.5,21,7,0)
|
---|
| 62 | ;;=^DIZ(662001,"B",).
|
---|
| 63 | ;;^DD(.4014,9.5,"DT")
|
---|
| 64 | ;;=2931221
|
---|
| 65 | ;;^DD(.4014,10,0)
|
---|
| 66 | ;;=GET CODE^K^^GET;E1,245^K:$L(X)>245 X D:$D(X) ^DIM
|
---|
| 67 | ;;^DD(.4014,10,3)
|
---|
| 68 | ;;=This is Standard MUMPS code used to extract the sort field from a record.
|
---|
| 69 | ;;^DD(.4014,10,9)
|
---|
| 70 | ;;=@
|
---|
| 71 | ;;^DD(.4014,10,21,0)
|
---|
| 72 | ;;=^^3^3^2930115^
|
---|
| 73 | ;;^DD(.4014,10,21,1,0)
|
---|
| 74 | ;;=The GET CODE is MUMPS code that is executed after a record (or sub-record)
|
---|
| 75 | ;;^DD(.4014,10,21,2,0)
|
---|
| 76 | ;;=has been selected. The code extracts the SORT field from that record
|
---|
| 77 | ;;^DD(.4014,10,21,3,0)
|
---|
| 78 | ;;=into a local variable.
|
---|
| 79 | ;;^DD(.4014,10,23,0)
|
---|
| 80 | ;;=^^1^1^2930115^
|
---|
| 81 | ;;^DD(.4014,10,23,1,0)
|
---|
| 82 | ;;=GET CODE can be generated by a call to FileMan routine GET^DIOU.
|
---|
| 83 | ;;^DD(.4014,10,"DT")
|
---|
| 84 | ;;=2930115
|
---|
| 85 | ;;^DD(.4014,11,0)
|
---|
| 86 | ;;=QUERY CONDITION^K^^QCON;E1,245^K:$L(X)>245 X D:$D(X) ^DIM
|
---|
| 87 | ;;^DD(.4014,11,3)
|
---|
| 88 | ;;=This is Standard MUMPS code used to test the field to see whether it meets the query condition (ex., whether it's within the from/to range specified by the user).
|
---|
| 89 | ;;^DD(.4014,11,9)
|
---|
| 90 | ;;=@
|
---|
| 91 | ;;^DD(.4014,11,21,0)
|
---|
| 92 | ;;=^^5^5^2930115^
|
---|
| 93 | ;;^DD(.4014,11,21,1,0)
|
---|
| 94 | ;;=The QUERY CONDITION is MUMPS code that takes a field in a local variable,
|
---|
| 95 | ;;^DD(.4014,11,21,2,0)
|
---|
| 96 | ;;=and executes some query condition. The results of executing the code
|
---|
| 97 | ;;^DD(.4014,11,21,3,0)
|
---|
| 98 | ;;=will return a truth value of TRUE if the field met the condition, or
|
---|
| 99 | ;;^DD(.4014,11,21,4,0)
|
---|
| 100 | ;;=FALSE if not. It is used, for example, to see whether a SORT FIELD falls
|
---|
| 101 | ;;^DD(.4014,11,21,5,0)
|
---|
| 102 | ;;=within the FROM/TO range requested by the user.
|
---|
| 103 | ;;^DD(.4014,11,23,0)
|
---|
| 104 | ;;=^^2^2^2930115^
|
---|
| 105 | ;;^DD(.4014,11,23,1,0)
|
---|
| 106 | ;;=The QUERY CONDITION code is generated by various calls to FileMan
|
---|
| 107 | ;;^DD(.4014,11,23,2,0)
|
---|
| 108 | ;;=routines DIOC*.
|
---|
| 109 | ;;^DD(.4014,11,"DT")
|
---|
| 110 | ;;=2930115
|
---|
| 111 | ;;^DD(.4014,12,0)
|
---|
| 112 | ;;=DESCRIPTION OF SORT^F^^TXT;E1,200^K:$L(X)>200!($L(X)<1) X
|
---|
| 113 | ;;^DD(.4014,12,3)
|
---|
| 114 | ;;=Answer must be 1-200 characters in length. Text explaining the query condition (field name and what conditions must be met in order for the record to be selected).
|
---|
| 115 | ;;^DD(.4014,12,21,0)
|
---|
| 116 | ;;=^^4^4^2930115^
|
---|
| 117 | ;;^DD(.4014,12,21,1,0)
|
---|
| 118 | ;;=This field contains a brief textual description of the SORT FIELD and
|
---|
| 119 | ;;^DD(.4014,12,21,2,0)
|
---|
| 120 | ;;=the SORT CRITERIA used on it (i.e., the from/to values). This
|
---|
| 121 | ;;^DD(.4014,12,21,3,0)
|
---|
| 122 | ;;=description can be printed in the heading of a report, at the users
|
---|
| 123 | ;;^DD(.4014,12,21,4,0)
|
---|
| 124 | ;;=request.
|
---|
| 125 | ;;^DD(.4014,12,23,0)
|
---|
| 126 | ;;=^^2^2^2930115^
|
---|
| 127 | ;;^DD(.4014,12,23,1,0)
|
---|
| 128 | ;;=This text is build as the developer answers the FROM/TO questions
|
---|
| 129 | ;;^DD(.4014,12,23,2,0)
|
---|
| 130 | ;;=during the SORT sequence.
|
---|
| 131 | ;;^DD(.4014,12,"DT")
|
---|
| 132 | ;;=2930115
|
---|
| 133 | ;;^DD(.4014,13,0)
|
---|
| 134 | ;;=SEARCH EFFICIENCY RATING^NJ9,4^^SER;1^K:+X'=X!(X>9999.9999)!(X<0)!(X?.E1"."5N.N) X
|
---|
| 135 | ;;^DD(.4014,13,3)
|
---|
| 136 | ;;=Type a Number between 0 and 9999.9999, 4 Decimal Digits. Search efficiency number returned by Query Optimizer Routine.
|
---|
| 137 | ;;^DD(.4014,13,21,0)
|
---|
| 138 | ;;=^^7^7^2930125^
|
---|
| 139 | ;;^DD(.4014,13,21,1,0)
|
---|
| 140 | ;;=Fields are assigned a search efficiency rating based on the number of
|
---|
| 141 | ;;^DD(.4014,13,21,2,0)
|
---|
| 142 | ;;=hits found for the query (or sort) condition. The fewer the hits, the
|
---|
| 143 | ;;^DD(.4014,13,21,3,0)
|
---|
| 144 | ;;=higher the rating. A high rating indicates the criteria will more quickly
|
---|
| 145 | ;;^DD(.4014,13,21,4,0)
|
---|
| 146 | ;;=cut down the number of records to be processed. The rating will be
|
---|
| 147 | ;;^DD(.4014,13,21,5,0)
|
---|
| 148 | ;;=higher if the field has a cross-reference. The field with the highest
|
---|
| 149 | ;;^DD(.4014,13,21,6,0)
|
---|
| 150 | ;;=rating is used to do the initial loop through the file during the sort
|
---|
| 151 | ;;^DD(.4014,13,21,7,0)
|
---|
| 152 | ;;=phase.
|
---|
| 153 | ;;^DD(.4014,13,23,0)
|
---|
| 154 | ;;=^^1^1^2930125^
|
---|
| 155 | ;;^DD(.4014,13,23,1,0)
|
---|
| 156 | ;;=Calculated in the Query Optimizer routine ^DIOQ.
|
---|
| 157 | ;;^DD(.4014,13,"DT")
|
---|
| 158 | ;;=2930125
|
---|
| 159 | ;;^DD(.4014,14,0)
|
---|
| 160 | ;;=PROBABILITY RATING^NJ9,4^^SER;2^K:+X'=X!(X>9999.9999)!(X<0)!(X?.E1"."5N.N) X
|
---|
| 161 | ;;^DD(.4014,14,3)
|
---|
| 162 | ;;=Type a Number between 0 and 9999.9999, 4 Decimal Digits. Probability of field meeting the sort criteria--returned by Query Optimizer routine.
|
---|
| 163 | ;;^DD(.4014,14,21,0)
|
---|
| 164 | ;;=^^6^6^2930125^^
|
---|