Nintex Connect

The Official Community Site for Nintex Software Products, including Nintex Workflow 2007, 2010 and 2013; Nintex Workflow for Project Server 2010; Nintex Reporting 2008 and Nintex Analytics 2010; Nintex Forms 2010; Nintex Live and Nintex SmartLibrary.
Welcome to Nintex Connect Sign in | Join | Help

Query List and datetime filter

  •  05-20-2011, 2:49 AM

    Query List and datetime filter

    Looks like  when applying a filter which compares dates inside a query list, the time is not considered.

    I have worked around it by switching to caml query and adding IncludeTimeValue="true"

     

    <Query>
        <Lists>
            <List ID="{FE4CCE06-89EC-42CF-BDCA-CADDB28BE9B1}" />
        </Lists>
        <ViewFields>
            <FieldRef Name="_x0034_d429f20_x002d_6fd4_x002d_4faa_x002d_97ec_x002d_72995b192337" />
        </ViewFields>
        <Where>
            <And>
                <Lt>
                    <FieldRef Name="Modified" />
                    <Value Type="DateTime" IncludeTimeValue="TRUE">{WorkflowVariable:DefinedDateForDeletion}</Value>
                </Lt>
                <Eq>
                    <FieldRef Name="WorkflowApprovalStatus" />
                    <Value Type="Text">Rejected</Value>
                </Eq>
            </And>
        </Where>
    </Query>

    Filed under: ,
View Complete Thread
Powered by Community Server, by Telligent Systems