SPJS Chart Date Filter

[Jhap]

Good day Sir Alexander,

I use the below code to filter the charts and my calculated column DATEFILTER in sharepoint list is =TEXT(DATE, “DD/MMM/YYYY”) and is working fine, but in the charts the filter shows string;#21/Sep/2014 and because of that it return No items match this filter…

function spjs_getFilterValue(list,field){
var q = “”;
var res = spjs.charts.qItems({“listName”:list,”query”:q,”viewFields”:[field]});
var b = [];
var fObj = {};
$.each(res.items,function(i,item){
if(fObj[item[field]] === undefined){
fObj[item[field]] = 1;
b.push({“f”:””+item[field]+””,”v”:””+item[field]});
}
});
return b;
}
var myCustomFilterOptions = spjs_getFilterValue(“{3DE38E73-F09F-40E7-A580-835513FBB638}”,”DateFilter”);

Thank you very much.

Attachments:

1. 

   Date_Filter_Chart_Issue.jpg
   

2. 

   Date_Filter_Setup.jpg
   

3. 

   Date_Filter_CEWP.jpg
   

[Alexander Bautz]

Hi,
When using a calculated column the value returned from the query is delimited with ;# and we have to strip this out.

Change the function like this (new code in bold font):

fObj[item[field]] = 1;
if(item[field].split(“;#”).length > 1){
item[field] = item[field].split(“;#”)[1];
}
b.push({“f”:””+item[field]+””,”v”:””+item[field]});

Alexander

[Jhap]

Hi Sir Alexander,

Sorry for the late response due to eid holiday here. I had applied the solution you provided and its working very fine.

Thank you so much for the kind help.

Danny

[Author]

Posts