000012052 - Query to retrieve information about the file repository file and module IDs  content IDs & field ID's - RSA Archer

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000012052
Applies ToRSA Archer 5.X
IssueQuery to retrieve information about the file repository file and module IDs, content IDs & field ID's
Resolution
QUERY:
===================
SELECT c. content_id, a .field_id, a.field_name , e. file_name,e .file_id, f.module_name, f.module_id
FROM tblIVFieldDef a
INNER JOIN tblLevel b on a .level_id = b.level_id
INNER JOIN tblIVContent c on b .module_id = c.module_id
INNER JOIN tblXIVContentRepositoryLinks d on d .content_id = c.content_id and d. field_id = a .field_id
INNER JOIN tblRepositoryFile e on e .file_id = d. file_id
INNER JOIN tblModule f on c .module_id = f.module_id
Legacy Article IDa67776

Attachments

    Outcomes