Hi All,
I tried using the transaction function on the output of a DB Connect |dbquery and it keeps showing no results.
So my data is like this:
Date ID Status
2014/05/12 1 Created
2014/05/12 2 Created
2014/05/12 2 Processing
2014/05/12 1 Processing
2014/05/13 1 Completed
2014/05/13 2 Completed
When I do something like |dbquery <SQL query to get data in above given format>|transaction Status
it returns as no records found.
Kindly provide guidance on this.
What do you get if you just do this:
|dbquery <SQL query to get data in above given format>
Plus, it seems strange to me that you would create a transaction based on Status
- what are you trying to do?
Hello lguinn,
Thanks you for your reply. The output I gave in the OP is my result set from the SQL query. The transaction should take into account both the ID and the Status. But I tried this in the DB connect app and it still does not work. Is it that the transaction function can only be used in the Search app?