Is there a way to add a condition-expr to entity-condition element of form widget that will compare two of the entities fields?

[Christian Carlow-OFBizzer]

Does anyone know if it is possible to add conditions that compare two
fields of an entity being searched for from a form widget using the
entity-condition element?

In other words, is it possible to add a condition filter to OrderItems
where the quantity and cancelQuantity are not equal from a form widget?

If not I think it should be improved to allow it.

[Rishi Solanki]

IMO, when we use sql statements then for such conditions we use joins.
Similarly, you can use static views to do so, in general which is as
similar as sql joins. Please refer existing view entities to use for your
conditions.

I'm not sure about the form widget should support it, as in java, groovy
and ftls we use the static or dynamic views or iterator for such conditions.

HTH!


Rishi Solanki
Manager, Enterprise Software Development
HotWax Media Pvt. Ltd.
Direct: [phone]
http://www.hotwaxmedia.com


On Mon, Oct 28, 2013 at 11:22 PM, Christian Carlow <
[hidden email]> wrote:

> Does anyone know if it is possible to add conditions that compare two
> fields of an entity being searched for from a form widget using the
> entity-condition element?
>
> In other words, is it possible to add a condition filter to OrderItems
> where the quantity and cancelQuantity are not equal from a form widget?
>
> If not I think it should be improved to allow it.
>