Click here to Skip to main content
14,326,246 members

SharePoint

 
AnswerRe: Transaction control in SharePoint 2010 Pin
Ingo29-Aug-13 0:02
memberIngo29-Aug-13 0:02 
QuestionFarm-Backup error with Powershell for SharePoint 2013 Pin
Ingo27-Aug-13 6:10
memberIngo27-Aug-13 6:10 
QuestionHow to post Sharepoint site on my domain in public hosting like hosting raja Pin
Karthick_RR19-Aug-13 2:32
professionalKarthick_RR19-Aug-13 2:32 
AnswerRe: How to post Sharepoint site on my domain in public hosting like hosting raja Pin
Ingo19-Aug-13 2:52
memberIngo19-Aug-13 2:52 
QuestionUnable to delete page from a website Pin
dadda_12313-Aug-13 1:09
memberdadda_12313-Aug-13 1:09 
AnswerRe: Unable to delete page from a website Pin
Ingo19-Aug-13 2:58
memberIngo19-Aug-13 2:58 
AnswerRe: Unable to delete page from a website Pin
nishant231028-Aug-13 23:24
membernishant231028-Aug-13 23:24 
QuestionCAML query for nested and / or Pin
DownUnderMark7-Aug-13 23:03
professionalDownUnderMark7-Aug-13 23:03 
Hi All,

First time poster here so I hope I haven't messed my post up...

I am currently using Sharepoint at work with a third party web part that utilises CAML for queries. things so far have been going well until I ran into my latest problem which I cannot solve and hope that someone out there could lend some assistance.

Requirement is:

"Action 1 due date" to be less than "Today" AND the Status not equal to "Completed"

OR "Action 2 due date" to be less than "Today" AND the Status not equal to "Completed"

This pattern will carry on for all four actions. I can get it to partially work but it seems to disregard the Or clause.

Thank you all in adavance.

<Query>
    <Where><And><Or><And><Or><And><Or><And><Lt><FieldRef Name="Action One Due Date" />
        <Value Type="DateTime">
            <Today/></Value></Lt>
                <Neq><FieldRef Name="Action One Status" />
                <Value Type="Text">Completed</Value></Neq>
    </And><Lt><FieldRef Name="Action Two Due Date" />
    <Value Type="DateTime">
        <Today/></Value></Lt></Or><Neq><FieldRef Name="Action Two Status" />
            <Value Type="Text">Completed</Value></Neq></And><Lt><FieldRef Name="Action Three Due Date" />
                <Value Type="DateTime">
                    <Today/></Value></Lt></Or><Neq><FieldRef Name="Action Three Status" />
    <Value Type="Text">Completed</Value></Neq></And><Lt><FieldRef Name="Action Four Due Date" />
        <Value Type="DateTime">
            <Today/></Value></Lt></Or><Neq><FieldRef Name="Action Four Status" />
                <Value Type="Text">Completed</Value></Neq></And></Where></Query>

AnswerRe: CAML query for nested and / or Pin
Manohar P8-Aug-13 18:29
memberManohar P8-Aug-13 18:29 
GeneralRe: CAML query for nested and / or Pin
DownUnderMark8-Aug-13 20:42
professionalDownUnderMark8-Aug-13 20:42 
AnswerRe: CAML query for nested and / or Pin
Manohar P8-Aug-13 23:54
memberManohar P8-Aug-13 23:54 
GeneralRe: CAML query for nested and / or Pin
DownUnderMark12-Aug-13 0:53
professionalDownUnderMark12-Aug-13 0:53 
QuestionTypedescriptor ambiguity for reflection Pin
nainakarri7-Aug-13 3:16
membernainakarri7-Aug-13 3:16 
AnswerRe: Typedescriptor ambiguity for reflection Pin
nainakarri14-Aug-13 0:10
membernainakarri14-Aug-13 0:10 
QuestionDisplay Resources in a Sharepoint Calendar Pin
Manohar P6-Aug-13 18:21
memberManohar P6-Aug-13 18:21 
QuestionFind no of visitors in website using sharepoint 2010 Pin
Game-point25-Jul-13 8:07
memberGame-point25-Jul-13 8:07 
AnswerRe: Find no of visitors in website using sharepoint 2010 Pin
Ingo27-Jul-13 11:53
memberIngo27-Jul-13 11:53 
QuestionSharepoint DashBoard Pin
Veera MK24-Jul-13 0:21
memberVeera MK24-Jul-13 0:21 
AnswerRe: Sharepoint DashBoard Pin
Ingo24-Jul-13 23:00
memberIngo24-Jul-13 23:00 
GeneralRe: Sharepoint DashBoard Pin
Veera MK24-Jul-13 23:41
memberVeera MK24-Jul-13 23:41 
AnswerRe: Sharepoint DashBoard Pin
Ingo25-Jul-13 1:53
memberIngo25-Jul-13 1:53 
GeneralRe: Sharepoint DashBoard Pin
Veera MK24-Jul-13 23:50
memberVeera MK24-Jul-13 23:50 
QuestionSharepoint 2010 article edit button missing Pin
fasan2118-Jul-13 5:01
memberfasan2118-Jul-13 5:01 
AnswerRe: Sharepoint 2010 article edit button missing Pin
Ingo18-Jul-13 21:11
memberIngo18-Jul-13 21:11 
AnswerRe: Sharepoint 2010 article edit button missing Pin
dews turner29-Jul-13 15:47
memberdews turner29-Jul-13 15:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.