This site requires JavaScript to be enabled
IE BUMPER

Logo

Dear Tricentis qTest users,

If you would like to submit a Tricentis qTest ticket,

please use this support request form.

Tosca Version
IncidentLookup using list
Language
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
  Help
IE BUMPER
Categories
Boolean Operators
OR or vertical bar symbol (|)
Finds a match if either the terms exist in a document (a union using sets).
AND
Finds a match if both terms exist in a document (an intersection of sets).
NOT, minus (-), or exclamation point (!)
Excludes documents that contain the term after NOT (a difference of sets).
Wildcards
Asterisk (*)
The asterisk symbol performs a multi character wildcard search.
Percent sign (%)
The percent sign performs a single character wildcard search.
Phrases
Quotation marks (")
Use quotation marks to search for an exact phrase with multiple terms.
For examples and more information look at our Knowledge Base: Advanced Search On The Support Portal

Verify (non-)existence of a value in a table/column with TBox

Verify (non-)existence of a value in a table/column with TBox


Situation

You have a table and want to verify that a particular value does (not) exist in a column or in the table in general.

Let's assume you have a table that includes customer info with columns like first name, last name, ...

 

Solution

Verify that a value does not appear in a column

This verifies that there is no row present where the column "Lastname" has a value of "Smith". To check that the value does appear, change ResultCount == 0 to ResultCount != 0.

Note: Do not use the property "Exists" shown below to verify row existence if it is possible there might be multiple controls matching the constraint. If there are, Tosca will not know which control to test, and the testcase will fail.

The analagous approach works to verify the (non-)existence of a value in a row.

 

Verify that a value does not appear in a table

This verifies that there is no row present that has the value "Smith" in any cell. Again, you can change False to True to verify that the value does exist.

0 1

shiba sahoo

Created: 2019-04-11 22:50:48

very helpful. Thanks

0 1

Meetali Lakhwani

Created: 2019-04-23 14:57:27

It worked.Thank you 

0 1

Meetali Lakhwani

Created: 2019-04-23 14:57:28

It worked.Thank you 

0 0

Paul Sailer

Created: 2019-08-07 08:31:00

This also worked for me verifying a certain value isn't returned in an array. :)

IE BUMPER

Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial