Queries in document

[Shilpa_Dubey]

Hi All,

In one document I want to populate the list of requirements. Can I embed queries as one step or document in templates under libraries?

Eg: i have one Project/Library folder under which i have two templates

SRS template 1

SRS template 2

Under SRS template 1 I want the list of requirements to be displayed, can i call a query or add its result as one step in any document?

Thanks and Regards,

Shilpa 

[awalsh]

I think what would work is a Query Backed Relationship (QBR) field.  

For example, if each requirement is linked to a document with a particular field (e.g. Requirement For), then you would create a new query that returns requirements. Then create a QBR field that uses this query, and the Field Correlation "ID"="Requirement For" to be visible on the Document.

The field would contain all requirements that are linked to the document via the Requirement For relationship. 

QBR fields are not editable by the user; they are updated when the query results change or when the correlation field values change.