difficulty with whereclause parameter

[waltomaley]

I am trying to create a select statement with whereclause:

 

here is the query

 

select * from $P!{vendingSchema}REPORT_DOWNLOAD $P!{whereClause} order by SUBSCRIBER_ID, CONTENT_TYPE

 

The whereClause is as follows:

 

"where FULFILLMENT_STATUS = Purchased"

 

whereClause is set to java.lang.String. I've tried it with and without prompting

 

 

Basically the query still works but ignores the where statement all together

 

appreciate any guidance

 

walto

[waltomaley]

Essentially solved my own problem. The literal Purchased needed to be in single quotes 'Purchased'.

 

I did not use a where clause but a simple where statement of where FULFILLMENT_STATUS = 'Purchased'