Problems in SalesLogix v8- Bundling SQL Result Sets

I recently ran into an issue trying to use the old SQL Result Set action in the SalesLogix bundle process.  When you choose this action you go through a process of selecting the table you want to bundle data from and then adding conditions to define what records from the table you need.

Normally if you wanted to get all records in a table where a field started with a value you could do something like this in the query builder:

 

But if you look at the SQL of the result it is not formatted properly:

 

The result is nothing is saved into your bundle.

 

Instead what you need to do is something like this:

 

Notice you have to use “Contains”.  If you use “Starts With” the resulting SQL is not valid:

 

Hopefully Swiftpage will get this fixed at some point.

ABOUT THE AUTHOR

Kris Halsrud

Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!