Query Filters

Filters are combined using an AND rule.

Attribute Value Filter

Matches Document Objects that corresponds to the given value of the selected attribute. First select the attribute to filter on, then set the Modifier to either contains , not contains, is empty or is not empty and then enter the attribute value (or part of the attribute value).

This filter is case-insensitive. Quotes do not apply. Aligned Elements provides the option to use SQL Server full text search to increase the performance of attribute queries, see Using SQL Server Full Text Search

Trace To Filter

Matches Document Objects that trace (or not trace) to Document Objects of a given type in given projects. Select the Document Object Type to trace to (can be one or more), then in which Projects these traced objects may reside and finally set the Modifier to either “any”, “all” or “none”.

The Modifier work as follows:

  • Trace to any of “Specification” and “Use Case” yields objects that trace to at least one Specification OR at least one Use Case (or both).

  • Trace to all of “Specification” and “Use Case” yields objects that trace to at least one Specification AND at least one Use Case.

  • Trace to none of “Specification” and “Use Case” yields objects that do not trace to any Specification or Use Case.

Trace To/From Query Filter

Matches Document Objects that trace (or not trace) to/from Document Objects in the Output set of other Queries. You can use this filter to combine Queries. Set the Modifier to “any”, “all” or “none” and then the Query that contains your target set.

The Modifier work as follows

  • Trace to any yields objects that trace to at least one object in the Target Query Output set.

  • Trace to all yields objects that trace to all objects in the Target Query Output set.

  • Trace to none yields objects that trace to none of the objects in the Target Query Output set.

Trace From Filter

Matches Document Objects that have incoming traces from Document Objects of a given type in given projects. Select the Document Object Type for the incoming traces (can be one or more), then in which Projects these incoming-trace objects may reside and finally set the Modifier to either “any”, “all” or “none”.

The Modifier work as follows:

  • Trace to any of “Specification” and “Use Case” yields objects that have incoming traces from at least one Specification OR at least one Use Case (or both).

  • Trace to all of “Specification” and “Use Case” yields objects that have incoming traces from at least one Specification AND at least one Use Case.

  • Trace to none of “Specification” and “Use Case” yields objects that do not have incoming trace to any Specification or Use Case.

Revision Date Filter

Matches Document Objects that have been created or modified before or after a certain date. Set the Modifier to created before, created after, modified before, modified after and then set the target date.

Revision Number Filter

Matches Document Objects that have a revision number greater, less, equal or not equal a certain number.

Revision Author Filter

Matches Document Objects that have a revision author that has created/not created, modified or not modified an object.

Revision Comment Filter

Matches the Document Objects where the most current revision has a Change Comment containing or not containing a particular word.

Inconsistency Filter

Matches Document Objects that have (or have not) a certain inconsistency. Select the Inconsistency Type and then set the Modifier to either “any”, “all” or “none”.

The Modifier work as follows:

  • Modifier any of Inconsistencies “Issue Open” and “NotReviewed” yields objects that have at least one open issue OR is not Reviewed (or both).

  • Modifier all of Inconsistencies “Issue Open” and “NotReviewed” yields objects that have at least one open issue AND is not Reviewed.

  • Modifier none of Inconsistencies “Issue Open” and “NotReviewed” yields objects that have no open issue AND is Reviewed i.e. that have none of the described inconsistencies

RPN Filter

The filter allows you to define a query based on the calculated Risk Priority Number value. It only applies to document object types such as Failuremode or RiskAnalysis and their underlying Hazard/ProbabilityOfHarm. You can apply the filter before or after Mitigations and include the RPN and/or RPNThreshold values in the query result.

RPN Threshold Filter

The filter allows you to define a query based on the calculated RPN Threshold (e.g. Acceptable, InAcceptable, ALARP/ALAP). It only applies to document object types such as Failuremode or RiskAnalysis and their underlying Hazard/ProbabilityOfHarm.

You can apply the filter before or after Mitigations and include the RPN and/or RPNThreshold values in the query result.

Function Filter

The filter allows you to define a complex condition using C# syntax. The result of the function must be a Boolean (true/false) and as parameters any Document object attribute string values can be defined where the name of the parameter is the name of the attribute.

Tag Filter

The filter allows you to sort out all Document Objects that belong (or not belong) to one or more tags.