I have a property page with a combo field associated with with attribute (attr3), the list of values is retrieved from a DQL query.
The DQL query is based on the values of two other previously valued fields (attr1 and atttr2). I can use multiple occurrences of $value(attrx) in a DQL query for value assistance?
To better explain you the example of structure:
PRP_MY_CUSTOM_TYPE
| Control Type | Attribute Control | DQL Query User Value |
|---|
| ...SOME FIELDS | | |
 TEXT FIELD | attr1 | User-typed value: AA |
 TEXT FIELD | attr2 | User-typed value: BB |
 COMBO FIELD | attr3 | DQL Query: SELECT label, value FROM my_val_**** WHERE cond1 = '$value(attr1)' AND cond2 = '$value(attr2)' |
| SOME OTHER FIELDS... | | |
I expect that the query of the values for field attr3 is as follows:
SELECT label, value FROM my_val_**** WHERE cond1 = 'AA' AND cond2 = 'BB'
I set the debug level of the log D2
By checking the logs I see that is processed the following query:
SELECT label, value FROM my_val_**** WHERE cond1 = 'AA' AND cond2 = ''
At this point I wonder:
I can use multiple occurrences of $ value () in this type of DQL query?
You know how? where I'm wrong?
Thanks for the support,
Luca
