Forums

I am using YUI2 datatable.
All the column configs and data gets loaded dynamically from the server side in JSON format and datatable gets prepared from parsed JSON string.

After loading the datatable I have an Advanced Search option which can have more number of fields provided then present in datatable at the time.

So after filling up all the data in Advanced Search form control go backs to the server again and filters the data according to search crieteria and prepares the datatable again.
But here because of performance issue I am not preparing or instantiating the datatable again but I am just reseting the record set and replaces the data with new record set data from the returned JSON string.

I am using below code to replace the data

var resultData = JSONResponse.resultSet.results;
myDataTable.getRecordSet().reset();
myDataTable.getRecordSet().setRecords(resultData);
myDataTable.refreshView();

I have some columns which have dates, numbers and columns.

The problem is When I refresh the data after advanced search
data table is not retaining the formatters for date,number and currency.
I am using inbuilt formatters of datatable.
Because of this it creates the sorting problem on the datatable.
If I dont update or refresh the data, all the things are working fine.

Am I missing something here when I refreshj the data ?

Thank you very much for the reply..

I already looked at your requery example before posting this question

Actaully my problem is, I am preparing all the advance search field dynamically based on the user preferences saved in configuarations. So all the HTML will be the dynamic one. So I have created a framework which will generate the HTML code from JAVA based on the field type (textbox,multiselect,select etc.) and also all the lables and names will come from configuartion.
All this will be open up in the YUI dialog box.
Now when user fill up the data in above dialog box and submit it, page gets submitted to server and some data validation will hapen there and if some error is there it will straight away those errors on dialog box.

If there are no errors then it will proceed further and get all the data from the dialog box which user has enterd.
Here I am using the JSP useBean utility which will set all the data automatically in POJO class and I can then refer it to fetch data from database.

After getting the user entered data I am calling one servlet which will then prepare the JSON result data and control comes back in success handler of the dialog box. There I am parsing the JSON result set and setting it in recordset.

So here I am little bit confused about how can I use requery because actual query is firing from the other page.

One note I forgot that the problem is not with formatter but it is with the parsers which I am using

So I was thinking that is there anyway that I can again parse the data with the original datasource from the
success handler of advance search dialog box ?

For this I have to iterate whole result set from decoded JSON resultset and then apply the corresponding parser to each column data and append it to the datatable data again..Please Correct me if I am wrong.

I was lloking for a method like if I can give the resulted data and it can return me the parsed data according to type of each column.

I am providing some sample data which I am going to have as JSON string

{"resultSet":{"columnList":[{"key":"test1","label":"Test Data","formatter":"TestHyperLink"},{"key":"test date","label":"This is a date",formatter":"date","parser":"date"},{"key":"testNumber","label":"This is a test number","formatter":"number","parser":"number"}],
"results":[{"test1":"testString","testdate":"Tue Aug 31 00:00:00 EDT 2010","testNumber":"12345.32"},{"test1":"testString2","testdate":"Mon Aug 30 00:00:00 EDT 2010","testNumber":"362569.32"}]}

Here I have the different parser defined for each attribute.
So I have this config data in my returned JSON string.

Could you please suggest how can I make the most effective use of this data for parsing again ?

Note : I have the data table refernce with me which I can use at the point of parsing above data.

Okay..
thank u very much for ur suggestions..
just a one thing about which I was curious..
when I m doing parsing of any date field initially,it gives correct date format like mm/dd/yyyy..
but when I am doing manual parsing with datasource.parseDate method it does return me a timestamp format..
is there any other thing i have to do to get the desired date format ?

now when I am going to iterate whole resultset,
my problem is i dont have static keys and data every time..it depends on some user selections at run time..
but I do have a column list object where all the column information is..
here first i have to iterate resultset array for data but to iterate it I need keys name rite..
so my approach will be to iterate resultset object parallely to columnlist from where i can get key name like var keyName = columnList[i].key and pass it to resultset[keyName] to get the value and then parse it and store it in one array to later provide it to datatable resultset.

Please let me know if u think that i need some optimization on this or u have any better approach on this..
may be I would have a very large amount of data..

Really appreciate ur help..