Searching the Database

About Searching the Database

When you execute a search command either in Simple Search or Standard Search, the search results obtained are a snapshot of the data that pertains to the items, companies or categories searched. The items can be all items, internal items, supplier items, or manufacturer items. Similarly, company can be all companies, internal companies, supplier companies, or manufacturer companies. The data is stored in a table format, and the information is displayed in columns and rows within the Search Results page. The rows represent the list of objects, and the columns represent the attributes of  the objects. Sometimes, searches can return a large amount of data. Therefore, you should make your searches more narrow in scope in order to return a search result that focuses on a more specific set of data.  A few options that will assist you in narrowing your scope are identified below:
 
  • Viewing Additional Information: For every row displayed in the Search Results page, you can activate a contextual menu. This contextual menu allows you to view additional information about the data represented in the row.
  • Specifying Valid Values: The results displayed in the Search Results page can be further filtered by launching the Valid Values and Query Builder functionality. Using the Valid Values, you can select the values for the respective attributes.
  • Sorting Results: In the Search Results page, you can sort the results in either ascending or descending order. You can select a set of results to be displayed by specifying a batch size, and pagination.
  • Filtering Data: From the specified search criteria if the result obtained contains large data, you can filter the results by category, which enables you to see only the desired results.

The search results are useful, also with respect to:

  • Viewing the Properties page for related information of a result row.
  • Launching the corresponding internal item part in VPM Lifecycle Navigator Web
  • Starting other related functions from the Search Results page based on the context.

The search results forms the basis for most of the tasks in CES. The following capabilities are included in search results:

About Search
Quick Search
Category Attribute Search
Simple Search
Standard Search
Using Valid Values
Using Query Builder
Using Wildcards and Operators
Viewing Category Browser