Dynamically Modify the WHERE Clause

ASP

Function Tasks_DataSource_BeforeBuildSelect(Sender)

  If Tasks.DataSource.Where <> Empty Then
    Tasks.DataSource.Where = Tasks.DataSource.Where & " AND "
  End if

  Tasks.DataSource.Where = Tasks.DataSource.Where & "task_name like 'Improve%'"

End Function

Note: If the OR operator is used in the WHERE clause the conditions must be in brakets "()". For example:

Tasks.DataSource.Where = Tasks.DataSource.Where & "(task_name like 'Improve%' OR task_name like 'Add%')"

PHP

function Tasks_DataSource_BeforeBuildSelect(& $sender) {
global $Tasks;

  if ($Tasks->DataSource->Where <> "") {
    $Tasks->DataSource->Where .= " AND ";
  }

  $Tasks->DataSource->Where .= "task_name like 'Improve%'";

}

Note: If the OR operator is used in the WHERE clause the conditions must be in brakets "()". For example:

  $Tasks->DataSource->Where .= "(task_name like 'Improve%' OR task_name like 'Add%')";

Perl

sub Tasks_DataSource_BeforeBuildSelect() {

  if ($Tasks->{DataSource}->{Where} ne "") {
    $Tasks->{DataSource}->{Where} .= " AND ";
  }
  $Tasks->{DataSource}->{Where} .= "task_name like 'Improve%'";

}

Note: If the OR operator is used in the WHERE clause the conditions must be in brakets "()". For example:

  $Tasks->{ds}->{Where} .= "(task_name like 'Improve%' OR task_name like 'Add%')";

ColdFusion

<!---Tasks_BeforeBuildSelect --->
  <CFIF strWhere NEQ "">
    <CFSET strWhere="#strWhere# AND ">
  </CFIF>
  <CFSET strWhere="#strWhere#task_name like 'Improve%'">

Note: If the OR operator is used in the WHERE clause the conditions must be in brakets "()". For example:

  <CFSET strWhere="#strWhere#(task_name like 'Improve%' OR task_name like 'Add%')">

Java

//Tasks_BeforeBuildSelect

  if (! StringUtils.isEmpty(e.getCommand().getWhere())) {
    e.getCommand().setWhere(e.getCommand().getWhere() + " AND task_name like '%Improve%'");
  } else {
    e.getCommand().setWhere("task_name like '%Improve%'");
  }

VB.Net

1. Add the Before Execute Select event to the Grid.
2. Within the event, add the code below:

'Tasks_BeforeExecuteSelect

  DirectCast(Select_,TableCommand).Where = "task_name like 'Improve%'"
  DirectCast(Select_,TableCommand).Operation = "AND"

C#

1. Add the Before Execute Select event to the Grid.
2. Within the event, add the code below:

//Tasks_BeforeExecuteSelect

  ((TableCommand)Select).Where = "task_name like 'Improve%'";
  ((TableCommand)Select).Operation = "AND";