Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 302 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
[Solved] Get Automated Test results in Powershell
Klappspaten
Member Posts: 22
Hey there,
I have a scenario in which I run the Automated Tests of Microsoft Dynamics NAV from Powershell in a workflow.
For this purpose I have created a Codeunit which builds and executes a Test Suite.
The workflow executes the Test Suites on 3 databases in total.
After the automated tests are completely executed I want to return the test results back to Powershell to inform the user which tests have failed.
Is it possible to get the information from the Test Suites and process them in Powershell? As I have read the Invoke-NAVCodeunit cmdlet ignores return values.
Do you have any thoughts on this topic or an idea for a solution?
Maybe someone is interested in this, so I will add my solutions to this.
Last week I reviewed this topic and all in a sudden it came to me:
Why am I not using the CAL Test Line table for getting my test results?!
There are tweo ways I can 'talk' with the table from Powershell:
1. A new Codeunit which exports the CAL Test Line table in a text file
2. SQL Query from Powershell
Both ways have their pros and cons, but for my purpose it's enough to directly execute a SQL Query from Powershell.
I have a scenario in which I run the Automated Tests of Microsoft Dynamics NAV from Powershell in a workflow.
For this purpose I have created a Codeunit which builds and executes a Test Suite.
The workflow executes the Test Suites on 3 databases in total.
After the automated tests are completely executed I want to return the test results back to Powershell to inform the user which tests have failed.
Is it possible to get the information from the Test Suites and process them in Powershell? As I have read the Invoke-NAVCodeunit cmdlet ignores return values.
Do you have any thoughts on this topic or an idea for a solution?
Maybe someone is interested in this, so I will add my solutions to this.
Last week I reviewed this topic and all in a sudden it came to me:
Why am I not using the CAL Test Line table for getting my test results?!
There are tweo ways I can 'talk' with the table from Powershell:
1. A new Codeunit which exports the CAL Test Line table in a text file
2. SQL Query from Powershell
Both ways have their pros and cons, but for my purpose it's enough to directly execute a SQL Query from Powershell.
0