Custom fields for Assets, ODBC

[itognet]

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.

[lpopejoy]

Re: Custom fields for Assets, ODBC

Something like: select * from assets inner join cards on assets.cardid=cards.recid inner join customitablename on assets.recid = customtablename.recid where ...

That's all from memory, but you get it.