Click here to Skip to main content
14,272,175 members

SharePoint

 
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 
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 
Hi Manohar and others,

I ended up utilising the CAML builder and cleaned the query up in Notepad++.

I tested it and it works well but unfortunately I ran into another problem Frown | :(

If "Action One Due Date" is greater than today and status = "completed" it stops and doesn't continue on to the next actions to apply the rule. Is there a different way to go about this?

<Query>
    <Where>
        <And>
            <Lt>
            <FieldRef Name="Action One Due Date" />
            <Value Type="DateTime"><Today/></Value>
        </Lt>
        <Or>
            <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>
                                <Neq>
                                    <FieldRef Name="Action Four Status" />
                                    <Value Type="Text">Completed</Value>
                                </Neq>
                            </And>
                        </Or>
                    </And>
                </Or>
            </And>
        </Or>
    </And>
</Where>
</Query>

<pre lang="xml">

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 
QuestionCustomAction URL in Site Actions menu wrapped in a feature shows up only in the root site collection before the feature is activated Pin
Jonny Galt18-Jul-13 5:00
memberJonny Galt18-Jul-13 5:00 
Questionto fetch data from repeating table of infopath to sharepoint list 2010 Pin
vanita khatnani14-Jul-13 22:57
professionalvanita khatnani14-Jul-13 22:57 
AnswerRe: to fetch data from repeating table of infopath to sharepoint list 2010 Pin
Ingo18-Jul-13 21:37
memberIngo18-Jul-13 21:37 
GeneralRe: to fetch data from repeating table of infopath to sharepoint list 2010 Pin
vanita khatnani19-Jul-13 1:30
professionalvanita khatnani19-Jul-13 1:30 

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.