Create View with dynamic Filter using Contains and OR : CAML syntax errors

Question

I'm trying to dynamically add filters to an existing view, with an OR between two columns and using CONTAINS constraints, using purely client side javascript

The solutions to me seem to be either:

Create another column that is populated in a presaveaction javascript to concationate the two items together, which can then be filtered using the URL filter

Works, but this is a fall back solution

Imbed the query into the client side JSLINK javascript to dynamically add a filter to an existing view
Use a render to take out rows from the view that do not match the filters.

The only problem is that it will just remove those rows that are within the current page.

Have javascript create a personalised view.

This method uses the following type of code:

(taken from http://blog.techperspect.com/2015/07/create-list-view-using-sharepoint-rest.html)

    function createView(ListName, query ) {
         var bodyContent = "{ '__metadata': { 'type': 'SP.View' }, 'Title': 'View Name', 'PersonalView':   true, 'ViewQuery':'" + query + "'  }";
         var viewUrl = _spPageContextInfo.webAbsoluteUrl + "/_api/lists/getbytitle('"+ListName+"')/views"
         var executor;  executor = new SP.RequestExecutor(_spPageContextInfo.webAbsoluteUrl);  
         executor.executeAsync({ url: viewUrl,
                         method: "POST",
                         body: bodyContent,
                         headers: { 
                               "accept": "application/json;odata=verbose",
                               "content-type": "application/json;odata=verbose"
                                  },
                         success: function (results) { alert("View Created.") },
                         error: errorHandler
                     });

                                   };

       var myquery = "<Where><Eq><FieldRef Name='Title'/><Value Type='Text'>Testvalue</Value></Eq</Where>";

       var scriptbase = _spPageContextInfo.webAbsoluteUrl+ "/_layouts/15/";

    function RunView() {
          createView('mylist',myquery);
    };

    $.getScript(scriptbase + "SP.Runtime.js",
           function () {
               $.getScript(scriptbase + "SP.js",
                   function () { $.getScript(scriptbase + "SP.RequestExecutor.js", Runview) }
                       )
                    }
             ) 
    }

    function errorHandler(data, errorCode, errorMessage) {
          alert(data);
          alert(errorCode);
          alert(errorMessage);
       }

Questions:

Does anyone have examples for option 2 if that is a possibility? How can this be done?
When I run the code for option 4, the code fails. the message is

"Invalid JSON. A comma character ',' was expected in scope 'Object'. Every two elements in an array and properties of an object must be separated by commas.

What is wrong with my parameters?

The parameter that is passed across is:

bodyContent "{ '__metadata': { 'type': 'SP.View' }, 'Title': 'View Name', 'PersonalView':   true, 'ViewQuery':'<Where><Eq><FieldRef Name='Title'/><Value Type='Text'>Testvalue</Value></Eq></Where>'  }"

I assume the commas are missing from the ViewQuery parameter. Any ideas where?

Danny '365CSI' Engelman · Accepted Answer · 2016-12-07 08:30:57Z

0

on a ListView WebPart you an not do 2. (apply a filter to a View with JavAscript)

Because it is the Server that executes the View and sends the content in the ctx object to the browser.

So you can only 'filter' out what rows you do not want in the CSR OnPreRender function

answered Dec 7, 2016 at 8:30

Danny '365CSI' Engelman

21.2k7 gold badges37 silver badges80 bronze badges

Add a comment |

P S · Accepted Answer · 2016-12-07 08:45:42Z

0

I changed the value of bodyContent to be

var bodyContent = JSON.stringify(
        {
            "__metadata": { "type": 'SP.View' },
            "Title": "MyView",
        "PersonalView":   true,
            "ViewQuery": "<Where><Eq><FieldRef Name='Title'/><Value Type='Text'>Metest</Value></Eq></Where>" 
        }
    );

And the view creation works.

BUT I'd still like to know whether anyone have examples for option 2 and if it is possible? How can this be done?

edited Dec 7, 2016 at 8:45

P S

4,8274 gold badges29 silver badges51 bronze badges

answered Dec 7, 2016 at 5:56

southskies

66313 silver badges30 bronze badges

Add a comment |

Stack Exchange Network

Create View with dynamic Filter using Contains and OR : CAML syntax errors

2 Answers 2

Your Answer

Hot Network Questions

Create View with dynamic Filter using Contains and OR : CAML syntax errors

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions