Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Find all related Forms for Web Resources? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    I've run a SQL query against the Webresources table to filter out all JavaScript files.   Does anyone know which table(s) I can join to find all Forms that the files are attached to?
    Tuesday, March 4, 2014 7:39 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    You've got to join DependencyNodeBase and DependencyBase tables to get the required data.

    SELECT DISTINCT WebResource.Name, Entity.Name, SystemFormBase.Name
FROM DependencyNodeBase RequiredComponent
INNER JOIN WebResource ON WebResource.WebResourceId = RequiredComponent.ObjectId
INNER JOIN DependencyBase  ON RequiredComponent.DependencyNodeId = DependencyBase.RequiredComponentNodeId
INNER JOIN DependencyNodeBase DependentComponent ON DependentComponent.DependencyNodeId = DependencyBase.DependentComponentNodeId
INNER JOIN SystemFormBase ON SystemFormBase.FormId = DependentComponent.ObjectId
INNER JOIN Entity ON Entity.ObjectTypeCode = SystemFormBase.ObjectTypeCode
WHERE WebResource.WebResourceType = 3 -- JavaScript

    • Marked as answer by Cipher Wednesday, March 5, 2014 3:01 AM
    Wednesday, March 5, 2014 2:22 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    You've got to join DependencyNodeBase and DependencyBase tables to get the required data.

    SELECT DISTINCT WebResource.Name, Entity.Name, SystemFormBase.Name
FROM DependencyNodeBase RequiredComponent
INNER JOIN WebResource ON WebResource.WebResourceId = RequiredComponent.ObjectId
INNER JOIN DependencyBase  ON RequiredComponent.DependencyNodeId = DependencyBase.RequiredComponentNodeId
INNER JOIN DependencyNodeBase DependentComponent ON DependentComponent.DependencyNodeId = DependencyBase.DependentComponentNodeId
INNER JOIN SystemFormBase ON SystemFormBase.FormId = DependentComponent.ObjectId
INNER JOIN Entity ON Entity.ObjectTypeCode = SystemFormBase.ObjectTypeCode
WHERE WebResource.WebResourceType = 3 -- JavaScript

    • Marked as answer by Cipher Wednesday, March 5, 2014 3:01 AM
    Wednesday, March 5, 2014 2:22 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks, Linn.  That worked perfectly.
    Wednesday, March 5, 2014 3:02 AM