U@FLTCREATE

Name

U@FLTCREATE

Description

Creates the filter, based on the value of the E@FLTSTRING variable.

Using the API in a Program

Before calling the API, set the E@FLTSTRING variable with a conditional statement.

Use the "?" symbol for any variables to be set at run time.

Input Values

Field Description

E@FLTSTRING

Set this parameter using a method described in Setting the Filter Parameter Value, and create the filter using the routine as described in the programming example below.

Return Values

None.

Programming Example

The following code shows a filter that sets the filter string, creates the filter, and then sets the to and from values for transaction dates.

      EVAL      E@FLTSTRING    = '   (((ICT-TRANS-DATE<=- 
                "?") AND (ICT-TRANS-DATE>="?"))         - 
                              AND ((ICT-DOC-TYPE = "- 
                IS")                             OR (ICT- 
                -DOC-TYPE = "RR"))                      - 
                    AND (ICT-STATUS > "?"))'              
      CALLP     U@FLTCREATE                               
      EVAL      E@FLTVDATETIME = PWSTO#WRDTN              
      CALLP     U@FLTSDATETIME                            
      EVAL      E@FLTVDATETIME = PWSFROM#WRDTN            
      CALLP     U@FLTSDATETIME                            
      EVAL      E@FLTVNUMERIC  = *ZEROS          
      CALLP     U@FLTSNUMERIC                    
      EVAL      D@CMPNY        = F1@CMPNY        
      EVAL      E@DBBEGRNG     = 1               
      CALLP     DN@DBICICT1(E@DBFILTERBEGR)