Queries and Filters

 Top  Previous  Next

Queries

Any type of query, using standard query language (SQL).

 

In addition, TEXTSEARCH queries can be done. To run a TEXTSEARCH query:

       TEXTSEARCH('search phrase' in FieldName)

 

E.g.:

select * from checks where TEXTSEARCH('good fair' in Memo)

 

In this case, search was for the words "good" AND fair. For an OR search, write OR in the select statement.

Wildcards can be used.

 

Examples:

1.Find the magazines paid by credit card last March.
2.Search by repository, date, or budget, which are indexed items.
3.Set filters, such as: check numbers > 0 and tax deductible and paidto/from = 'Science...'

4.        Change values in the tables based upon conditions.

5.        Sample queries are given in Help|Queries, for you to cut and paste into the query box, and modify to your needs.

 

You can use either queries or filters, whichever you find easier. To use a filter, click on the menu item Filter Dialog. This will bring up a dialog box for you to select a certain value or a range of values. You can specify a partial string, such as paidtofm='Sci*'.

 

Some filters are automatically set.

 

Examples:

1.Table advance,  dbchecked=Y. This is the table of future transactions. This means you see only things relevant, that is, future items. Clear the filter to see the others.
2.Table chfi,  activ=Y. This is the table of repository accounts. You see only active accounts. To see all, and possibly reactivate an inactive account, clear the filter.
3.Table budget. This is the table of monthly expenses. The date is the first day of the month of the chosen date. Clear the filter to see all items.
4.Table paidto, activ=Y. This is the table of payees. Again, you see only active payees.