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
[EMAIL PROTECTED] 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
