DataBase - Run Query Activity is not giving the expected output

Help Activities
, ,
1

I have a below table and I have written the given query to get the success count and failure count from the table, and it will display the count of success and failure as below.
image

Query - “SELECT COUNT(CASE WHEN status = ‘Success’ THEN 1 END) AS Success_Count,COUNT(CASE WHEN status = ‘failure’ THEN 1 END) AS Failure_Count FROM enroll”

Query result in SQL - ORACLE
image

I got the expected result in Oracle Sql Developer. Then I used the same query in UiPath but it did not give the expected output. It gives all counts of the particular column instead of success and failure.

UiPath Output:
SUCCESSCOUNT,FAILURECOUNT
3,0

Could any of you assist me with why it is showing like this, please?

2

Issue resolved. (If you make any changes manually in the Oracle SQL, Please Ensure to commit changes.)

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.