I am trying to input multiple order numbers in a variable, and show results from a table.
Here's the code:
Select ordnumbh, status
From order_header
Where {{Ordnumbh}}
When I put ordnumbh = 0000 (where 0000 is a number that exists in the ordnumbh table, I get a result, when i map ordnumbh to the field (configured both as a caterogry and as a number in two separate attempts), I get no results.
Ideally, I want to enter multiple order numbers and see if the query returns results corresponding to these order numbers
Diagnostic Information:
{
"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/92.0.4515.159 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "1.8.0_262-b10",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "1.8.0_262",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "25.262-b10",
"os.name": "Linux",
"os.version": "4.18.0-193.el8.x86_64",
"user.language": "en",
"user.timezone": "UTC"
},
"metabase-info": {
"databases": [
"mysql",
"postgres",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "11.10"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.8"
}
},
"run-mode": "prod",
"version": {
"tag": "v0.36.4",
"date": "2020-08-17",
"branch": "release-0.36.x",
"hash": "196c1f6"
},
"settings": {
"report-timezone": "Asia/Calcutta"
}
}
}