Now that you mention it, yeah, that doesn't seem possible.
Even with <view-entity>, you cannot have "conditional joiners". Joins in <view-entity> are
restricted to "key-to-key/field" (equality) joins only.
What's <condition-object>, by the way? Anybody knows? I don't see it used?
It shouldn't be difficult to extend <condition-expr> so that it supports what you suggested.
Jonathon
[hidden email] wrote:
> Hi
>
> I have a problem to create an entity-condition that compares to
> fields on the database.
>
> SampleEntity:
> Field 1: fromDate
> Field 2: minimumFromDate
>
> what I want is to fetch only the fields from the database where
> fromDate <
> minimumFromDate. Unfortunately, it seems that it is only possible
> to
> compare against values in entity-condition. What I need is
> something
> like
>
> <entity-condition entity-name="SampleEntity" list-
> name="samples">
> <condition-list>
> <condition-expr field-name="fromDate"
> operator="less" to-field="minimumFromDate"/>
> </condition-list>
> </entity-condition>
>
> Am I missing the obvious or is it not possible to create such
> queries easily in Screens, Minilang etc.
>
> Thank you very much and best regards
>
> Markus Studer
>
>
Locked
