DHIS2 2.30 sql view

Support - Assistance technique
1

Hello guys,
Could someone tell me where is the sql view in DHIS2.30 because I don’t find it

Lanja

2

Hi @Lanja ,
The SQL View is now located in Maintenance Under Other follow steps below:

  1. Search Apps
  2. Select Maintenance
  3. Click Other

Let me know if you still have issues,
Cheers,
Emma

1 Like
3

Hello @Emma_Kassy,
Thanks a lot for your answer, I’ve finally found it.
Now, next problem :rouler des yeux: :rouler des yeux: :rouler des yeux:
I’ve just created a SQL View and it doesn’t work.
The system tell me “Could not execute SQL”

Capture
Capture1469×620 42.4 KB

4

@Lanja
Please share the process you followed to get to this error.

Cheers,
Emma

5

@Emma_Kassy

  • Creation of SQL view “AS_ProgramList”
  • Save the SQL View
    After that, the option “Execute SQL View” isn’t displayed.
    Finally, I get the error on the previous picture

Lanja

6

@Lanja

  1. For SQL Type select Materialized View or Query.
    I normally use Materialized View.
  2. For Cache Strategy select Respect System setting

Cheers,
Emma