Query Filters
Note! Filters are combined using an AND rule.
Attribute Value Filter
Matches Document Objects that correspond to the given value of the selected attribute.
First, select the attribute to filter on, then set the Modifier.
Then, enter the attribute value (or part of the attribute value).
Depending on the attribute type, different attribute modifiers are available.
For Date attributes, the Modifier has the options: before and after.
For number attributes, such as IntRange and Int Attributes, the Modifier has the options: equals, notEquals, less and greater.
For itemized attributes such as Enum Attributes, Boolean Attributes or MultiSelect Attributes, the Modifier has the options: all, any and none.
Text based attributes, such as Title, String Attributes, Richtext Attributes and Table Attributes, the Modifier has the options: contains, not contains, is empty, or is not empty, contains exact and not contains exact.
Contains and not contains uses SQL Server full-text indexing. See applicable constraints here: Stopwords in Full-text
containsExact can match parts of words whereas contains only looks for full words, i.e. if the filter value is 'user' containsExact will match both 'user' and 'users'. contains will only match 'user'.
Table Attributes also has the Modifier option: row contains. This modifier expects the filter value to be on a particular format. The format of the filter value is:
The column name
The expected value in that column
Thus, Column:Value e.g. Result:Passed.
The filter will look for a Table where a row exists where the column Result contains the value Passed.
It is also possible to search for empty values, using the constant not assigned as value.
A check on multiple column values in the same row needs to be separated by comma ‘,’.
Example: the filter value for the table attribute Assigned Users in Review to find Reviews where user Bill has not yet completed the review (i.e. the Date value is still empty):
User:Bill,Review Date:not assigned
Note! 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 works 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 to 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.
Filter value 'Contains' and SQL Server Full-text search
Aligned Elements uses SQL Server's full text indexing to provide the fastest possible search results. To prevent a full-text index from becoming bloated, SQL Server has a mechanism that discards commonly occurring strings that do not help the search. These discarded strings are called stopwords. During index creation, the Full-Text Engine omits stopwords from the full-text index.
Using the filter 'Contains' and 'not Contains' will this not render any matches on words that are considered stopwords by SQL Server.
An example of the default stopwords in SQL Server 2016 yields the following list:
· $
· 0
· 1
· 2
· 3
· 4
· 5
· 6
· 7
· 8
· 9
· A
· B
· C
· D
· E
· F
· G
· H
· I
· J
· K
· L
· M
· N
· O
· P
· Q
· R
· S
· T
· U
· V
· W
· X
· Y
· Z
· about
· after
· all
· also
· an
· and
· another
· any
· are
· as
· at
· be
· because
· been
· before
· being
· between
· both
· but
· by
· came
· can
· come
· could
· did
· do
· does
· each
· else
· for
· from
· get
· got
· had
· has
· have
· he
· her
· here
· him
· himself
· his
· how
· if
· in
· into
· is
· it
· its
· just
· like
· make
· many
· me
· might
· more
· most
· much
· must
· my
· never
· no
· now
· of
· on
· only
· or
· other
· our
· out
· over
· re
· said
· same
· see
· should
· since
· so
· some
· still
· such
· take
· than
· that
· the
· their
· them
· then
· there
· these
· they
· this
· those
· through
· to
· too
· under
· up
· use
· very
· want
· was
· way
· we
· well
· were
· what
· when
· where
· which
· while
· who
· will
· with
· would
· you
· your
The stopwords list can be edited in SQL Server. If this is desirable, contact your Aligned Elements administrator.
Last updated