Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 8
Next »
|
The browser in Journease is a very powerful tool and should be the first point of contact when you wish to search for anything in your database. |
- In the Views section, select a radio button associated with the type of search that you wish to undertake
- In the Criteria Selection (Filter) section see if there are any Pre-Defined Criteria that will make your search easier. To add Pre-Defined Criteria, click on the New button next to the drop-down box, enter a name for the Pre-Defined Criteria, then fill out the search as shown in the below example and click the save icon.
- If you know the primary field item that you are looking for (i.e. Job number when searching for jobs, Invoice number when searching for invoices etc.) then type this into the Quick Find text box and it will highlight the item you are looking for.
If you don’t know the primary field that you are looking for or you wish to undertake a more detailed search then enter criteria in the various fields in the Criteria Section, this is done by selecting relevant search functions from the drop-down boxes. Click on the green Apply Criteria button to run the search.
|
fig 1.1 | |
Example. I know that we have a customer called Zebra, I wish to list all jobs with “Zebra” as the customer name. - On the right I select Jobs_No Addresses radio button
- In the first Field drop-down box, I select Customer
- In the Operator drop-down box, I select Like
- In the Criteria text box, I type Zebra
So now my Browser looks like fig 1.1. I then click the Apply Criteria tick to run the search which will bring up the result in the lower part of the screen (fig 1.2). |
The Field drop-down box will only show options relevant to the choice of radio button selected. The Operator drop-down box allows you to use simple search parameters. Operator | Meaning | Example / Use |
---|
= | Is Equal To | Used if search criteria is known exactly (e.g. Company = Zebra will show all companies called Zebra) | < | Is Less Than | Used to find items below the given value (e.g. Job Number < 17500 will show all job numbers from 0 to 17499) | <= | Is Less Than or Equal To | As above but will include job 17500 | > | Is Greater Than | Used to find items above the given value (e.g. Job Number > 17500 will show all job numbers from 17501 upward) | >= | Is Greater Than or Equal To | As above but will include job 17500 | Like | Is Similar To | Same as Equal To except whole word is not required (e.g. Company - Like - Ze will still show results for Zebra and all other companies that start with Ze) | Contains | Contains the Text Characters | Contains the text in the text box (e.g. Company - Contains - ebr will show results for Zebra as well as any other companies with ebr in their name. | In List | Has a value equal to that in the given list | This will only return items that match one of the list items exactly, the list items should be in a comma separated list (e.g. No. of pieces - In List - 1,2,3,10 will only return results where the number of items is 1 or 2 or 3 or 10 but not 4-9. | Between | Is Between these two Dates (this will change the text box to two date lookup boxes) | Used for searching for a specific date set, if it is a single date you are looking for then input the same date in each date box. |
Once you have completed your search, double clicking on the required item in the list will open the relevant page (Invoice page for invoices, Job Screen for Jobs, etc.) At any time, you can clear all the results and search criteria by clicking on the Clear Criteria Eraser. You can do a more detailed search by adding criteria using the remaining drop-down boxes (e.g. Customer | Like | Zebra AND Depot | Like | Main will bring up all customers called Zebra who have a depot called main). The AND drop-down box can be changed to OR (e.g. Customer | Like | Zebra OR Job Number | < |1000 will bring up all customers called Zebra and all jobs with Job numbers less than 1000) Simple searches can also be done from within the specific window. For instance, if you are looking for a specific Supplier/Driver then you can open the Lookup>Supplier/Driver window and type the name in the search box. This will do a Like search only. |