• Create, edit, view, report test cases
• Extract & obfuscate test data from production systems
• Record and playback interactive sessions
• Submit & monitor batch jobs
• Review results (Extending test plans)
• Execute and monitor remote commands on IBM i, Windows, and Linux systems

• Verify version or configuration details (e.g. dspdtaara)
• Start application [e.g. strsbs() or cmd() or call pgm() ]
• Confirm running status [ e.g. dsp* or wrkactjob sbs() or ...]

• Application test script (python, java, windows) for RDOt Agents
• API call(s)

Hello Dale,

The DevOps testing is a great product. 

I am preparing some use cases with the RDO Testing product, but I have not been able to register filters in Test Data Scenerario.

I looked in the documentation but did not find examples. 

Could you please send me a few examples to select a data, for example, I registered these filters but the RDO system show me "SQL syntax error".

1 IBM i - SELECT * FROM PRODUCCION.SALES WHERE SALES_PERSON = 'LEE'

2 SQL Server - SELECT * FROM [DEMO1].[dbo].[VENTAS] WHERE COMPLEMENTO = 'AMERICAS'

If you send me a short video would be great.

Best regards,

Miguel

Hola, Miguel.

Thanks for the interest and feedback.

We'll continue to work with you in the case we've just opened, but including links/info below regarding User Guide and YouTube sessions that are available.

Best, 

d

~~

The Rocket Doc site contain links to the RDOt team shares on configuration and use examples.

https://docs.rocketsoftware.com/bundle/rdot_ug_1031/page/vcb1707156809863.html

Videos

Instructional videos for RDOt are available on YouTube: https://www.youtube.com/playlist?list=PLrS4TQFvievT4zH9iy051kZh_ZTExvYkl

Hello Dale

Thank you for your quick anwser.

Yes I saw these videos last week, I have 2 Test Planning are working very good (Test data for IBM i and Test data form MS SQL)  but now I would like to add a filter in these test data scenarios.

Could you please show me or send me an example capture with the deails ? for example I can add the following stataments in the filter parameters, but I register these ones the RDO testing show me the message "SQL syntax error".

1 IBM i - SELECT * FROM PRODUCCION.SALES WHERE SALES_PERSON = 'LEE'

2 SQL Server - SELECT * FROM [DEMO1].[dbo].[VENTAS] WHERE COMPLEMENTO = 'AMERICAS'

Best regards,

Miguel

CDS Américas

Hi,

You need not type in the full SQL syntax in the 'Filter'.   You may start with typing out "SALES_ " , system will list out all the available fields of the selected Table, and you can then continue your selection criteria with some SQL commands.  

Eg.

This is how it looks like after the filter is saved:

Rgrds