I would like to know if is possible to create a static Dropdown filter that doesn't depends of Field Filters, I searched in the metabase documentation, but couldn't find anything that helps me.
I have the following query, and i would like to create a static dropdown with the values of exame_group_time.
Query
`SELECT * FROM
(
SELECT
enrollment_tests.schedule_date,
enrollment_tests.start_at,
enrollment_tests.finished_at,
enrollment_tests.photo_start_collected_at,
enrollment_tests.photo_end_collected_at,
enrollment_tests.biometric_finger_start_collected_at,
enrollment_tests.biometric_finger_end_collected_at,
subtenants.cnpj AS subtenant_cnpj,
subtenants.name as subtenant_name,
computers.uid as computer_uid,
computers.descricao AS computer_name,
subtenants.director_education_cpf,
users.cpf as user_cpf,
UPPER(users.name) as user_name,
CASE
WHEN enrollment_tests.state = 1 THEN 'PENDENTE'
WHEN enrollment_tests.state = 2 THEN 'REPROVADO'
WHEN enrollment_tests.state = 3 THEN 'APROVADO'
WHEN enrollment_tests.state = 4 THEN 'FALTANTE'
WHEN enrollment_tests.state = 5 THEN 'PROBLEMAS TECNICOS'
END AS test_state,
CASE
WHEN ROUND((EXTRACT(EPOCH from (enrollment_tests.finished_at - enrollment_tests.start_at))/60)) BETWEEN 0 and 5 then '0-5'
WHEN ROUND((EXTRACT(EPOCH from (enrollment_tests.finished_at - enrollment_tests.start_at))/60)) BETWEEN 6 and 10 then '6-10'
WHEN ROUND((EXTRACT(EPOCH from (enrollment_tests.finished_at - enrollment_tests.start_at))/60)) BETWEEN 11 and 15 then '11-15'
WHEN ROUND((EXTRACT(EPOCH from (enrollment_tests.finished_at - enrollment_tests.start_at))/60)) BETWEEN 16 and 20 then '16-20'
WHEN ROUND((EXTRACT(EPOCH from (enrollment_tests.finished_at - enrollment_tests.start_at))/60)) >= 21 then '> 20'
END as exam_group_time,
COALESCE(CAST(enrollment_tests.score as varchar), '-') as score
FROM enrollment_tests
LEFT JOIN enrollments on enrollments.id = enrollment_tests.enrollment_id
LEFT JOIN computers on computers.id = enrollment_tests.computer_id
LEFT JOIN users on users.id = enrollments.user_id
LEFT JOIN subtenant_courses ON subtenant_courses.id = enrollments.course_id
LEFT JOIN subtenants ON subtenants.id = subtenant_courses.subtenant_id
WHERE
enrollment_tests.type = 2
[[ AND {{ schedule_date }} ]]
[[ AND {{ start_at }} ]]
[[ AND {{ finished_at }} ]]
[[ AND {{ user_name }} ]]
[[ AND {{ subtenant_name }} ]]
[[ AND {{ computer_name }} ]]
) AS data
WHERE 1=1
[[ AND exam_group_time in ({{exam_group_time}}) ]]
`
Diagnostic information
{
"browser-info": {
"language": "pt-BR",
"platform": "Linux x86_64",
"userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.12+7",
"java.vendor": "Eclipse Foundation",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.12",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.12+7",
"os.name": "Linux",
"os.version": "5.4.120+",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"postgres"
],
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "1.4.197 (2018-03-18)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "1.4.197 (2018-03-18)"
}
},
"run-mode": "prod",
"version": {
"date": "2021-09-09",
"tag": "v0.40.4",
"branch": "release-x.40.x",
"hash": "16d2e53"
},
"settings": {
"report-timezone": null
}
}
}