Tag Info

New answers tagged

0

After trying to make projected fields work in views (either defined programmatically or declaratively), I sadly conclude that one cannot use fields from other lists in views by help of Joins and Projected Fields.


0

If the field in question is a lookup field adding "LookupId='True'" will convince the CAML query to work: <Where> <IsNull> <FieldRef Name='TestField' LookupId='True' /> </IsNull> </Where> This also works when dealing with front end designed views - but those need to be adapted in SharePoint Designer. There is no ...


6

Query in your case is a string, which means that you are using the SPList.GetItems(String[]) overload. That method accept a list of fields to load, not a query. You should be using one of the overloads that accepts an actual SPQuery object.


0

If the list items are getting created by custom forms then create a column that can have a concatenated value of first two level of filters(in your case Technology and app_status). Index the column, now you should be able to use that column in your CAML Query.


0

This is one big disadvantage, well there is no way to increase that threshold in SharePoint Online, all you can do is create different views and query them or split the list into multiple. ClientContext context = new ClientContext("http://sp2013sps/sites/test"); List list = context.Web.Lists.GetByTitle("List66688"); context.Load(list); ...


0

You may have to switch to LinQ, or some client side script to pull out substrings. I am not aware of a way to do what you are asking.


1

You should try the IN operator in caml query <Where> <In> <FieldRef Name="RelatedItemID" /> <Values> <Value Type="Number">1</Value> <Value Type="Number">2</Value> ... </Values> </In> </Where>


0

I wasn't able to find out the problem, but with the following workaround I got it: <Where> <And> <Eq> <FieldRef Name='Author' LookupId='TRUE' /> <Value Type='User'>473</Value> </Eq> <And> <Leq> <FieldRef Name='Datum' /> <Value ...


0

Please check the time zone of your server. It is possible that your web time zone and browser time zone differs. You should try these options: Set property SP.CamlQuery.datesInUtc to false Set property SP.CamlQuery.datesInUtc to true and pass correct value in UTC. For example, if your web time zone is +2 UTC, browser shows date value 2015-06-05 00:00:00, ...


0

You should create date in ISO format (Ex: -2015-06-04T02:32:20Z as below $expireyDate = [microsoft.sharepoint.utilities.sputility]::CreateISO8601DateTimeFromSystemDateTime($expireyDate); $spQuery = New-Object Microsoft.SharePoint.SPQuery; $camlQuery = "<Where><Lt><FieldRef Name='DocumentDate'/><Value Type='DateTime' ...


-1

You may first connect to list programmatically and get all feilds as collection then look for non hidden fields and you get non hidden fields collection. Then write your own caml query with collection.


0

You need to explicitly request for each fields you want.



Top 50 recent answers are included