Hi there,
I have field filters set up in a report and certain users cannot see the drop downs. I can see the drop downs just fine, but when they screenshare and show me their view, I can confirm they don't see dropdowns, which makes me think it's an access issue.
The filter in question is set as a Category and filtering on this field is set as A list of all values.
As you can see, it is in the Analytics database. This user is added to the group which allows native query editing for that database.
The user does NOT have access to edit the query itself due to the collection it is in. Do I need to revise this for the user to see the dropdowns? I don't want the user to be able to save over or otherwise edit the query.
I assumed that users have access to use filters regardless of the level of access they have to databases or collections, so my assumption is probably wrong here?
Diagnostic info is below (I know we are also on an unsupported version -- we plan to upgrade in the next month or two; we need FTE to address upgrading our Heroku stack as well, first)
{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "1.8.0_312-heroku-b05",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "1.8.0_312-heroku",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "25.312-b05",
"os.name": "Linux",
"os.version": "4.4.0-1104-aws",
"user.language": "en",
"user.timezone": "Etc/UTC"
},
"metabase-info": {
"databases": [
"postgres",
"redshift"
],
"hosting-env": "heroku",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "11.19 (Ubuntu 11.19-1.pgdg20.04+1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.23"
}
},
"run-mode": "prod",
"version": {
"tag": "v0.41.4",
"date": "2021-12-10",
"branch": "release-x.41.4",
"hash": "471cfb9"
},
"settings": {
"report-timezone": "US/Eastern"
}
}
}