custom field filter issue scope (AQL), dot notation doesn't work

[G. De Fazio]

Hi,

     for customer portal configuration I'm creating 2 different asset type (Contatti and Edificio), the first asset reppresent people and the second one the building.

For the Contatti custom field I have no problem and I created it with the custom field 10103; Problems spawn when I try to filter Edificio (custom field 10146) with the attribute Azienda of Contatti object.

What I want to do is filter buildings based on people's company using the dot notation but I have some problems:

Azienda (Company) is a field in both classes but for some strange reason the dot notation in the filter is wrong.

The question is: there is any OQL validator to test my query and understand where I'm wrong?

Thanks,

Giuseppe.

[G. De Fazio]

Solved!

I put another field in the middle with all company and I filtered this field using the inboundreferences function.

After this I put company visibility to hide.

[Shan McQuown]

Thanks for updating!