SQL query

[Anonymous]

Hi, Is there a document to understand the sql database that BP creates? Or could someone who knows it well assist me to make an SQL query please? Here is what I need to do: Find the location (process name and page name and action stage name) of all Action Stages of type Set Cell Value using the MS Excel VBO where Input contains Now() or Today(). If anyone can assist I would appreciate it, thank you.

[John__Carter]

Hi Seth - process/object XML is held in the BPAProcess table in a single cell. If you copy an Action stage that references Set Cell Value into Notepad you'll see how the XML is structured, and that will give you an idea of how a WHERE clause could work in a query. Directly querying the DB is not advised though, unless you really know what you're doing and accept the risk involved. A longer but less risky approach would be to use the Find References feature in the BP Client to find where the MS Excel object is used, then open each diagram and use the Search to look for Set Cell Value.

[Anonymous]

Thanks John, much appreciate your reply. That explains why I couldn't find anything in the DB! I have considered the longer approach you suggested, but for so many processes it would be very long! I will consider the best option knowing this now.