Tag Info

New answers tagged

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> ...


2

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


1

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 ...


1

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>"


1

Unfortunately, it cannot be done in CAML. If you have to use CAML, the recommended approach is created a calculated column such as =DATEDIF([NoticeSentDate], [NoticeDate],"d"). Your CAML query would then look for values greater than 0 in the calculated column. Check out this page for more examples of date calculations in calculated columns: ...


4

When using you want to use the Offset=""(or according to the comments on MSDN attribute should be OffsetDays="") on the Element <View> <Query> <Where> <Eq> <FieldRef Name="EventDate" /> <Value Type="DateTime"><Today OffsetDays="+1"/></Value> ...


1

This question is similar to a question asked earlier here. You can use Offset Please check this link.


2

First of all, Is it server or client object model? In case of SSOM you don't need Query node inside your CAML. And you forgot to wrap your Geq and Leq nodes with the And. So instead of this: <Query> <Where> <Geq> <FieldRef Name='Created'/> <Value Type='DateTime'>2014-01-01:00:00:00</Value> ...


1

I think this article should help you: http://msdn.microsoft.com/en-us/library/office/ff625182(v=office.14).aspx It says: By passing true to the bool includeDescendants parameter to TaxonomyField.GetWssIdsOfKeywordTerm, you get the lookup IDs for the term with the specified GUID, and you get the IDs for all its child terms. Once you get ID you can query ...


2

Since CSOM supports Request Batching that allows to minimize the number of messages that are passed between the client and the server, it matters how operations are submitted to the server using ClientContext.ExecuteQuery method: ClientContext.ExecuteQuery method performs the actual request to the server, it could contain single or multiple operations. So, ...



Top 50 recent answers are included