John, You cannot.
You can have workflow that looks at what is entered in fields and what is entered in the advanced search bar. You cannot however get ahold of the SQL generated. The way the system is constructed is that the qualification comes across the wire as an AR System qualification. That is parsed and processed by the server. There is no workflow on searches at all, but even if there were, the server layers are Receive call and route to a queue Data validation/ access control checking Filters Translation to SQL and issuing command The only layer you would have access is the Filter layer and that occurs before any translation to SQL. There is no way to capture in advance the SQL. You can log SQL statements so you can look at it later, but that is after the fact. You cannot get ahold of the SQL statement in logic. Doug ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of J Kovalcik Sent: Thursday, July 15, 2010 2:43 PM To: [email protected] Subject: Capturing SQL Statement ** Listers, I would like to capture the SQL query before it would be submitted to the database. For example, if in a search form, the user enters search criteria in any fields or the advanced search bar, I would like to capture that query before clicking the search button. Can I use one of the Remedy API's that are already built ? Or are there any other ideas ? Thanks, John Kovalcik _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
