GRID: Search (QBE)
See also general description of XTG Grid.
If you want to search,
- select column
- select operator by clicking right mouse button in the search area (the second title line)
- type value (use Bksp for deleting)
Search operators:
You can combine searching conditions of more columns:
CUST_ID>800 and VATID is not null and NAME like '%ALEX%' and CITY like 'PRAGUE%'
There are 2 search modes in the AQueryx: DB and GRID displayed in the status bar.
Please read following Search Example and Pictures descriptions.
Search Example:
I want to find customers from Prague who has VATID filled in.
1. Type a 'select' command in the edit field (or use Tables and ShowExpression/SelectedColumns):
select CUST_ID, VATID, NAME, STREET, CITY, ZIPCODE from ACUSTOMER;
and run it by Ctrl+Enter
Search status: DB: 500 / ??? (see Pic1)
2. VATID - operator IS NOT NULL (see Pic2)
Search status: GRID: 263 / 500 (see Pic3)
Ctrl+Enter
Search status: DB: 500 / ???
3. CITY - operator like 'PRAGUE%' (see Pic4)
Search status: GRID: 46 / 500
Ctrl+Enter
Search status: DB: 127 / 127
It means that all searched rows was fetched. The number of rows that agree with actual search condition
is 127.
Current statement (use show expression):
select CUST_ID, VATID, NAME, STREET, CITY, ZIPCODE from ACUSTOMER
where VATID is not null and CITY like 'PRAGUE%';
Of course, you need not to run Ctrl+Enter after each search criteria. In that case, grid may be empty
(GRID: 0 / 500) because none of 127 corresponding persons was not in initial 500 fetched rows. You can
enter all search conditions and then run Ctrl+Enter (real SQL command).
Pic1: DB: 500 / ???
It means that 500 rows (of unknown quantity) was fetched from database to grid
Pic2: VATID IS NOT NULL
Pic3: GRID: 263 / 500
It means that 263 rows (of 500 fetched rows) agree with actual search condition in the grid
Pic4: CITY LIKE 'PRAGUE%'