Tag Info

New answers tagged

0

So upon your feedback try this one on. The divs will float and it will add a new div based on the category. You need to order items first by category. Then Display order. $(document).ready(function() { $().SPServices({ operation: "GetListItems", async: true, listName: "navigator", CAMLViewFields: "<ViewFields><FieldRef Name='Title' ...


1

Regarding grouping in SharePoint REST, according to Use OData query operations in SharePoint REST requests, Grouping is not supported. One of the solution, is to apply grouping for the JSON results returned from REST endpoint. Example Suppose the following function for getting list items via SharePoint REST API: function getListItems(url, listname, ...


0

Try switching to using single quotes on the attributes Source: Here var CamlQuery = "<Query><GroupBy Collapse='TRUE'><FieldRef Name='nameA' /></GroupBy></Query>"; var CamlViewFields="<ViewFields><FieldRef Name='nameA' /></ViewFields>";


1

You do not need a CAML query : Remove-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue try { # REQUIRED: URL to source SharePoint site with list $srcListSiteUrl = "http://testsrv/sites/home/pre-sales" # REQUIRED: Name of source list. ...


2

It seems that you are missing <And> and also I think the date should be <Geq>. Example of date CAML Query: <Where> <Geq> <FieldRef Name="Created" /> <Value Type="DateTime"> <Today OffsetDays="-180" /> </Value> </Geq> The above code would get all items which were created in the ...


0

Change your query like : CamlQuery query = new SP.CamlQuery(); query.ViewXml = "@<View><Query><Where><Eq><FieldRef Name='Title' /><ValueType='Text'>{Title Text Here}</Value></Eq></Where></Query></View>"; var itemts= list.GetItems(query);


4

You are missing the <View> tags in your ViewXml (see example here) It should be string qs = String.Format("<View><Query><Where><Eq><FieldRef Name=\"Title\"></FieldRef><Value Type=\"Text\">{0}</Value></Eq></Where></Query></View>", listItemTitle); query.ViewXml = qs; In case of ...


0

according to this thread you cannot filter based on projectproperty I must add that I haven't tried it myself, though.


1

This gets all folders and files under a specified folder: <View Scope='RecursiveAll'> <Query> <Where> <Eq> <FieldRef Name='FileDirRef' /> <Value Type='Text'>MyFolderPath</Value> </Eq> </Where> </Query> </View>


0

You can use BeginsWith in the CAML query. "<Where><BeginsWith><FieldRef Name='Title'/><Value Type='Text'>TestTitle</Value></BeginsWith></Where>"; Refer this link for more information.


0

Your CAML query should look something like this ... <Query> <Where> <And> <Gt> <FieldRef Name="EventDate"/> <Value Type="DateTime"> <Today OffsetDays="-NumDays"/> </Value> </Gt> <Lt> ...


3

Don't add View Tag, reform the query as follows: CAMLQuery = "<Query><OrderBy><FieldRef Name='Fiscal_x0020_Year' Ascending='TRUE' /></OrderBy></Query>"


2

Perhaps its the default RowLimit that is causing you to not retrieve all results? A RowLimit of 0 will return all results. For example: "<View><Query><OrderBy><FieldRef Name=\"Fiscal_x0020_Year\" Ascending=\"TRUE\"></FieldRef></OrderBy></Query><RowLimit>0</RowLimit></View>" Also, the following ...


2

Try adding a null check: CAMLQuery = "<Query><Where><IsNotNull><FieldRef Name='Fiscal_x0020_Year' /></IsNotNull></Where><OrderBy><FieldRef Name='Fiscal_x0020_Year' Ascending='True' /></OrderBy></Query>"



Top 50 recent answers are included