<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic You'd have to parse the XML… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Object-Action-Process-Dependency/m-p/69269#M21874</link>
    <description>You'd have to parse the XML for the process.</description>
    <pubDate>Tue, 20 Nov 2018 21:34:00 GMT</pubDate>
    <dc:creator>AmiBarrett</dc:creator>
    <dc:date>2018-11-20T21:34:00Z</dc:date>
    <item>
      <title>Object Action - Process Dependency</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Object-Action-Process-Dependency/m-p/69268#M21873</link>
      <description>Hi,

I am writing&amp;nbsp;SQL queries&amp;nbsp;to fetch the Process Page on which the Object Actions are consumed. I am not able to find the SQL Table which has Process page name and referencing of Object Actions.

The query, I wrote, outputs the Process Name only(Not a specific page) on which the Object Actions are consumed.

When I navigate to Studio&amp;gt; click Any Object&amp;gt; click Find references&amp;nbsp;on&amp;nbsp;Blue Prism UI, I can see Process Page&amp;nbsp;and Stage on which Object Actions are consumed.

I want something similar by writing a SQL query. can somebody help me with the correct SQL Table&amp;nbsp;names to find Process Page Names and Object Referencing?

Thanks,</description>
      <pubDate>Tue, 20 Nov 2018 21:29:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Object-Action-Process-Dependency/m-p/69268#M21873</guid>
      <dc:creator>Akhlesh_KumarJi</dc:creator>
      <dc:date>2018-11-20T21:29:00Z</dc:date>
    </item>
    <item>
      <title>You'd have to parse the XML…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Object-Action-Process-Dependency/m-p/69269#M21874</link>
      <description>You'd have to parse the XML for the process.</description>
      <pubDate>Tue, 20 Nov 2018 21:34:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Object-Action-Process-Dependency/m-p/69269#M21874</guid>
      <dc:creator>AmiBarrett</dc:creator>
      <dc:date>2018-11-20T21:34:00Z</dc:date>
    </item>
    <item>
      <title>Is there any another way…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Object-Action-Process-Dependency/m-p/69270#M21875</link>
      <description>Is there any another&amp;nbsp;way apart from extracting data from Process XML?</description>
      <pubDate>Wed, 21 Nov 2018 08:28:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Object-Action-Process-Dependency/m-p/69270#M21875</guid>
      <dc:creator>Akhlesh_KumarJi</dc:creator>
      <dc:date>2018-11-21T08:28:00Z</dc:date>
    </item>
    <item>
      <title>Hi akjindal!
This might help…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Object-Action-Process-Dependency/m-p/69271#M21876</link>
      <description>Hi akjindal!
This might help:
select distinct p.name
&amp;nbsp;from BPAProcessActionDependency &amp;nbsp;pd, &amp;nbsp;BPAProcess p
where pd.processid = p.processid&amp;nbsp;
&amp;nbsp;&amp;nbsp; &amp;nbsp;and pd.refProcessName = ''
order by p.name</description>
      <pubDate>Mon, 26 Nov 2018 17:30:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Object-Action-Process-Dependency/m-p/69271#M21876</guid>
      <dc:creator>CarstenClaussen</dc:creator>
      <dc:date>2018-11-26T17:30:00Z</dc:date>
    </item>
  </channel>
</rss>

