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

Lookup Condition

Status: Partially Implemented
by Nickel Contributor on ‎11-14-2011 12:41 PM

When you add a Lookup Control to a SalesLogix Web quickform, it seems to always default to a "CONTAINS" condition.


Many customers have asked us to change this so it defaults to a "Starting With" condition. However it looks like this change is not possible(?)


A CONTAINS condition is more expensive on the SQL server as well, especially if you lookup on a larger text field.


It would be handy if this was customizable in code so that the default condition can be set programmatically. I know it seems like a minor request, but its all about streamlining workflow and improving the user experience with the product and little things like this do matter!




Status: Partially Implemented
There is a user option to set entity lookup default value in V8.
by Gold Super Contributor
on ‎11-14-2011 03:05 PM

Unfortunately.. you will find as many people who like "contains" as those who favor "starts With".


Best solution - something in the property to be able to select:

   Starts With


   Ends With (yes, I have had people who want that ;-)



Even better.. at run-time to allow the user to do what he/she wants.



NOTE: I believe the "new" controls in 8.0 will solve the problem... but you will have to wait for it and then upgrade.

by Silver Contributor
on ‎11-14-2011 09:17 PM

Have had many customer's use the OpportunityID as a unique identifier for Opportunities that doesn't take a lot of typing.....and yes this  uses an ENDS WITH wild card....

by Moderator Moderator
on ‎08-09-2012 12:11 PM
Status changed to: Partially Implemented
There is a user option to set entity lookup default value in V8.

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?

Read our submission guidelines.

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

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

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!