select fs.submissionId, fs.formId, f.formname
from tbl_wrk_formSubmissions fs with (nolock)
inner join tbl_wrk_forms f with (nolock)
on f.formid = fs.formid
and f.ownerid = fs.ownerid
and f.ownertype = fs.ownertype
where fs.ownerid =
and fs.ownertype =
and fs.linkid =
and fs.linktype = 'ISD'
fieldAttributes = StructNew();
fieldAttributes.domainName = qmd_form.fieldDomain;
fieldAttributes.partnerId = qryLinkedFormSubmission.submissionId;
fieldAttributes.partnerType = "WFS";
fieldAttributes.category = qmd_form.fieldCategory;
select data
from qmd_fieldValues
where type = 'FILE'
select contentPath
from qryContentFullPathLookup
where ContentID in ()
select *
from qmd_forms
where formid not in ()
#)