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

How to take Result extract from Table (Buffer) after executing SQL Query through Tosca BI

Hi,

 

I use Tosca BI and use TBox DB Expert module for running an SQL statement through DSN connection. I wanted to buffer the SQL result from table to an excel or notepad. Can you please suggest how to use Buffer command for Result table.

 

Regards,

Ashwin

0 0

Chiranjibi Prasad

Created: 2017-10-08 13:08:46

Step-1: Connect to the DSN server

Step-2: Buffer the desired value from table:  If you are aware of how to use table in Tosca then it is in same way. Suppose you want to buffer 5th row 2nd column value then Row= #5  cell= #2 and give some buffer name.

Step-3: Store value in a text file: for this you can use Create file module available in standard module file folder. here you have to give the buffer name that used in step-2

Sujata Maske

2018-10-11 09:04:18

Ho wto store the entire table as buffer

1 0

Prakash Krishnan

Created: 2018-10-29 09:48:25 , Updates: 1, Last Update: 2018-10-29 09:48:49

Hi Sujata,

 

By using Tbox module, we cant take the entire table values as a Backup. We have to go with Tosca BI

 

0 0

Pugazhvanan Ganapathy

Created: 2019-04-23 21:29:36

You do not even need BI. You can use PowerShell do store the result. Check out this article. 

https://support.tricentis.com/community/article.do?number=KB0014558

 

Thanks,

Pugal

IE BUMPER

Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial