Hi. I am trying to use a custom WHERE clause in an OperationBinding. I must be doing something wrong, because the query is still using “where ‘1’=‘1’”. To simplify the issue, I tried with a small test case, and the problem still exists. Here is my ds.xml:
<DataSource
dbName="mydb"
tableName="mytable"
ID="myds"
dataSourceVersion="1"
generatedBy="SC_SNAPSHOT-2009-12-17/EVAL Deployment 2009-12-17"
serverType="sql"
>
<fields>
<field name="approved" type="integer"></field>
</fields>
<operationBinding operationType="fetch">
<whereClause>
approved=1
</whereClause>
</operationBinding>
</DataSource>
Can you tell what I am missing/doing wrong?
Thanks!