At the top of the Nav Tree is an entry field for searching within Jim2.
|
For Search to work, some or all of the options must be ticked.
|
There are a few different ways to use this search function:
▪a global search
▪a selective mode to search in more specific areas of Jim2
▪a shortcut mode to quickly search in only one area at a time
▪a wildcard search.
Global search
Begin typing in the Search Jim2 field, click the magnifying glass and Jim2 will display anything that matches the letters entered. The same thing may appear in the Nav Tree a few times. This is because Jim2 will return everything that matches any part of what has been entered.
|
Global search means searching the entire database, which is the slowest way to search in Jim2, and will also produce more results.
|
Selective search
Select the icon in the search bar at the top of the Nav Tree. The search area will extend vertically to display as follows.
CardFile and Stock are displayed by default, however any combination of objects can be chosen. As you can see, there are a lot of different options to choose from here. It is possible to narrow the search down very specifically. Each area in the search criteria has further options under each heading. Make the choices, then click OK. Enter text into the Search Jim2 field and click the icon to perform the search.
The results of the search will appear below the search field in the search results area.
If more room is required to view the results, click the icon at the top, which will collapse the selective mode area and increase the size of the results area.
Full list of searchable areas within the Nav Tree
|
|
Asset
|
Asset
|
CardFile
|
CardFile
CardFile Email
CardFile Notes
|
Cheque
|
Cheque Book
|
Contract
(also known as Project)
|
Contract
Contract Comments
Contract Email
Contract Notes
|
Creditor
|
Creditors
Creditors Notes
|
Debtors
|
Debtors
Debtors Notes
|
Document
|
Documents
|
GL Journal
|
General Journals
|
Invoice
|
Invoices
|
Item
|
Item
Item Notes
|
Job
|
Job
Job Comments
Job Email
Job Stock
|
Purchase Order
|
Purchase
Purchase Comments
Purchase Email
Purchase Stock
|
Quote
|
Quote
Quote Comments
Quote Email
Quote Stock
|
RFC Type
|
RFC
RFC Comments
RFC Email
RFC Stock
|
Return to Vendor
|
RTV
RTV Comments
RTV Emakil
RTV Stock
|
Schedule
|
Schedule
|
Stock
|
Stock
Stock Detailed Description
Stock Notes
Stock Serial Number (includes GTI number)
Vendor Stock
|
Stock Adjustment
|
Stock Adjust
Stock Adjust Comments
Stock Adjust Email
Stock Adjust Stock
|
Stock Transfer
|
Stock Transfer
Stock Transfer Comments
Stock Transfer Email
Stock Transfer Stock
|
Stocktake
|
Stocktake
Stocktake Comments
Stocktake Email
Stocktake Stock
|
|
If the user's security level prevents access to certain areas of Jim2, those objects and checkboxes will not appear in the list.
|
Search using shortcuts
To search within one area of Jim2, eg. in CardFiles, it may be easier to use a shortcut in the search field. For example, to find all cardfiles in the name of Jones, enter c:jones. Jim2 will expand the c to CardFile:, then search for jones.
|
Search within Jim2 is not case sensitive.
|
The results will show any cardfile with Jones in it. Here's an example of searching for cardfiles with the word happen in them:
|
|
|
a:
|
Asset:
|
Assets
|
c:
|
CardFile:
|
Cardfiles
|
d:
|
Document:
|
Documents
|
e:
|
Item:
|
Items (or whatever Items has been changed to in Options)
|
i:
|
Invoice:
|
Invoices
|
j:
|
Job:
|
Jobs (or whatever Jobs has been changed to in Options)
|
k:
|
Stocktake:
|
Stocktake
|
m:
|
Project:
|
Projects (or whatever Projects has been changed to in Options)
|
p:
|
Purchase:
|
Purchases
|
q:
|
Quote
|
Quotes, Leads (or whatever Quotes has been changed to in Options)
|
rfc:
|
CustReturn:
|
Return from customer
|
rtv:
|
VendReturn:
|
Return to vendor
|
s:
|
Stock:
|
Stock
|
sa:
|
StockAdj:
|
Stock Adjustments
|
sn:
|
Serial:
|
Serial numbers. Enter either a full serial number, or part of one and Jim2 will return all stock codes with any of those numbers.
|
t:
|
Transfer:
|
Transfers
|
vs:
|
VendorStock:
|
Vendor stock
|
|
The full text from the Expands to column in the above table can be used if preferred.
|
Wildcard search
Jim2 supports wildcard search. If Jim2 sees that you have entered a wild card like %, it will send that exact request straight to SQL server.
%SEARCH% will return anything with the word SEARCH in it. We have also retained simply using the key word, without %. So, SEARCH will find anything with SEARCH in it.
SEARCH% will return anything starting with SEARCH.
If you want to find something that looks for: This Search is ridiculous, the search will be %SEARCH%RIDIC%.
See https://docs.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?view=sql-server-ver15 (copy and paste into a browser) for more information.
|