Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings

Does not contain operator in SalesLogix query builder

Status: Delivered in 7.5.0
by Copper Contributor SamMitchell on ‎09-15-2011 02:32 AM

It would be really useful to have does not contain as a standard operator in the query builder in SalesLogix. SLX allows you to have "not equal to" but what if you want to blanket filter out a particular word from a field?

 

The ACT! By Sage software actually contains this functionality in its advanced query builder so I was a little surprised to find that SalesLogix doesn't have this. It should be pretty easy to implement as well. The contains is simply a "LIKE '%data%'" statement in SQL so does not contain should simply be "NOT LIKE '%data%'".

Comments
by Gold Super Contributor RJLedger
on ‎09-15-2011 05:18 AM

It's basically already there. In the web you check the "NOT" checkbox in front of the condition. In the WIndows/LAN client you right mouse (RMB) and pick "NOT".

 

The resulting SQL is not "x is NOT LIKE '%data%' - it is "NOT(x is LIKE '%data%') "

 

ACT has things/features SalesLogix does not have - in the 2010 there's support for the "Google world" and SalesLogix does not have it.. on the other hand, SalesLogix has more core functionality  - ex, the entire Support set of features - fully integrated OOTB. The target markets for the product are really different. ACT was one of the first "Contact Manager Apps", where SalesLogix was one of the first modern CRM systems... the list goes on and on. They also have different development/marketing teams. Pat Sullivan (the original creator of ACT and SalesLogix) did not even own ACT anymore when he first developed and released SalesLogix.

 

I for one (along w/many others) would like to see ACT and SalesLogix merge into one product. Just think - "SalesLogix Lite" or "ACT Heavy" ;-) BUT that will probably never happen. The time to do that was years ago when Pat bought ACT back from Symantic..

by Copper Contributor SamMitchell
on ‎09-21-2011 06:12 AM

Hi RJLedger,

 

Yes that's what I'm using to get this working. Thanks for the suggestion.

by Moderator Moderator
on ‎08-01-2012 12:14 PM
Status changed to: Existing Feature
Can accomplish using contains with the "not" flag.
by Moderator Moderator
on ‎08-02-2012 12:12 PM
Status changed to: Delivered in 7.5.0
 

We want to hear your cool ideas for enhancing Saleslogix products and services. So add your own ideas or kudo (vote) on the ideas of others here! Watch the most valuable bubble to the top!

I have an idea! How do I get started?

One
Read our submission guidelines.

Two
Search for your idea. If you don't see it, submit a new one!

Three
Provide feedback on the ideas of others by voting with kudos and adding comments.
For more information about using ideas, read this thread.

Four
Track your ideas and those you like. Once you've posted or kudoed and idea, subscribe to be notified via email of the latest updates to the idea. From within the idea, click "Idea Options" which appears above the idea title and choose, "Subscribe to this idea".

Be sure to check back from time to time to see new ideas and status updates!

Here is a quick list of the recent ideas for speedy browsing!
Labels