Re: Active-link Associated with from

[Charlie Lotridge]

Hi Rajesh,

These three queries pull the desired counts for the User form.  Change
"User" to your desired form to get the results you need.

SELECT COUNT(*)
FROM actlink a
JOIN actlink_mapping am
ON am.actlinkId = a.actlinkId
JOIN arschema s
ON s.schemaId = am.schemaId
WHERE s.name = 'User'

SELECT COUNT(*)
FROM filter f
JOIN filter_mapping fm
ON fm.filterId = f.filterId
JOIN arschema s
ON s.schemaId = fm.schemaId
WHERE s.name = 'User'

SELECT COUNT(*)
FROM escalation e
JOIN escal_mapping em
ON em.escalationId = e.escalationId
JOIN arschema s
ON s.schemaId = em.schemaId
WHERE s.name = 'User'

-charlie


On Mon, May 26, 2014 at 12:50 PM, Rajesh Singh
<rajesh.singh0...@gmail.com>wrote:

> Hi ,
>
>
> Could anyone of you please help me to , to know the SQL query to find the
> no of active-link, filter and escalation associated with the form from
> Database side.
>
>
>
> Thanks
> Rajesh
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"