Saleslogix Sdata Doesn’t Like Tables in Lowercase

I recently ran into an issue with a client’s system who was using SQL views as entities.  This is a powerful capability of Saleslogix but there is one caveat.  Make sure that the Saleslogix view is in all caps.  When you add the view as an entity, one of the attributes that gets generated is the entity’s “Table Name” property.  This will match the underlying case of your SQL view.  There is however, Sdata feed code that will assume the table name is all caps.  And while SQL is not case sensitive, the Sdata feed is case sensitive so when it goes to look for the entity with the “Table Name” of X when your entity has had it’s “Table Name” property set to x, the Sdata feed will fail.

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!