When all criteria have been added, click the Query button. The results will display in the Results panel appropriate to the query being performed (VA or FDB). To see details of the record, click the link in the Select column. The links are either Active (current VA record), Historical (old version of an active VA record), or Open (FDB record). Query Filters The Advanced Query/Customization query function provides Filters that allow you to control what data is returned by the query. The filters are. Table 3: Query Filters Filter Name Filter Function Contains The contents of the Value field appears somewhere in the database row of the Field being queried. Used primarily for fields containing text data. Contains is the default Filter option. Contains = would match 25, 125, “25” and 250, but not 205. Equal To The contents of the Value field exactly matches the contents of the database row of the Field being queried. = would match 25, but not “Equal To” “25” 125, 250, or 205. Less than or Equal to The contents of the Value field is less than or equal to the contents of the database row of the Field being queried. Greater than or Equal to The contents of the Value field is greater than or equal to the contents of the database row of the Field being queried. Begins with The contents of the database row of the Field being queried starts with the contents of the Value field. Ends with The contents of the database row of the Field being queried ends with the contents of the Value field. Greater than The contents of the Value field is greater than the contents database row of the Field being queried. Less than The contents of the Value field is less than the contents database row of the Field being queried. Not equal to The contents of the Value field does not exactly match the contents of the database row of the Field being queried. And/Or Usage Examples To see approved records with an interaction description equal to "anti" or "Lido", build the query as follows: Table 4: And/Or Example 1 Field Filter Value And/Or Interaction description Equals anti And Status Equals approved Or Interaction description Equals Lido And Status Equals approved If you build the query below, you will get approved records with an interaction description = "anti", but you will get all records with an interaction description of "Lido", regardless of status.
When all criteria have been added, click the Query button. The results will display in the Results panel appropriate to the query being performed (VA or FDB). To see details of the record, click the link in the Select column. The links are either Active (current VA record), Historical (old version of an active VA record), or Open (FDB record). Query Filters The Advanced Query/Customization query function provides Filters that allow you to control what data is returned by the query. The filters are. Table 3: Query Filters Filter Name Filter Function Contains The contents of the Value field appears somewhere in the database row of the Field being queried. Used primarily for fields containing text data. Contains is the default Filter option. Contains = “25” would match 25, 125, and 250, but not 205. Equal To The contents of the Value field exactly matches the contents of the database row of the Field being queried. “Equal To” = “25” would match 25, but not 125, 250, or 205. Less than or Equal to The contents of the Value field is less than or equal to the contents of the database row of the Field being queried. Greater than or Equal to The contents of the Value field is greater than or equal to the contents of the database row of the Field being queried. Begins with The contents of the database row of the Field being queried starts with the contents of the Value field. Ends with The contents of the database row of the Field being queried ends with the contents of the Value field. Greater than The contents of the Value field is greater than the contents database row of the Field being queried. Less than The contents of the Value field is less than the contents database row of the Field being queried. Not equal to The contents of the Value field does not exactly match the contents of the database row of the Field being queried. And/Or Usage Examples To see approved records with an interaction description equal to "anti" or "Lido", build the query as follows: Table 4: And/Or Example 1 Field Filter Value And/Or Interaction description Equals anti And Status Equals approved Or Interaction description Equals Lido And Status Equals approved If you build the query below, you will get approved records with an interaction description = "anti", but you will get all records with an interaction description of "Lido", regardless of status.
prec_6_1_ug_r0717.docx