When synchronizing my report with Teamleader I get a itgensql001 error for a custom field

Question

When synching my Teamleader report in Invantive Control I get the following error:

Unknown identifier 'cpyd.c_5_contactpersoon'.

Screenshot of error

Part of the query:

select pjtd.pjt_title          pjt_title
,      cpyd.c_5_contactpersoon customer_contact_person

This is a custom field in Teamleader.

What could be the cause of this error?

Maybe good plan to add more details on the query? – Guido Leenders Mar 27 '19 at 08:53 — Guido Leenders, Mar 27 '19 at 08:53

score 1 · Answer 1 · answered Mar 27 '19 at 08:30

When you add a custom field in Teamleader, the order of the fields will change.

In order to check which new number is assigned to certain fields, you can execute the following query:

select * from Teamleader.CustomFields.Custom_Fields_All

This will return a list of all the custom fields, with the number that is assigned to them.

For example:

So the custom field 'contactpersoon' will be 6 in this case.

This means the number of the field in the query has to be changed:

cpyd.c_5_contactpersoon > cpyd.c_6_contactpersoon

Teamleader has no code for a custom field, just a label. When the label is changed, the custom field name changes too. — Guido Leenders, Mar 27 '19 at 08:54

1 Answers1