February 10, 2012  
   Login  
Forum  
 
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Sharepoint Calendar - Deleted items still being found in Eneysys querySharepoint Calendar - Deleted items still being found in Eneysys query
Previous Previous
 
Next Next
New Post
 4/29/2009 1:10 AM
 

Here is my query that I'm using:

<?xml version="1.0" encoding="utf-8" ?>
<root xmlns="http://enesyssoftware.com/schemas">
  <list listID="{7272B626-BD81-45D1-BA8E-6DF8EDDA1C4C}" relativeSiteUrl="/" tableName="RecProgramSchedule" expandFirstDate="2007-01-01T00:00:00" expandRecurrent="true" expandLastDate="2015-12-31T00:00:00">
<fields></fields>
    <query>
      <Where>
            <Eq>
              <FieldRef Name='fRecurrence' />
              <Value Type="Boolean">1</Value>
            </Eq>
      </Where>
    </query>
  </list>
  <list listID="{7272B626-BD81-45D1-BA8E-6DF8EDDA1C4C}" relativeSiteUrl="/" tableName="ProgramSchedule" expandRecurrent="false">
<fields></fields>
    <query>
      <Where>
        <And>
          <And>
            <Geq>
              <FieldRef Name='EventDate' />
              <Value Type='DateTime'>@StartDate!</Value>
            </Geq>
            <Leq>
              <FieldRef Name='EndDate' />
              <Value Type='DateTime'>@EndDate!</Value>
            </Leq>
          </And>
          <Eq>
            <FieldRef Name='fRecurrence' />
            <Value Type="Boolean">0</Value>
          </Eq>
        </And>
      </Where>
    </query>
  </list>
  <sqlOp op="union">
    <dstTableName>Merged</dstTableName>
    <parentTableName>RecProgramSchedule</parentTableName>
    <childTableName>ProgramSchedule</childTableName>
    <labelColumn>true</labelColumn>
    <parentLabelValue>Recurrent</parentLabelValue>
    <childLabelValue>Non Recurrent</childLabelValue>   
  </sqlOp>
  <resultSet>Merged</resultSet>
</root>

 

There are recurring items that have been removed that are still showing up.  Is there any way to correct this?

New Post
 4/29/2009 2:02 PM
 


Hi,

Could you please use Automatic mode for retrieving events and see if you still get the same problem?

Regards,


Frederic LATOUR
ENESYS
Previous Previous
 
Next Next
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Sharepoint Calendar - Deleted items still being found in Eneysys querySharepoint Calendar - Deleted items still being found in Eneysys query

 
You need to login for posting to the forums.
If you don't have a login, click here to register.
 
Copyright 2010 Enesys - All rights reserved Terms Of UsePrivacy Statement