Filter: Difference between revisions

From BR Wiki
Jump to navigation Jump to search
Line 26: Line 26:
'''String-value''' is the variable name.  
'''String-value''' is the variable name.  


For both FILTER and [[SRCH|SEARCH]] the up and down arrows now affect only the selection bar in the grid/list being presented.
For both FILTER and [[SRCH|SEARCH]], the up and down arrows now affect only the selection bar in the grid/list being presented.


===Tip===
===Tip===

Revision as of 18:23, 13 July 2013

Grid and list filter search fields are available as of BR! 4.3.

A new field type is defined (similar to SEARCH):

RINPUT FIELDS "nn,nn,15/FILTER 10,leading-attributes,row,col,grid column to search [, filter-type] [, CASE]": string-value

Parameters

nn and nn are the row and column to position the field on the screen.

The 15/ and 10 in this example are standard notation for a 15 column field where the operator can enter 10 characters.

Leading attributes can be any attributes desired (optional).

Row and col are the starting row and column of the grid or list you wish to search.

Grid column to search is the number of the grid column the filter will test against. See tip below.

Filter Types

  • LEADING - Filter searching is done left justified using only leading characters (default).
  • WORD - Each word is leading matched.
  • ALL - The entire string is searched for a match similar to POS.

CASE may optionally be used to make all searching case sensitive. Case insensitivity is the default.

String-value is the variable name.

For both FILTER and SEARCH, the up and down arrows now affect only the selection bar in the grid/list being presented.

Tip

To make all items in the list or grid searchable with the filter, a programmer may wish to add a 'secret' undisplayed column which contains all the information from each row, then by designating this column in the FILTER syntax, the operator will be able to search all the information at once.