Sunday, March 10, 2019

ODBC > Access Project table

There is no separate Project table available in ODBC, as it is treated as a Entity it needs to be accessed via Customers table. Use the query below to extract the Project record via ODBC.

select * from customers where customer_id='xxx'; // customer_id is the internal id of the Project record

The "Project" Record is often mentioned as "Job".

No comments:

Post a Comment