The Companies Power Search capability provides a very flexible and powerful way to combine low-level queries into higher-level compound queries. A high-level query can be cataloged and re-used. The top half of the Companies Power Search form is for building, saving, retrieving and executing Power Search queries. The bottom half of the form is for building a matrix to rank the search results. A separate utility provided in the Deskflow Administrator module allows a User to edit the dictionary of low-level queries, and to add new queries to the dictionary.
•To clear the screen of previous search forms, click Clear All.
•To create a Companies Power Search form, click Add Line, then click Add New Regular Search Line.
•Add more lines as needed, then program each line with a low level query, a condition clause, and search text.
•Link each line to the previous one with an AND/OR connector, and add brackets for OR lines.
•To execute a Companies Power Search, click Search.
•To save the results of a query, click Save Current List As….
•To print a report from the query result set, click Print and select a report in the Reports Manager Companies folder.
The general structure of a Companies Power Search query is:
QUERY1 AND | OR | AND_NOT ( QUERY2 OR QUERY3 OR QUERY4 )
where QUERY1, QUERY2 etc are BASIC queries on a set of database fields and/or documents
Samples of BASIC queries with names are provided in the Companies Power Search Appendix.
More BASIC queries may be built using the Administrator utility.
In Companies Power Search, each BASIC query returns a set of CompaniesIDs.
Example: Companies Power Search Structure
Line |
Connector |
Br |
QueryName |
Operator |
Parameter |
Br |
1 |
( |
QUERYNAME |
OPERATOR |
PARAMETER |
|
|
2 |
CONNECTOR |
|
QUERYNAME |
OPERATOR |
PARAMETER |
) |
3 |
CONNECTOR |
|
QUERYNAME |
OPERATOR |
PARAMETER |
|
4 |
CONNECTOR |
|
QUERYNAME |
|
PARAMETER |
|
CONNECTOR has drop down values of:
•AND
•OR
•AND NOT
QUERYNAME examples are shown in the Companies Power Search Appendix.
OPERATOR (also called a comparison operator) has drop down values of:
Example: Comparison Operators
OPERATOR |
EXPLANATION |
Less or Equal |
used for numeric comparisons |
Greater Than |
used for numeric comparisons |
Greater or Equal |
used for numeric comparisons |
Not Equal |
used for numeric or date values |
Like |
means string BEGINS WITH parameter |
Not Like |
means string does NOT BEGIN WITH parameter |
Is Between |
is used for numeric or date ranges. Needs two parameters |
Is Not Between |
is used for numeric or date ranges. Needs two parameters |
Is In List |
lists like NY, NJ, CT, MD |
Is Not In List |
lists like NY, NJ, CT, MD |
Is Null |
means the field is empty |
Is Not Null |
means the field is not empty |
PARAMETER is text that a User types into the box. It must match the OPERATOR type.
OPENBRACKET and CLOSEBRACKET are inserted by clicking in the small boxes provided.
An existing bracket can be removed by clicking in the box where it exists.
Basic QueryNames
QueryNames are accessible from a drop down list.
Example: Companies Power Search Queries
Companies Power Search Names |
Companies Power Search Names |
Companies by Location Phone (Phone 1) |
Company by Parent Name |
Companies Without Industries |
Company by PostalCode |
Company by Alias Name |
Company by Product |
Company by Branch |
Company by Province/State |
Company by City |
Company has Person |
Company by Location FAX (Phone 2) |
Company in Target List for Project Code |
Company by Location Type |
Company is in a List |
Company by Marketing Status |
Company Main Phone |
Company by Name |
Company with multiple contacts |
Company by Name or Known As |
Company with only one Contact |
Company by Notes |
Search in CustomField5 |
Examples of a Power Search
Example: Companies Power Search using an initial Companies list
Example: Companies Power Search on four data fields using editable parameters in the last column
