Filter: Difference between revisions

From BR Wiki
Jump to navigation Jump to search
No edit summary
Line 21: Line 21:
'''Row and col''' are the starting row and column of the grid or list you wish to search.
'''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|tip]] below.
'''Grid column to search''' is the number of the grid column the filter will test against. If FULLROW is used then all cells will be searched. See [[#Tip|tip]] below.


====Filter Types====
====Filter Types====

Revision as of 20:14, 29 October 2015

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

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

For example:

RINPUT FIELDS "4,50,15/FILTER 10,,10,10,2,ALL": Findfield$

Parameters

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

Size/ and Characters signifies how large the filter field will be in columns, and how many characters can be entered into it. In the example, 15/ and 10 provide 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. If FULLROW is used then all cells will be searched. 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).
  • FULLROW - Will search each cell in a row.

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

String-value is the variable name which will apply to whatever the operator enters into the field for searching.

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

Note

  • FILTER is subordinate to MASK.


See Also