Click here to Skip to main content
14,694,505 members
Home » Discussions » SharePoint
   

SharePoint

 
QuestionUnable to delete page from a website Pin
dadda_12313-Aug-13 2:09
Memberdadda_12313-Aug-13 2:09 
AnswerRe: Unable to delete page from a website Pin
Ingo19-Aug-13 3:58
MemberIngo19-Aug-13 3:58 
AnswerRe: Unable to delete page from a website Pin
nishant231029-Aug-13 0:24
Membernishant231029-Aug-13 0:24 
QuestionCAML query for nested and / or Pin
DownUnderMark8-Aug-13 0:03
professionalDownUnderMark8-Aug-13 0:03 
AnswerRe: CAML query for nested and / or Pin
Manohar P8-Aug-13 19:29
MemberManohar P8-Aug-13 19:29 
GeneralRe: CAML query for nested and / or Pin
DownUnderMark8-Aug-13 21:42
professionalDownUnderMark8-Aug-13 21:42 
AnswerRe: CAML query for nested and / or Pin
Manohar P9-Aug-13 0:54
MemberManohar P9-Aug-13 0:54 
GeneralRe: CAML query for nested and / or Pin
DownUnderMark12-Aug-13 1:53
professionalDownUnderMark12-Aug-13 1: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 4:16
Membernainakarri7-Aug-13 4:16 
AnswerRe: Typedescriptor ambiguity for reflection Pin
nainakarri14-Aug-13 1:10
Membernainakarri14-Aug-13 1:10 
QuestionDisplay Resources in a Sharepoint Calendar Pin
Manohar P6-Aug-13 19:21
MemberManohar P6-Aug-13 19:21 
QuestionFind no of visitors in website using sharepoint 2010 Pin
Game-point25-Jul-13 9:07
MemberGame-point25-Jul-13 9:07 
AnswerRe: Find no of visitors in website using sharepoint 2010 Pin
Ingo27-Jul-13 12:53
MemberIngo27-Jul-13 12:53 
QuestionSharepoint DashBoard Pin
Veera MK24-Jul-13 1:21
MemberVeera MK24-Jul-13 1:21 
AnswerRe: Sharepoint DashBoard Pin
Ingo25-Jul-13 0:00
MemberIngo25-Jul-13 0:00 
GeneralRe: Sharepoint DashBoard Pin
Veera MK25-Jul-13 0:41
MemberVeera MK25-Jul-13 0:41 
AnswerRe: Sharepoint DashBoard Pin
Ingo25-Jul-13 2:53
MemberIngo25-Jul-13 2:53 
GeneralRe: Sharepoint DashBoard Pin
Veera MK25-Jul-13 0:50
MemberVeera MK25-Jul-13 0:50 
QuestionSharepoint 2010 article edit button missing Pin
fasan2118-Jul-13 6:01
Memberfasan2118-Jul-13 6:01 
AnswerRe: Sharepoint 2010 article edit button missing Pin
Ingo18-Jul-13 22:11
MemberIngo18-Jul-13 22:11 
AnswerRe: Sharepoint 2010 article edit button missing Pin
dews turner29-Jul-13 16:47
Memberdews turner29-Jul-13 16: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 6:00
MemberJonny Galt18-Jul-13 6:00 
Questionto fetch data from repeating table of infopath to sharepoint list 2010 Pin
vanita khatnani14-Jul-13 23:57
professionalvanita khatnani14-Jul-13 23:57 
AnswerRe: to fetch data from repeating table of infopath to sharepoint list 2010 Pin
Ingo18-Jul-13 22:37
MemberIngo18-Jul-13 22:37 
GeneralRe: to fetch data from repeating table of infopath to sharepoint list 2010 Pin
vanita khatnani19-Jul-13 2:30
professionalvanita khatnani19-Jul-13 2: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.