Variable in CAML sor SPJS charts

[Luc Perepelkine]

I Alexander,

I try to put a variable on CAML filters but i don’t succeed can you help me ?

The goal : force value in filter but i don’t want that filter appears on charts.

When i charged the variable in “filter above the chart” it work fine (but I don’t find how make disappears filter).
So i try with a CAML but i’m stranded.

The variable is charged with Load external JS or CSS

Several CAML I tried (i’m not a IT guy so i search solution on this forum and internet and tried codes but nothing works) (AnActuel is the variable) (I tried to play with “” and ” but with no luck):
1/ <Where><Eq><FieldRef Name=’Ann_x00e9_e_x002e_’></FieldRef><Value Type=’Text’>{var:AnActuel}</Value></Eq></Where>
2/ <Where><Eq><FieldRef Name=’Ann_x00e9_e_x002e_’></FieldRef><Value Type=’Text’>”+AnActuel+”</Value></Eq></Where>

The CAML work fine with value which is not a variable.

Thanks for your help.

Luc

[Alexander Bautz]

Sorry, but using variables here is not currently supported. What you can do is to use the URL filter option.

Make a link to this page with your filter in the URL like this:

.../Sites/YourSite/ChartPage.aspx?ExampleUrlFilter=test123

Now pick up the filter in your CAML like this:

<Where><Eq><FieldRef Name="Your_Filter_Field" ></FieldRef><Value Type="Text">{url:ExampleUrlFilter}</Value></Eq></Where>

Alexander

[Luc Perepelkine]

Ok thank you,

I will try that.

Luc

[Luc Perepelkine]

Ok thank you,

Luc

[Author]

Posts