Hot answers tagged

4

If you want to compare with both conditions than use AND: @"<Where> <And> <Eq> <FieldRef Name='ReportsTo' /> <Value Type='Text'>" + reportsTo + @"</Value> </Eq> <Eq> <FieldRef Name='Team' /> <Value Type='Text'>"+ selected+ @"</Value> </Eq> </And> </...


1

@"<Where> <And> <Eq><FieldRef Name='ReportsTo' /><Value Type='Text'>" + reportsTo + @"</Value></Eq> <Eq><FieldRef Name='Team' /><Value Type='Text'>"+ selected+ @"</Value></Eq> </And> </Where>"


1

You can use like this: @"<Where> <And> <Eq> <FieldRef Name='ReportsTo' /> <Value Type='Text'>" + reportsTo + @"</Value> </Eq> <Eq> <FieldRef Name='Team' /> <Value Type='Text'>"+ selected+ @"</Value> </Eq> </And> </Where>" NOTE: You can also use <...


1

Wrap your conditions in <And>...</And> inside <Where> Reference: https://msdn.microsoft.com/en-us/library/office/ms196939.aspx @"<Where> <And> <Eq> <FieldRef Name='ReportsTo' /> <Value Type='Text'>" + reportsTo + @"</Value> </Eq> <Eq> &...


1

You need to create a calculated column to show KPIs on same list. Note:- I have used below formula to check for 3 conditions like Green, Red & Yellow. I used column named budget with dropdown to select one of the value given above. I have uploaded all the images in SiteCollectionImages library. Please check below formula =IF(Budget="Green","<...



Only top voted, non community-wiki answers of a minimum length are eligible