Showing results for 
Search instead for 
Do you mean 

Boolean Logic Search Capabilities

Status: Available in Sage ACT! 2012
by Portage Personnel on ‎03-08-2010 08:03 AM

We are a Temporary Staffing Service. We use ACT to track resources currently on Payroll, Assignment with other employers and those Currently Available. We can invoice directly from ACT as well as complete a multitude of other administrative task.


We leverage the power of the Groups function to quickly narrow the employment category. From there, if a specific skill or set of skills are sought, we need to use the Advanced Look Up query. It works but takes a long time to build.


I would love if ACT could provide the search functions similar to those of Boolen Logic. Boolean Logic is nothing more than the language used to tell computers exactly what we are looking for. It is a series of commands and operators that combine keywords into meaningful phrases for our search engines. Let’s take a look at the basic commands AND, OR, AND NOT and NEAR and the three basic operators; quotes, parentheses, and wild



It's very similar to the Advanced Look Up but is much more user friendly.


Anyone have any ideas?

Status: Available in Sage ACT! 2012
This is available using our Universal Search engine.
by Nickel Super Contributor lkamerman on ‎03-12-2010 07:53 AM
Hrmmm... just to clarify, you'd like to be able to do those sort of searches with boolean operators against a specific field, or?
by Master on ‎03-12-2010 07:37 PM
Have you tried Google Desktop? I haven't, so I can't say that it would even work, however if it does then I imagine it would meet your needs well.
by Portage Personnel on ‎03-15-2010 05:06 AM

The ideal scenario would be to search within the Notes field/Tab only. There I could paste the resume. Each file would have only one resume pasted in the tab.


From anywhere in ACT, we could select an icon, say a search icon. We then type in our criteria and it would run (looking for info in the in the Notes tab only).


The rest would remain the same as an advanced query (preview, create look up, etc.)


ACT is based on SQL and SQL has the same logic and operators as Boolean. Here's an article which explains SQL searches in full.


I don't understand why ACT won't index it's tables. An already good CRM would be so much more powerful.

by on ‎08-20-2012 11:37 AM
Status changed to: Available in Sage ACT! 2012
This is available using our Universal Search engine.