waltomaley

Members

Everything posted by waltomaley

difficulty with whereclause parameter

waltomaley replied to waltomaley's topic in Products

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'
difficulty with whereclause parameter

waltomaley posted a topic in Products

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