Hi,
we built a questionnaire that consists of a question and answers (yes/no/N/A). We are trying to extract question answers using sql query, but no luck so far. Here is the query:
select
sr.File_Review_ID, RN.DISPLAYNAME, C.NAME_FULL, C.TITLE, C.ORG_UNIT, sr.Last_Update_Date_Date,qval.Value,qval.Id answerid,Progressfrom ARCHER_BUSINESS_HIERARCHY.DBO.Advanced_Support_Recovery_Subsequent_F srleft join ARCHER_BUSINESS_HIERARCHY.DBO.Advanced_Support_Recovery_Subsequent_F_File_Reviewer_Name rn on rn.ParentContentId = sr.ContentIdleft join ARCHER_BUSINESS_HIERARCHY.DBO.Contacts_Advanced_Support__Recovery__Subsequent_F_x_Advanced_Support_Recovery_Subsequent_F_Recovery_Specialist_Name sn on sn.Advanced_Support_Recovery_Subsequent_F_Recovery_Specialist_Name_ContentId = sr.ContentIdLEFT JOIN ARCHER_BUSINESS_HIERARCHY.DBO.Contacts c on c.ContentId = sn.Contacts_Advanced_Support__Recovery__Subsequent_F_ContentIdleft join ARCHER_BUSINESS_HIERARCHY.DBO.Advanced_Support_Recovery_Subsequent_F_Q10 q on sr.ContentId = q.ParentContentIdleft join ARCHER_BUSINESS_HIERARCHY.DBO.enum_Q104 qval on qval.Id = q.ValueWe understand that e.g ARCHER_BUSINESS_HIERARCHY.DBO.enum_Q104 will have the answer but for some reason we are not getting it.
Does anybody know how to get question answers using sql query? Thanks so much!
Originally posted on April 1, 2022 in the Archer Community.
Comments
1 comment
Related idea... but using reports not SQL extraction...
@Fard.Thomas - Any ideas if this is an available pattern in an OOB report or dependencies on extraction method referenced above? I think TPRM Solution needs to be pushed using data publication?
Originally posted on June 20, 2024.
Please sign in to leave a comment.