Query entity backend SQL script.

Question

Hi , 
 I am using QE to retrieving data from view with two pre-defined filters , with the same criteria if create a sql script and run in the DB the result is getting differed from the QE data retrieval. 
 so would like to check the script generated by the QE. 
 How/where can I see the query entity run time sql script ? 
 Thanks 
 Madhu

Sidhant Behura · Answer

Approach 1: Please check the below URL to log the details of Write to Data Store smart services and Query Rules. 
 docs.appian.com/.../Customizing_Application_Logging.html 
 
Approach 2: If still you are not able to see the SQL query being executed when you use the QE. Then follow the below steps. 
1. Log in to your MYSQL console or client. 
2. Select the database where the queried tables exist. 
3. Put a lock on the table being queried using the below command. 
	LOCK TABLES tablename READ; 
4. Execute the below command to see all the queries being executed on the database and identify yours. 
	SHOW FULL PROCESSLIST; 
5. Unlock the table using the below command. 
	UNLOCK TABLES; 
 
NOTE: Use the 2nd approach only if the 1st approach doesnt suffice your requirement. 
 
Hope this helps. 
 
Regards, 
Sidhant Behura