Blog

Quick Searches

What is a Quick Search:  It is a BAQ that the user can manipulate by entering in parameters.  Works similarly to a BAQ Report or a Crystal Report, but is used EXCLUSIVELY as a search tool.

When to develop a Quick Search: When the user wants a BAQ to display them data after entering in parameters.

How to Create a Quick Search:

Wherever there is a ‘searchable button’ you can create a Quick Search.  For example on the Customer Maintenance Screen there is a button “Customer.”  After pressing it a “Customer Search” window will open up.  There, you will see several tabs, one of which is “Quick Search.” When finished, this is where the Quick Search will appear.

Before starting your Quick Search (QS), you must ask the user WHERE they want the quick search to operate.  The application name, AND the field/button they want the QS to appear.  For this example, the user wants a “Customer Search” in the Customer Maintenance screen.

Open the application the user wants the QS to appear.  Then click on Help à field help, make sure that “Technical Details” is highlighted, and click on the field next to the searchbutton.  This should be the field that the search button ‘feeds’ (more on ‘should’ later).  In field help you will see the table.field that is associated to this box; make a note of the table.field because you will use this later (exa Customer.CustID).  This is the ‘Key’ your QS will use.

Now you are ready to get started.

There are two applications involved in creating a quick search:  the BAQ Designer and Quick Search Maintenance.

BAQ Designer

Once you have the user’s goals, and know what table.field the search button is tied to, start creating the BAQ that the QS will use.  For the example the user wants to search Customers by their BillTo Information.  Since I know that the ‘Key’ (exa Customer.CustID) is in the Customer table, and the BillTo records are also in the Customer table, it appears the only table needed is the Customer Table.

After adding the table, navigate to Display à column Select.  Here you will select the fields that this BAQ will show.  Be sure to include the table.fields that the user wishes to see, as well as, the table.fields the user wishes to query by.  Also, ENSURE THAT THE ‘KEY’ IS ALSO IN THIS LIST (exa Customer.CustID).  If the KEY is not in the list the QS won’t work.

Save your BAQ and exit.

 Quick Search Maintenance

Go back to the application that the user wants this QS to appear (exa Customer Maintenance).  RIGHT-click in the field next to the searchbutton that you got the table.field from earlier, then select Quick Search Entry.

Fill in the fields on the Detail tab.  Make sure the BAQ is ‘pointing’ to the BAQ you created earlier.  Now, the “Return Column” is the ‘Key’ that I talked about earlier.  Make sure that this table.field matches the “Context Key” that comes from the field you right clicked on (NOTE: this does not have to be a 100% match.  But the table.fields MUST be atleast ‘like’ eachother.  For example, I have created a QS where the Return Column = CustCnt.CustID and the Context Key was Customer.CustID). 

 The “Context Key” is AUTOMATICALLY filled in based off of the field that you launched Quick Search Maintenance from.  This can cause issues with QS’.  Like I said earlier, “This should be the field that the search button ‘feeds’.”  If you find that your QS is not appearing in the QS tab it likely means the Search button is querying a different ‘Key’ than what is in the box next to it.  Investigate the button to figure this out.  Go to other applications that use the same button and use them to figure out what the button is querying.

The checkboxes to the right: Shared, All Occurrences, Context Default, Base Default, Suppress Base, Validation only do different things.  Basically, if the user wants the QS to appear in only the specific application, don’t check any of these boxes.  If the user wants this QS to appear for ANY search (this is the likely scenario) that returns the same ‘Key’, check Shared and All Occurrences.  For the example since the return column is Customer.CustID this QS will appear in all QS tabs that query the CustID.

Save your QS.

Navigate to the ‘Criteria tab, click on the new button and select, “New Quick Search Criteria.”  This is how you add your parameters.  YOU MUST CREATE AT LEAST ONE CRITERIA FOR THE QS, IN ORDER FOR THE QS TO APPEAR IN THE TAB!  Add each parameter that your user wants to search by through this process.

When adding a Parameter (Criteria) choose the table.field that the parameter will query against, and the caption of the parameter.  Next is the condition, choose appropriately here, but a good rule of thumb is to always go with ‘BEGINS’.  The reason being it gives the user flexability in their search.  The only reason I could see NOT using BEGINS is if the parameter is a true/false.

Save your QS after entering in all of your Criteria, and log-off then back on to Epicor.

Now when you go to the application you created your quick search in, click on the search button, and then the Quick Search tab, you will see your created QS.  Select it, and click ‘Search’

Then the QS will appear.  You’re done!