Though I add moderators and staff group to the data explorer query - specific query only
It stll throws error for those groups
Please help suggest
AI-generated summary
The discussion revolves around the Data Explorer feature being available only for admins. Ravindra-Trdx attempts to grant access to moderators and staff groups, but encounters errors. Moin suggests accessing queries through the group page ({YOURSITE}/g/{GROUPNAME}/reports), but Ravindra-Trdx notes that this only allows running queries without modifying parameters. Lilly offers a solution: creating parameters in the SQL query, enabling users to input values on the group report page. Lilly provides examples of how to achieve this, recommending a look at example queries in the #data-reporting category.
When you give access to a query to a group, members of the group can see it at the group page.
{YOURSITE}/g/{GROUPNAME}/reports So for staff, for example, /g/staff/reports.
This only allows to run the query - in case they need to add entries like change date range or add a Topic number it does’t allow
Can that be acheived
it will allow if you create those entries as params in the SQL, then they can input them in the report on that group report page.
data explorer SQL:
report:
Maybe have a look at some of the example queries in #data-reporting category.