Querying Data


Data stored in The Edge is searchable through query forms that work in the same consistent manner throughout the program.  These query forms (e.g., Customer Find filter) allow you to specify a variety of criteria to return the specific records you seek.  Understanding how to use these queries is an essential building block to using advanced Edge features.

Whether in The Edge database or on-line store, it might be helpful to narrow results.  Suggestions for refining your search to get a more direct result of what you are looking for include narrowing by suggested retail price, by stone, by metal, and by type.  

enlightenedLeaving a filter field blank instructs The Edge to include all criteria.  For example, if you left all fields blank on a Find filter, it would return a list of all the records. Please note that depending on the size of your database, this can take considerable time for Edge to produce results. 

Here are some examples:

A.  Looking for a bracelet between $500 – $1,000 suggested retail?

a.  Select Bracelet from the Generic Desc drop-down menu.

b.  In the Price Range fields, type 500 in Min and 1000 in Max.

B.  Looking for Amethyst earrings?

a.  Select Earrings from the Generic Desc drop-down menu.

b.  Select the Stones tab, select Amethyst from the Type menu.
 

NOTES when using filters:

  • Wild cards can be used in filters.  For example, entering 1** will return all categories in the 100s.
  • Filter parameters are cumulative.  That is, the more parameters you enter, the fewer items will be returned.  For example, if you enter a category and a keyword, only items with matches in BOTH fields will be returned.  This applies to parameters on all the tabs.
  • Because this information is specific, if you search by ID, no other search criteria will be used.

 

Updated on Mon, 26 Jul 2021 by Angela Chiaravalle

Glad we could be helpful. Thanks for the feedback.

Sorry we couldn't be helpful. Your feedback will help us improve this article.

How helpful was this page?