Query help with OITM & OITG

[Former Member]

I am trying to make a query that will list items and the property names that have been checked from the properties tab, but can't seem to find a way to link them correctly. Anyone ever done it successfully? If so please help on how I can do it.

Thanks

[Former Member · Accepted solution]

Hi.......

In OITM Qrygroup1 and so on is linked with OITG Item Property but no proper join.

If you are trying to bring the Properties Column wise then i would suggest you to use Pivot Report as it will be easy to build a report.

Regards,

Rahul

[Former Member · Accepted solution]

Hi DaytonHoneycutt,

Check this link.

Thanks,

Srujal Patel

[Former Member]

Hi,

There is no direct link between two tables. The fields are predefined in OITG. ItmsTypCod value holds 1 to 64 which equivalent to 64 fields namely QryGroupXX in OITM.

Thanks,

Gordon