Filtering is not working for dataTable Lazy Loading

[Sunil]

Hi All,

Can any one help me in performing filterBy in dataTable Lazy Loading.

Problem:None is displayed while entering a word in filterBy in column of dataTable.
Please help at earliest

bean file:

Code: Select all

 public LazyDataModel<Breeder> getBreederLazy() {
        return breederLazy;
    }

    @PostConstruct
    public void createDataModel() {
        LazyDataModel m = new LazyDataModel<Breeder>() {
            public List<Breeder> load(int start, int size, String order, boolean desc, Map<String, String> filter) {
                List<Breeder> result = ejbFacade.load(start, size, order, desc, filter);
                return result;
            }
        };
        breederLazy = m;
        breederLazy.setRowCount(ejbFacade.findAll().size());

    }

XHTML file :

Code: Select all

<p:dataTable id="table1"
                                 value="#{breederController.breederLazy}"
                                 var="item"
                                 lazy="true"
                                 widgetVar="table1"
                                 selectionMode="single"
                                 selection="#{breederController.breederID}"
                                 update="display"
                                 onselectComplete="edited.show()"
                                 paginator="true" rows="5" 
                                 paginatorTemplate="{RowsPerPageDropdown} {FirstPageLink} {PreviousPageLink} {CurrentPageReport} {NextPageLink} {LastPageLink}"  
                                 rowsPerPageTemplate="5,10,15" 
                                 paginatorPosition="both"
                                 styleClass="Table"
                                 dynamic="true">

<p:column sortBy="#{item.breederName}"  filterBy="#{item.breederName}" filterStyleClass="searchOption" >
                            <f:facet name="header">
                                <h:outputText value="#{bundle.BreederTitle_breederName}"/>
                               
                            </f:facet>
                            <h:outputText value="#{item.breederName}" style="color:rgb(#{item.idCooperative.color})"/>
                        </p:column>
                                 

http://imageshack.us/photo/my-images/694/filterd.png/


Thanks in Advance,
Sunil

[cagatay.civici]

Do you include filters when you query the db. You need to do the filtering yourself in lazy mode.

[Sunil]

yes! But how to do filtering in lazy mode

[cagatay.civici]

Query db with sql, jpa whatever you use for persistance.

[Sunil]

Can u show me the example?

[robert.m]

Have a look at this example: http://javaeeinsights.wordpress.com/201 ... teria-api/

The "lazyLoad"-method in the example will be the "ejbFacade.load"-method in your code.

[Sunil]

Even though i did like the above example, i couldn't get exact solution.
Am using EclipseLink(JPA 2.0) for my project.
Can you help me in getting the exact solution for this.
Awaiting your reply

[robert.m]

Please post the code of your ejbFacade.load method

[sebasrock]

but , the problem is that value of FilterBy is equal to name variable, but dont have the value of variable

[smithh032772]

Look for my response to the post/question at the URL below. This is my workaround for p:dataTable filterBy issue(s).

viewtopic.php?f=3&t=6824