back to top

Dealing with Columns in Infor CRM (SalesLogix) Query Builder

In Infor CRM (formerly SalesLogix) it is possible to create new Groups in either the LAN or Web Client by using the Query Builder.  Just click the + on the upper right near Groups for Add Group and you are taken to the Query Builder.  The Query Builder lets you choose both the Conditions under which items appear, and the columns that are displayed.  For example, if making a Contacts query, the Conditions tab lets you set the criteria for which contacts will show up, while the Layout tab lets you choose which Columns are displayed, and it what order.  Adding Columns can be confusing, as columns are listed based on the organization of the database, rather than what is displayed in the Client.

For example, if you were using Query Builder to set up a Contact Group, there are already a few columns listed in the Layout tab.  If you wanted to add a Column for Do Not Solicit, you would click Contact in the upper portion of Query Builder, find Do No Solicit to the right of that, and drag it down into the Layout section.

If you want to add and Industry column, that is a bit more tricky, as Industry is not in the Contact table in the database.  However, Industry is on the Account table, and the Account table is joined to the Contact table, so it is still possible.  Expand Contact in the upper portion, and you will see all the tables that are joined to Contact.  Click on the Account table, and list of columns on the right will now show columns from the Account table.  You can find Industry on the list, then drag it down into the Layout section.

Contact Customer FX for your CRM project
We let our expertise speak for itself - let us know how our all-star team can help on your CRM project
About the Author

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Infor CRM Sync for Exchange: Action Required by August 31, 2026

Using Infor CRM Sync for Exchange with Microsoft 365? Your Exchange administrator must update tenant settings by August 31, 2026 to prevent sync disruption.

[Webinar] What’s Coming Next for Infor CRM SLX and Why v10 Matters

See what’s coming next for Infor CRM SLX, including new marketing workflows, automation improvements, and reasons to consider upgrading to v10.

Disable Caching in Infor CRM SLX Web Client

In the rare case caching is causing issues in the Infor CRM SLX web client, it is possible to disable specific types of caching by making edits using Application Architect, and then deploying.

Exploring AI Options for Infor CRM v10

I've started taking a closer look at the AI capabilities built into Infor CRM v10. Over the next several posts, I'll share what I learn. From the built-in features and supported AI providers to implementation considerations, costs, and practical use cases.

Infor CRM SLX 10.0: Delegate Ownership Changes for “Everyone” Records

Learn how the new EveryoneOwnerAssignment secured action in Infor CRM SLX 10.0 allows designated users to change ownership of Everyone-owned records without requiring Administrator access.

Related Articles

Infor CRM Sync for Exchange: Action Required by August 31, 2026

Using Infor CRM Sync for Exchange with Microsoft 365? Your Exchange administrator must update tenant settings by August 31, 2026 to prevent sync disruption.

[Webinar] What’s Coming Next for Infor CRM SLX and Why v10 Matters

See what’s coming next for Infor CRM SLX, including new marketing workflows, automation improvements, and reasons to consider upgrading to v10.

Disable Caching in Infor CRM SLX Web Client

In the rare case caching is causing issues in the Infor CRM SLX web client, it is possible to disable specific types of caching by making edits using Application Architect, and then deploying.

Exploring AI Options for Infor CRM v10

I've started taking a closer look at the AI capabilities built into Infor CRM v10. Over the next several posts, I'll share what I learn. From the built-in features and supported AI providers to implementation considerations, costs, and practical use cases.

Related Videos