|
|||
|
|||
Hi Commit,
I cannot figure out this one. - I can access the CommitCRM data by ODBC for read-only purpose (SQL). OK. - I can retrieve all assets where customer = 'CRDSRME5BLXO74WZOXG0' and CommitField FLDASTMODEL = 'HP' - This works perfect. OK. But, I cannot retrieve all assets where customer = 'CRDSRME5BLXO74WZOXG0' and CustomField FLDUSRASTQCMWVC3SEAR = 'Yes' The customer recid is not included in the Custom table - only the recid of the corresponding asset. Do you have a suggestion for this. Thanks. |