Re: [OFBiz] Dev - How to filter a field in a <view-entity>

Posted by on
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Dev-How-to-filter-a-field-in-a-view-entity-tp165825p165835.html

Chen,

Thanks, I'll try it.

But it would be much more handy if you can specify constraint directly
in the definition of <view-entity>, just like the widely used WHERE
clause in the creation of a view by SQL, isn't it?

On 8/9/05, Si Chen <[hidden email]> wrote:

> Li Yan,
>
> You define your view-entity in the entitymodel.xml but you filter it
> using the delegator.find_ methods in your java code, such as:
>
> delegator.findByAnd("Employee", UtilMisc.toMap("isDeleted", "N"));
>
> Si Chen
>
> Yan Li wrote:
>
> >Hello,
> >
> >I'm trying to create a view that contains only one member entity, and
> >apply a filter onto one field. It is very simple, and the SQL should
> >be like this:
> >
> >SELECT * FROM Employee WHERE isDeleted = 'N'
> >
> >But I don't know how to apply this into a <view-entity> defined in
> >entitymodel.xml. I have searched through all the elements and
> >attributes of <view-entity> but found nothing helpful.
> >
> >Thanks in advance.
> >
> >
> >
>
> _______________________________________________
> Dev mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/dev
>

--
Best regards,
Yan
 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev