Re: entity condition expression problem

e="${this.estimatedNetAmount}"/> >>> >>> >>> How can I achieve the equivalent of "this" is a entity condition >>> expression? >>> >>> I do not want to filter by iterating the list as the data volumes are >>> huge. >>> >>> One option I am thinking of is to create a SQL view and use that to >>> filter the data: >>> >>> SELECT >>> e1Id, actualNetAmount, estimatedNetAmount, >>> CASE >>> WHEN actualNetAmount > estimatedNetAmount THEN 1 >>> ELSE 0 >>> END CASE AS actualGTEstimated >>> FROM E1 >>> >>> Maybe I could use DynamicViewEntities, but I was trying to use less >>> beanshell/java and more minilang. >>> >>> Many thanks in advance, Chris >>> >>> >> >> > > -- View this message in context: http://www.nabble.com/entity-condition-expression-problem-tp25010865p25038183.html Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: entity condition expression problem

nt to filter by iterating the list as the data volumes are >> huge. >> >> One option I am thinking of is to create a SQL view and use that to >> filter the data: >> >> SELECT >> e1Id, actualNetAmount, estimatedNetAmount, >> CASE >> WHEN actualNet

Re: entity condition expression problem

Estimated > FROM E1 > > Maybe I could use DynamicViewEntities, but I was trying to use less > beanshell/java and more minilang. > > Many thanks in advance, Chris > > -- View this message in context: http://www.nabble.com/entity-condition-expression-problem-tp25010865p25018276.html Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: entity condition expression problem

Never Mind. shot from the hip. BJ Freeman sent the following on 8/17/2009 10:35 AM: > step one is created a viewentity for the equivalent Select > then use the entity condition for the viewenitity > > snowc sent the following on 8/17/2009 10:26 AM: >> I have some legacy data that I am trying to a

Re: entity condition expression problem

step one is created a viewentity for the equivalent Select then use the entity condition for the viewenitity snowc sent the following on 8/17/2009 10:26 AM: > I have some legacy data that I am trying to access in ofbiz. > > > > > > > > Conceptually, I want to filter as shown here: >

entity condition expression problem

1 ELSE 0 END CASE AS actualGTEstimated FROM E1 Maybe I could use DynamicViewEntities, but I was trying to use less beanshell/java and more minilang. Many thanks in advance, Chris -- View this message in context: http://www.nabble.com/entity-condition-expression-problem-tp25010865p25010865.ht