The PRISM Advanced Search provides more latitude for performing ad-hoc searches. It allows a user to combine more conditions and field selection into a search.  Furthermore, a user can send the results to the Correspondence Center, printer, and even save the search for later use.  It is the most powerful of the searches.

The Advanced Search has Common Queries that can be quickly modified to search the PRISM database or you can create your own queries and name them.

The Advance Search is available in Vendor, Contract, Labor, and Certification Management.

To perform an advanced search, do the following (Create new Query):

Lets build a query called 'My First Query' that will return vendors whose gender is Female and industry is Information Technology or Construction.

1.From the Big Hamburger Menu, select 'Search...'

2.From the 'Advanced Search' tab, click 'Create New My Query'

3.From the Query Builder screen, enter the name of your new query, 'My First Query' for the Query Name field

Build the Query

1.Click the 'Add Condition' link

2.Click the 'Add Condition' link

3.From the 'Field' column, select the field associated with your query.  In this case 'Gender'

4.From the 'Operation' column, select the operation to test the field for.  In this case we want vendors whose gender is 'Equal' to something.

5.From the 'Criteria' field select from the list of genders.  In this case we want Gender Equal to Female

6.Click 'Apply' to add this condition. So far we are selecting vendors where their gender is Female...lets continue to add the second condition...and Industry is 'Information Technology'

7.Click the 'Add condition' link

8.From the And/Or' Column, select 'And'

9.From the 'Field' column, select the field associated with your query.  In this case 'Industry List'

10.From the 'Operation' column, select the operation to test the field for.  In this case we want vendors whose gender is 'Equal' to something

11.From the 'Criteria' field select from the list of Industries.  In this case we want And Industry Equal to Information Technology

12.Click 'Apply'

13.Click the 'Add condition' link

14.From the 'Field' column, select the field associated with your query.  In this case 'Industry List'

15.From the 'Operation' column, select the operation to test the field for.  In this case we want vendors whose gender is 'Equal' to something

16.From the 'Criteria' field select from the list of Industries.  In this case we want And Industry Equal to 'Construction-General'

17.Click 'Apply'

18.Click the 'Column Option' tab

19.Click the fields you want to show in your query/report then click the directional arrow to move the fields to your selected columns field.

20.Click one of the buttons (see description left) based on what you want to do with the results.

Button Descriptions:

Save - Save this query and do nothing else

Preview Results - Run the query and preview the results the results

Print - Run the query and send the results to the printer

Correspond - Run the query and send the results to the Correspondence Center

Run - Run the query and display the results

Save and Run - Save then run the query

Column Options

From the Column Option tab, you can select the columns you want to show in your query.  Consider selecting only columns that your jurisdiction uses in PRISM.