Error When Trying to Use HQL DataSource to Control a SmartPart in SalesLogix

Question: In SalesLogix I am trying to use HQL DataSource to control my
SmartPart.  I am using a HQL DataSource control and a datagrid, and have
given all the properties names, named the tables in my property window
and mapped it to my datagrid.  I receive this error: 

OPPORTUNITY_CONTACT
is not mapped (select CONTACTID from OPPORTUNITY_CONTACT)

Where did I go wrong?

Answer: HQL goes after objects while SQL goes after fields and tables.  You need
to define the fields and tables in an object – XML file for what you
have – because referring to a missing object in an HQL statement gives
you an error.

 

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!