| Last change
 on this file since 800 was             628, checked in by George Lilly, 16 years ago | 
        
          | 
initial load of FOIAVistA 6/30/08 version
 | 
        
          | File size:
            532 bytes | 
      
      
| Line |  | 
|---|
| 1 | FSCQO ;SLC/STAFF-NOIS Query Optimize ;1/11/98  18:46 | 
|---|
| 2 | ;;1.1;NOIS;;Sep 06, 1998 | 
|---|
| 3 | ; | 
|---|
| 4 | OPTIMIZE(CRITERIA) ; from FSCQS, FSCRPCQ | 
|---|
| 5 | ; ***needs algorithm to assign order to steps in fconds | 
|---|
| 6 | N STEP,FCOND,FIELD,SOPT,FOPT | 
|---|
| 7 | S STEP=0 F  S STEP=$O(CRITERIA(STEP)) Q:STEP<1  D | 
|---|
| 8 | .S SOPT=STEP,CRITERIA("O",SOPT)=STEP | 
|---|
| 9 | .S FCOND="" F  S FCOND=$O(CRITERIA(STEP,FCOND)) Q:FCOND=""  S FIELD=$P(CRITERIA(STEP,FCOND),U) D | 
|---|
| 10 | ..S FOPT=FCOND | 
|---|
| 11 | ..S CRITERIA("F",FIELD)=$P(^FSC("FLD",FIELD,0),U,3,6) | 
|---|
| 12 | ..S CRITERIA("O",SOPT,FOPT)=FCOND_U_$G(^FSC("FLD",FIELD,2)) | 
|---|
| 13 | Q | 
|---|
       
      
  Note:
 See   
TracBrowser
 for help on using the repository browser.