Hi everyone,

I was wondering, if there is a way to get a property value into another SQL expression property value. This is what I want: In one document type ("site settings") I pick the edition of a congress, formatted as a numeric. In another document type ("highlight") I have an SQL expression as property value. It looks like:

select distinct (...data...) from (...table...) WHERE ID_EDITION=(...congress edition picked above...)

The document type "site settings" is not a parent, ancestor or child of "highlight". The structure is more like:

Page
- Homepage
-- "highlight"
- "site settings"

Is the a way to get this?

Thank you!

Best, Simeon