Sage SalesLogix
  • Contact Us
  • Sage North America
800-643-6400
Welcome Twitter Facebook LinkedIn
turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Community Home Blogs Share Ideas Search Request Access Resources
Idea Options

Lookup Condition

Status: New Idea
by Copper Super Contributor anoshwadia 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!

 

Thanks!

Anosh

Comments
by RJLedger on 11-14-2011 03:05 PM
Options

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

   Contains

   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 Bronze Elite Contributor on 11-14-2011 09:17 PM
Options

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....

We want to hear your cool ideas for enhancing Sage 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