Payload:

HOW TO USE GRIDVIEW OBJECT SORT Data can be sorted with click on column header name. Arrow shows current sort. Click on the same column change descending/ascending order. Some types of columns cannot be sorted due to database limitation. FILTER When filter is available use it for search string. Space between data is the same as logical AND Example: filter with string 'earth sky' returns all records that includes earth and sky in searched column (do not use apostrophe). Search on numeric or date fields: use prefix <,>,<=,>= or =. Example1: filter with value '=100' returns all records with exact value 100 in searched column. If sign '=' is omitted then filter use text mode for searching and returns values like: 1231005, 27100,1008987 etc. Example2: Date fields usually includes time information. In this case search filter with value '=1.1.2005' returns records with exact the same value. For all events within that day use interval like: '>=1.1.2005 <2.1.2005'. Filter returns all records with value the same as or greater than 1.1.2005, 0 hours, 0 minutes in 0,0 seconds and simultaneously all records with smaller value than 1.2.2005 – this are all events for day 1.1.2005. Example 3: When timespan support is enabled then you can search for time span within one day. Filter value 1.2.2007 returns all records between 1.2.2007T00:00:00 and 1.2.2007T24:59:59,999… Filter value >=1.2.2007 <=3.3.2007 returns all records between 1.2.2007T00:00:00 and 3.3.2007T24:59:59,999… Logical NOT: use prefix '<>'. Empty values: use expression '<>00' for non empty values and '=00' for empty values. Add new filter with click on first word 'Filter'. Remove last filter with click on last word 'Filter'. More filters use logical AND between them. For OR operator use reserved case sensitive word OR between search values within same filter or on the end of field for next filter. SAVE SETTINGS Settings like filters, sort, page, etc are described in URL. Just save URL into your Favorites folder. EXPORT DATA When available data from whole table (considering sort and filter but ignoring pages limitations) can be exported to clipboard with click on record counter under the filter. Paste clipboard data to Excel or Access. Note: by default is export to clipboard disabled in FF, but enabled in IE.