private static string GenerateAlertQuery(string frequency, DateTime lastRun)
{
string query = @"<Where>
<And>
<And>
<Eq>
<FieldRef Name='Active' />
<Value Type='Boolean'>1</Value>
</Eq>
<Eq>
<FieldRef Name='Frequency' />
<Value Type='Choice'>{0}</Value>
</Eq>
</And>
<Lt>
<FieldRef Name='Last_x0020_Run' />
<Value Type='DateTime' IncludeTimeValue='True'>{1}</Value>
</Lt>
</And>
</Where>";
}
{0} in CAML Query will refer first parameter i.e. frequency
{1) in CAML Query will refer second parameter i.e. lastRun.
{
string query = @"<Where>
<And>
<And>
<Eq>
<FieldRef Name='Active' />
<Value Type='Boolean'>1</Value>
</Eq>
<Eq>
<FieldRef Name='Frequency' />
<Value Type='Choice'>{0}</Value>
</Eq>
</And>
<Lt>
<FieldRef Name='Last_x0020_Run' />
<Value Type='DateTime' IncludeTimeValue='True'>{1}</Value>
</Lt>
</And>
</Where>";
}
{0} in CAML Query will refer first parameter i.e. frequency
{1) in CAML Query will refer second parameter i.e. lastRun.
No comments:
Post a Comment