...

In the Grid results, you can scroll down through all of the data and it gets loaded as you go.  This means there is no limit on maximum records that can be returned, and no "page numbers" to deal with to see your results.  Clicking on a row in the grid brings up a highlight view of the record you are on.  To remove the summary view the user can click on the row again or click on the  in the corner of the view.

Filter

Users will be able to filter grid results directly via a "filter row" Image Removed. The filter row contains white box's under each heading.  The Image Added

The default for any text search fields is to select fields fields starting with with the value that you enter.  You may use also include '%' as a wildcard to find fields containing a value.  For example, '%abc%' would select records with 'abc' anywhere in the field.  Date  The default for date fields and other numeric fields will appear as a range of values.

The following table shows valid symbols and it's meaning that can be used when filtering data:

Image Removedis to select values greater than or equal to the value entered.

You can also filter using any of the following. For example, typing in "=1000" will find all records where the value in that column equals 1000.  Similarly, typing in ".eq 1000" would also find the same results.

• =value or .eq value will select all records equal to the value entered
• > value or .gt value will select all records greater than the value entered
• >= value  or .ge value will select all records greater than or equal to the value entered (default behavior for numeric fields)
• < value or .lt value will select all records less than the value entered  
• <= value or .le value will select all records less than or equal to the value entered
• <> value or .ne value will select all records not equal to the value entered
• ~ value or .like value will select all records starting with the value entered (only works for text fields; this is the default behavior for text fields if no operator is entered)
• *= value1,value2,value3 etc. or .oneOf value1,value2,value3 etc. will select records containing one of the values listed
• value1..value2 or .between value1,value2 will select records between the values listed 

Sort

Users can sort any column by ascending or descending order by simply clicking on the column header name. To sort by more than one column at a time the user would click on the column header name they wish to sort by first and then hold down the shift key and click on another column header name. The columns are noted with a number beside the column name to show the order it was sorted. The sort can be reset by clicking on any column header name.

...