This site requires JavaScript to be enabled
IE BUMPER

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

How to get the row count of records in Test data service (TDS)

 


Situation

I want to get the row count of records in TDS. 

Solution

The simplified version with less TestSteps:

Remarks:

  • Optional: It is possible to specify an additional search pattern to only count specific records (e.g. status == "Success")
  • The loop exits automatically if no new records are found, even without search pattern
  • Find & provide record module or Expert module can be used.
  • WARNING: Locked records are not counted!

 

Better alternative via TDS REST-API (faster, counts all records):

To count all records (include locked/consumed ones) is to use the TDS Rest-API. 

----------------(Thank you Philipp Dessovic for referring the above solution)------------------------

 

Alternate way: (Warning: This method only counts unlocked records and can be simplified.)

We need to follow the below steps to get the row count.

  1. User Find & provide record module and trigger a required condition with constraints (if required). Example make != NULL
  2. Create a test case
  3. Inside test case, add Tbox set buffer step to initiate the "Counter" with value 0
  4. Include while loop -> in Condition verify any value != NULL
  5. In loop increase the counter with TBox set buffer module
  6. With the help of exit criteria !=, your test case will come out of the loop and your counter will be the total row count of TDS

 

4 0

Philipp Dessovic

Created: 2018-10-24 14:04:32 , Updates: 2, Last Update: 2018-10-29 12:46:29

This comment was included in the article. See above.

Attachments

Ramya Rv

2018-10-25 13:18:37

where do I find these modules? Not able to download the attachment.

0 0

Akash Srivastava

Created: 2018-10-26 07:09:36

@RAMYA RV

 

You need to import the subset in Tosca and work upon that. This attachment is a Subset File.

Ramya RV

2018-12-11 15:14:02

I know about the import subset. To do importsubset I have to download the attachment from the incident where it's getting saved as html.

0 0

Samuel Nittala

Created: 2019-08-25 11:59:04

This attachment downloads a 0 byte file wiht the name "sys_attachment.do"

0 0

Shivendra Kumar Tripathi

Created: 2019-08-29 20:15:43

@SAMUEL NITTALA

Please find attachment here.

Attachments
0 0

Sebastian Roggmann

Created: 2019-09-16 14:26:55

Hi,

unfortunatly i can't download the tsu files - please can you update the links 

Philipp Dessovic

2019-12-10 17:47:34

FYI: You need to be logged in to download the attachment.

0 0

jamal loutfi

Created: 2020-02-14 13:14:55

Can somebody please forward me the tsu as the download is not working, even if i am logged in ;)

 

Thanks in advantage

IE BUMPER

Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial