Grids in Journease
Using the filter on grids
Â
Quick Search Filter
The column that is being filtered is shown in square brackets [ ] after the Quick Search heading (in the example shown this is searching on the Customer Name column).
Using this as an example simply type Part or ALL of the customer name that you are searching for and click on the green search icon to filter the list to Customer Names CONTAINING the search text
Use the red cross icon to cancel the filter
Â
Â
Â
Advanced Search Filter
Use the Select a data field to select which column you are filtering by
Select the type of filter
like Find entries that CONTAIN the given text
= Find the entry that matches the given text exactly
Enter the search criteria (the text that you are searching for)
Click on the green + button to add another level of search
for the additional search lines you can select between AND and OR for the connection between filters
Click on the green SEARCH button to activate the filter
Click on the red Clear button to clear all current filters
Â
Â
Â
Column Filter
To filter for a specific column when an advanced filter is not available
Move the mouse cursor to the top right of the header in the column you wish to filter
Click on the Menu Button
Click the Filter Button
Select the type of filter that you wish to use from the drop down box
Enter the text that you wish to filter for in the Filter… box
As you type the text additional filter boxes will appear below to enable multiple filters on the column
Menu Button
Â
Filter Button
Column Order
To alter the column order:
Find the column you want to move
Click and hold in the column header
Drag the column to the new position
Release the mouse button
Click the Save Layout button
Â
Save Layout Button
Â
Â
Â
Column Pinning
Pinning the column to the left or right of the Grid will allow you to scroll through the rest of the columns whilst keeping that column in place and visible.
To pin a column:
Move the mouse cursor to the top right of the header in the column you wish to pin
Click on the Menu Button
Hover over Pin Column
Select Pin Left, Pin Right to pin the column at the respective side of the Grid
Select No Pin to remove the pin for that column and put it back into the scrollable Grid
Menu Button
Â
Â
Â
Show / Hide Column
To Show or Hide columns in the Grid
Move the mouse cursor to the top right of the header in the column you wish to pin
Click on the Menu Button
Select the Column Choice button
Tick the columns that you wish to Show
Untick the columns that you wish to Hide
If you require a specific column to show in a grid that is not currently present, contact Journease Support where we may be able to add it for you.
NOTE: This may incur a Development Charge depending on the amount of work required
Column Choice Button
Â
Â
Page Size
If you have your page size set to the default (25), when exporting Journease will ONLY export the top 25 rows.
Use the drop down next to the selected number
This drop down has default selections of (25, 50, 100, 250, 500, 1000)
There will also be a final option which will differ depending on the number of rows available in total (e.g. if there are 1042 lines in total then this last option will show 1042)
Select the number of rows that you wish to display on a single page (NOTE: this will reset each time you open the screen)
Â
Page Size
Â
Â
Navigating the pages
In the bottom right of the Grid you will have information about the current viewed page and controls to move between the pages of the Grid
In the example image we can see that:-
We are currently looking at rows 1 to 25 out of a total of 1,419 available rows
We are currently looking at Page 1 out of a total of 57 available pages
We have controls to move between the pages
|< = Move to first page
< = Move back by one page
> = Move forward by one page
>| = Move to last page
Â
Â
Â
Information and Controls
Page Size / Number
When exporting a Grid:
Page Size is very important, if you have a Page Size of 25 then Journease will ONLY export 25 rows of data.
Make sure that you adjust your Page Size to match the number of rows you wish to Export
Page Number is another way to select how many rows you wish to export
If you are viewing Page 1 and export then Journease will export all data on Page 1
If you select Page 2 and export then Journease will export all data on Page 1 AND 2
Page 3 will export data from Page 1,2 AND 3 (and so on until you are viewing the last page which will export ALL data)
Â
Â
Â
Â
Export the required Grid Data
Once you have the correct Page Size / Number set:
Right Click anywhere in the Grid
Select the Export item from the list
Select the Export Type (CSV or EXCEL)
This will then export the required Grid Data to the Downloads folder on your machine
Export Type
Â