Is there a way to see WF Activity Data Provider Query Code?

[Jason_Ricker]

I'm looking to see if there is a way to see the SQL code that creates the WF Activity Provider Query. Basically I like what the WF activity data provider shows I just want to link a couple more pieces of data to it. I would be taking the prebuilt query and joining a few more tables to make a separate custom query. I've looked and not seen anything in unity or config showing sql code for those providers unless im over looking it.  

This is not a huge deal if it is not accessible it would just save me time writing the query from scratch since I would like to do this with several others.

Thanks

Jason

[Karen_Gradowski]

Absolutely, (I do this quite often).

1. Log into the server and start Diagnostics
2. In Diagnostics: Clear all tabs click on database tab
3. Now open the OnBase client and open the dashboard
4. In Diagnostics: //Tools-> Stop Listening
5. In Diagnostics: Right click on a column heading ie: SQL choose "Filter by Row"
6. Highlight the cell with SQL and in top toolbar click //View-> Detail View here is where you can copy code

Hope this helps,

Karen

[Jason_Ricker]

I'll give that a try thanks!