Advanced Filter client-side only: how to change the Date format?

Technical Q&A
1

Hi

I am evaluating SmatClient, and I am starting off with only the client-side part.

I have a Datasource (with a field of type Date), a ListGrid (which populates the fields returned by the Datasource) and an AdvancedFilter.

The Datasource is formatting the Dates using ‘formatCellVakue’ (the dates from the Datasource are being returned as ‘YYYY-MM-DD’).

My problem is that the Advancedfilter is showing the dates with US format, and I would like to be able to change this to ‘DD/MM/YYYY’.

How can I do this please?

isc.RestDataSource.create({
                ID:"DS_responses",
                dataFormat:"json",
                operationBindings:[
                    {operationType:"fetch", dataProtocol: "postParams"}
                ],
                fields:[
                    {name:"docId", title:"Response Id", formatCellValue: "'<a href=\"http://localhost:8888/techrep/?c=main_controller&m=showdoc_info&docid='+value+'\">'+value+'</a>'"}
                
,{name:"72bfc36a3e48cb54977fd57090a833af", title:"Date", type: "date", formatCellValue: function (value) {
                                    if (value) {
                                            return value.toEuropeanShortDate();
                                        }
                                    }},
                fetchDataURL:"http://www.domain.com",
                transformRequest : function (dsRequest) {
                     if (dsRequest.operationType == "fetch") {
                         //document.getElementById('dump').value = dump(dsRequest);
                         var params = {                            
                            operationType: dsRequest.operationType,
                            startRow : dsRequest.startRow,
                            endRow : dsRequest.endRow,
                            sortBy: dsRequest.sortBy,
                            criteria: dsRequest.data
                         };
                         // combine paging parameters with criteria
                         return isc.addProperties({}, dsRequest.data, params);
                     }
                  },
                dataPageSize: 5
            });

isc.FilterBuilder.create({
                ID:"advancedFilter",
                topOperatorAppearance: "radio",
                radioOptions: ["and", "or"],
                dataSource:"DS_responses",
                filterEditorType:"DateSelectItem"
            });
 
            isc.IButton.create({
                ID:"filterButton",
                title:"Filter",
                click : function () {
                    responses_list.filterData(advancedFilter.getCriteria());
                    //document.getElementById('dump').value = dump(advancedFilter.getCriteria());
                }
            });

isc.ListGrid.create({
                ID: "responses_list",
                //position: "relative",
                width:550, height:124, alternateRecordStyles:true,
                dataSource: "DS_responses",
                dataPageSize: 5,
                drawAheadRatio: 1,
                showAllRecords:false,
                autoFetchData: true
            });

I’m using the latest client-side code (v8 nightly build).

Thanks in advance!
M