Event Report Advance Raw SQL Error

Support - Assistance technique
1

Dear Developers,

I hope this message finds you well , I wanted to see the sql query in my dhis2 2.40.1 has given error conflict when I went to check dhis2 demo there is also given error.

Error Snapshot attached below.

image
image1913×987 22.7 KB

Regards
Mohammad Ayub Yousafzai
Kabul , Afghanistan

2

Hi @mohammadayub864

Could you share the SQL Query that you ran in the play instance?

Thanks!

3

Dear @Gassim,

Please check in snapshot image 1

image
image1913×987 50.1 KB

snapshot image 2

image
image1920×999 25.6 KB

Regards
Mohammad Ayub Yousafzai
Kabul , Afghanistan

4

Yes, I see what you mean now, thanks!

Thank you for pointing this out. It appears that this used to be supported in the Event Reports app and is currently not supported in the Line Listing app, and since the app that’s receiving updates and improvements is the Line Listing app, would you like to create a feature request to include the “Raw data SQL” download feature? If you do create a feature request, please share the link to the issue so other community members can watch for updates , comment, and like.

You’re welcome to include the screenshot below:

image
image1920×786 155 KB

For the time being, you might want to use the SQL View app? You could make use of a software such as pgadmin to explore the tables and values, create a query, and then run it in the SQL View app. Please let me know if this would be helpful?

Thanks!