Query / Search Report Filter Creator

FASIS Administration Advanced Query users can use this process in query to match results to a long list of values (such as EmplIDs, Position Numbers, DeptIDs, Project IDs, and more). This page can also be used to reformat a list of values for use in the BI FASIS Employee Search Report and any FASIS Administration page search.  For assistance, please contact Chris Tondini at tondini@northwestern.edu.

Type of Output to Create:
      

List of Values to Match:
(1 per line; no quotes or apostrophes)


Table Letter and Field Name to Match:
(see the "Query" tab in Query Manager)

 . 


Should your results match or exclude these values?
   

      Clear All Values





What to do Next:

  1. Go to the EXPRESSIONS tab, and choose "Add Expression."
  2. Copy and paste the exact Expression above, and click "OK." (Expression Type and Length can remain at the default "Character" and "1" values.)
  3. Go to the CRITERIA tab, and choose "Add Criteria."
  4. For the first half, choose the "Expression" radio button, click the magnifying glass, and select the Expression you just created.
  5. Set the Condition Type and Constant as "Equal To" and "1".
  6. Click OK to save the criteria!
  1. Open the FASIS Employee Search Report in the BI Reporting tool.
  2. At the top of the first page of prompts, choose "Employee Search" and click the "Select and Click to Reprompt" button.
  3. Copy and paste the exact list above into the "Keyword" box at the bottom of the page.
  4. Click "Options" and select "Contains any of these keywords."
  5. Click "Search."
  6. Under the Results box, click "Select All" and "Insert". Add any other prompts as necessary and run your report!
  1. Navigate to the search screen on any page in FASIS and locate the field you are searching on (e.g. EmplID).
  2. Using the drop-down box for that field, change the operator to "in".
  3. Copy and paste the exact list above into the search field, and click "Search".
  4. Results for each record will be displayed. Click the first one, and use the page's "Next in List" button to navigate through all records without the need to re-search.