Hi everyone!,
I have a dependency challenge regarding the relationships and filters in CMDBuild.
I have classes A, B and X.
A & B are master/catalog tables. A & B are fields of REFERENCE type in class X
B is related (has a foreign key, N:1) to A, like A are countries and B are the states of a country.
X is related (N:1) to classes A & B.
In summary the dependencies/foreign keys are:
B–>A
X–>A
X–>B
When I’m completing the fields of class X, after I enter the value for class A (countries), I’m going to enter the value for a field of class B (states). I’m expecting to see only the values of class B which are related to the value of class A.
However I don’t know the syntax of language CQL to enter in the filter of field B in class X.
This is my try:
from classB where Id IN (/( select "Id" from public."classB" where "fieldRef_classA" = "{cql:fieldRef_classA::text}" )/)
And my error:
PSQLException: ERROR: column "{cql:fieldRef_classA::text}" does not exist
I’m running version 3.4.4 of CMDBuild.
Thanks in advance,
Guido.