DataTable does not refresh as per the results retrieved.

[ashwaja]

Hi,

On the search page, I do a default(blank) search to retrieve the search results, this result will have three columns A, B and C. The data retrieved from the database is by the order of A. Thus the results are displayed by the order A.

I do a sort on B or C column of the search results, Now, I do a default(blank) search again. Though the new search result is coming from the DB, it is not based on the sorted order A. it retains the sorted order of B or C, which was sorted earlier.

I have made sure to have the search result page refreshed for every new search. I'm really sure why it is displaying the results based on the last sorted order.

I need to display the search results for every new search based on the order of column A, the same fashion of how it is retrieved from the DB.

Please help, this fix is very urgent for me.

Thanks,

Harish.

[ashwaja]

I do not see any solution for this... Please help me with some ideas.

Thanks,

Harish.

[ilya40umov]

I guess that your problem may be in a scope of the bean where you are storing the sorting type. You should reset this value in the bean after every search. Please post some code, because it's difficult to say something when you have nothing to look at and only common words about the problem.

[ilya40umov]

1) What is the type of searchResultsList?

2) What is the scope of searchMBean?

3) You can try to bind you rich:dataTable to org.richfaces.component.UIDataTable field in your bean and then use API to reset sorting state:

http://docs.jboss.org/richfaces/latest_3_3_X/en/apidoc/org/richfaces/component/UIDataTable.html

[ashwaja]

Hi Ilya,

I have resolved this issue by setting the collection object to null before retrieving data for a fresh search.

Thanks,

Harish.