Grouping and Sorting by Queue
Another handy function is the ability to group grids by columns other than the default column. You can also sort the information in the column in ascending or descending order, and filter the information shown in the column.
- Group the Grid by Column: To group a grid by a column, simply click and drag the columns in the order you choose.
- Sort the Column Contents: Click the column header or the up/down arrow to switch the column contents between ascending and descending order.
- Filter the Column Contents: Click the Sort icon located on the upper right corner of the column header (it looks like a thumbtack) and select the filter you want to use.
Each Request queue (state) on the ILLiad home page opens to display the requests in a grid. Staff can customize the layout of grid headings and values by moving or renaming columns and arranging value orders to suit individual needs and preferences. The customizations are stored in the database for each staff user.
Exporting Values from Grids
You can export data from most grids in the Requests group by right-clicking on any column header and choosing Export from the menu. You can export data in Excel, PDF, HTML or TXT type.
The exported file retains the column ordering and grouping of the data.
Searching and Filtering a Grid by Keyword
Pressing Ctrl-F on your keyboard within the grid view will bring up a search bar that allows you to search and filter a grid by a keyword or phrase. This function is useful if you are looking for something in particular within that grid or if you would like to filter the grid to only display content containing a certain word or phrase.
The Client will automatically begin to filter the grid by your inputted text while you type into the search bar. You can also press Enter on your keyboard or click the Find button when you are finished typing your query to apply the filter. To clear the filter and return to the default view, you can click either the X button to close the search bar or the Clear button to clear the inputted text.