Reputation: 46
I have a table for marking attendance of a student. The table has three columns Attended_days, Absent_days and Registered_email. I need to display a pie chart at the dash which shows the number of days a student was present vs. the number of days the student was absent. When I add a where clause to the chart reg_email = ':APP_USER'
, I get the following error:
Region → Attendance → Source → Where Clause
ORA-20999: Failed to parse SQL query!
ORA-06550: line 6, column 6: ORA-01740: missing double quote in identifier
I searched the web and tried various methods but none worked. Any suggestions or any better way to do this.
Upvotes: 0
Views: 585
Reputation: 171
You shouldn't use reg_email = ':APP_USER'
rather reg_email = :APP_USER
, if you surround :APP_USER with quotes it becomes a litteral not the APP_USER variable
Upvotes: 1