Limiters or data display filters can limit the number of records included on a specific main report or nest report. You can limit selections by field, current checkbox, and sequence.

1. From the main report or nest in which limited data is desired, click the SQL icon.
2. Click on the Where tab (on the bottom grid)
3. Under Column, select the desired column name from the dropdown menu. The desired column name will be the field name that should be limited. It should read "table name"."field name" (e.g. "task"."task"). This field does not have to appear in the report to limit the search.
4. In Operator field, =.is the default operator. If a different operator is desired, click to make a selection from the dropdown menu.
5. Click on the Value column to enter the value to be matched. If a field name is the value, enter the field name surrounded by single quotation marks (e.g. 'Fine Art').
6. To include two or more selection criteria, simply go down to the next line and repeat above. The logical field will default to an "AND", but you will more likely need an "OR. "AND" means both criterion must be met, "OR" means one or the other must match, but both need not. When using more than one match criteria, include an open parentheses at the beginning of the table and a close parentheses at the end of the table.
7. Click on the SQL icon again to return to the report or nest.

Example: "activity"."type"='accessioned' would yield a list of accessioned activities, and filter out everything else.

Example: "Object"."Collection" (really is collection type ) = 'Fine Art' yields only Fine Art collection object records.

Example: A limiter for a Dead of Gift form may require that the party_role always = donor. (See the report Activity-nest_deed_of_gift_text for a good example of limiters.)

You could as easily conduct the search in Argus before your ran the report. The report limiter will override whatever you pull up in your Argus search. You wouldn't want to use this on a superfield because it wouldn't use the lexicon to find sons and sisters. It would only look for the word specified in the value field.

Example:

Example:

Limiters can be applied to nests within the report. One report could have multiple date nests and you could choose where you want the dates to show.

Sequence limiters are based on an internal sequence field Argus assigns to your data field. If you have multiple parties, for example, a sequence number is assigned to each party (or image, as another example). You can restrict which party (or image) is drawn up. Sequence limiters always show only the the first instance of that field. Sequence limiters pertains to things like addresses and party if there are multiples and are based on how good your data consistency has been. There is however, a resequence utility.

Example: You have several date ranges, you only want to see the first one.

1. In object-nest-date_range report, click SQL
2. In the Column column, choose "date_range" . "sequence"
3. In the Operator column, choose =
4. In the Value column.type 1 (or desired numerical sequence).

To See if a Table has a Sequence Field

1. In SQL, right click on a white space.
2. Select a table.
3. Click Open and see if there is a "sequence" field.
   This tells you if you can use sequence on any particular table.
4. Right click on top of table and Close.

Note:Always put the most important sequence data first!

Current limiters apply only to Argus locations, conditions and values. A value of "Y" will pull up only those with a current checkbox selected.

1. Click on SQL.
2. In the Column column, choose "Obj_locations.curr"
3. In the Operator column, choose =
4. In the Value column.type Y.