Mult-filter using "="

from the screen shot you can see it is doing an "=" instead of an "IN" when sending in multi-select

[7888d65c-623b-4e5e-a815-534d66fdbcbd] 2024-01-03T09:22:27+00:00 DEBUG metabase.server.middleware.log POST /api/card/284/query 202 [ASYNC: completed] 1.2 s (15 DB calls) App DB connections: 2/15 Jetty threads: 2/50 (4 idle, 0 queued) (158 total active threads) Queries in flight: 0 (0 queued); mysql DB 4 connections: 0/1 (0 threads blocked)
[7888d65c-623b-4e5e-a815-534d66fdbcbd] 2024-01-03T09:23:01+00:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '237
group by e.equipmentListId
order by e.tagno' at line 95

:database_id 4,
:started_at #t "2024-01-03T09:23:00.718478Z[Etc/UTC]",
:via
[{:status :failed,
:class org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException,
:error
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '237\r",

....

:state "42000",
:error_type :invalid-query,
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :native,
:middleware {:js-int-to-string? true, :ignore-cached-results? false, :process-viz-settings? false},
:native
{:query
"select\r\ne.tagno as 'Tag' ,\r\ne.equipmentListDescription as 'Tag Description',\r\nCOALESCE(eidapackage.packageName,'') as 'Project Name',\r\nCOALESCE(parent.tagNo,'') as 'Parent Tag',\r\nCOALESCE(e.discipline,'') as 'Main Discipline',\r\nCOALESCE(system.systemNo,'') as 'UPN',\r\nCOALESCE(p.personName,'') as 'GC CM',\r\nCOALESCE(clientOwnerPersonnel.personName,'') as 'Client Owner',\r\nCOALESCE(e.subDiscipline,'') as 'Sub Discipline',\r\nCOALESCE(parentSystem.systemNo,'') as 'Parent UPN',\r\nc.componenttypeName as 'Component Type',\r\nCOALESCE(m.milestoneGroupName,'') as 'Milestone',\r\nactivity.activityStatus1 as 'Pre DV',\r\nactivity.activityStatus2 as 'DV'\r\nfrom \r\n(\r\n\r\nselect e.equipmentListId,e.componentTypeId\r\nfrom \r\n(\r\nselect cal.componenttypeId\r\nfrom componenttypeactivitylink cal\r\nwhere cal.projectId=15\r\nand cal.activityId IN (323,318)\r\n)as c\r\ninner join equipmentList e on (e.projectId=15 and e.componenttypeId=c.componenttypeId)\r\ninner join\r\n(\r\nselect distinct(wel.equipmentListId)\r\nfrom\r\nworkspaceEquipmentListLink wel\r\ninner join workspaceactivitylink wal on (wal.projectId=wel.projectId and wal.workspaceId=wel.workspaceId and wal.activityId IN (323,318))\r\nwhere\r\nwel.projectId=15\r\nand wel.deleted='N'\r\n)w on (w.equipmentListId=e.equipmentListId)\r\nwhere \r\n(e.commissioningViewable='Y' OR e.mechanicalViewable='Y' OR e.electricalViewable='Y' OR e.csaViewable='Y')\r\n) as availableTag\r\ninner join trackeractivitydetails tad on (tad.projectId=15 and tad.equipmentlistId=availableTag.equipmentlistId and tad.componenttypeId=availableTag.componenttypeId and tad.activityId IN (323,318))\r\ninner join equipmentList e on (e.equipmentListId=availableTag.equipmentListId)\r\ninner join equipmentList parent on (parent.equipmentListId=e.subEquipmentListId)\r\nleft join system system on (system.systemId=e.systemId)\r\nLEFT JOIN personnel p ON (p.personnelId = e.personnelId)\r\nLEFT JOIN personnel clientOwnerPersonnel ON (clientOwnerPersonnel.personnelId = e.clientOwnerPersonnelId)\r\nleft join system parentSystem on (parentSystem.systemId=e.subSystemId)\r\ninner join componenttype c on (c.componenttypeId=e.componenttypeId)\r\nleft join milestoneGroup m on (m.milestonegroupId=e.milestonegroupId)\r\nleft join eidapackage eidapackage on (eidapackage.packageId=e.packageId)\r\ninner join\r\n(\r\n\r\nselect\r\ntad.equipmentListId,\r\nmax(If(tad.activityId=323, tad.status,'')) as activityStatus1,\r\nmax(IF(tad.activityId=318,tad.status,'')) as activityStatus2\r\nfrom\r\n(\r\nselect\r\ntad.activityId,\r\ntad.equipmentListId,\r\ncase \r\nwhen tad.completedAt is not null then 'Completed'\r\nwhen tad.completedAt is null and pdfAvailable='Y' and hexValue='#D3D3D3' then 'In Progress'\r\nwhen tad.completedAt is null and pdfAvailable='Y' and hexValue="#FF3300" then 'Inprogress and Late'\r\nwhen tad.completedAt is null and pdfAvailable='N' and hexValue="#FF3300" then 'Late'\r\nwhen tad.completedAt is null and pdfAvailable='N' then 'Not Started'\r\nelse '' end as status\r\n\r\n\r\nfrom\r\n(\r\n\r\nselect e.equipmentListId,e.componentTypeId\r\nfrom \r\n(\r\nselect cal.componenttypeId\r\nfrom componenttypeactivitylink cal\r\nwhere cal.projectId=15\r\nand cal.activityId=323\r\n)as c\r\ninner join equipmentList e on (e.projectId=15 and e.componenttypeId=c.componenttypeId)\r\ninner join\r\n(\r\nselect distinct(wel.equipmentListId)\r\nfrom\r\nworkspaceEquipmentListLink wel\r\ninner join workspaceactivitylink wal on (wal.projectId=wel.projectId and wal.workspaceId=wel.workspaceId and wal.activityId=323)\r\nwhere\r\nwel.projectId=15\r\nand wel.deleted='N'\r\n)w on (w.equipmentListId=e.equipmentListId)\r\nwhere \r\n(e.commissioningViewable='Y' OR e.mechanicalViewable='Y' OR e.electricalViewable='Y' OR e.csaViewable='Y')\r\n) as availableTag\r\ninner join trackeractivitydetails tad on (tad.projectId=15 and tad.equipmentlistId=availableTag.equipmentlistId and tad.componenttypeId=availableTag.componenttypeId and tad.activityId=323 and COALESCE(activityDisabledStatus,'N')= 'N')\r\nunion\r\nselect\r\ntad.activityId,\r\ntad.equipmentListId,\r\ncase \r\nwhen tad.completedAt is not null then 'Completed'\r\nwhen tad.completedAt is null and pdfAvailable='Y' and hexValue='#D3D3D3' then 'In Progress'\r\nwhen tad.completedAt is null and pdfAvailable='Y' and hexValue="#FF3300" then 'Inprogress and Late'\r\nwhen tad.completedAt is null and pdfAvailable='N' and hexValue="#FF3300" then 'Late'\r\nwhen tad.completedAt is null and pdfAvailable='N' then 'Not Started'\r\nelse '' end as status\r\n\r\n\r\nfrom\r\n(\r\n\r\nselect e.equipmentListId,e.componentTypeId\r\nfrom \r\n(\r\nselect cal.componenttypeId\r\nfrom componenttypeactivitylink cal\r\nwhere cal.projectId=15\r\nand cal.activityId=318\r\n)as c\r\ninner join equipmentList e on (e.projectId=15 and e.componenttypeId=c.componenttypeId)\r\ninner join\r\n(\r\nselect distinct(wel.equipmentListId)\r\nfrom\r\nworkspaceEquipmentListLink wel\r\ninner join workspaceactivitylink wal on (wal.projectId=wel.projectId and wal.workspaceId=wel.workspaceId and wal.activityId=318)\r\nwhere\r\nwel.projectId=15\r\nand wel.deleted='N'\r\n)w on (w.equipmentListId=e.equipmentListId)\r\nwhere \r\n(e.commissioningViewable='Y' OR e.mechanicalViewable='Y' OR e.electricalViewable='Y' OR e.csaViewable='Y')\r\n) as availableTag\r\ninner join trackeractivitydetails tad on (tad.projectId=15 and tad.equipmentlistId=availableTag.equipmentlistId and tad.componenttypeId=availableTag.componenttypeId and tad.activityId=318 and COALESCE(activityDisabledStatus,'N')= 'N')\r\n) as tad\r\ngroup by tad.equipmentListId\r\n) activity on (activity.equipmentListId=e.equipmentListId)\r\n[[WHERE {{system}}]]\r\n[[AND {{package}}]]\r\ngroup by e.equipmentListId\r\norder by e.tagno\r\n",
:template-tags
{"system"
{:id "eab3f123-960d-b9d1-ecfe-c02f9761d8e1",
:name "system",
:display-name "System",
:type :dimension,
:dimension [:field 1779 nil],
:widget-type :id},
"package"
{:id "45de54a1-debf-e537-715f-99abb07a8326",
:name "package",
:display-name "Package",
:type :dimension,
:dimension [:field 1433 nil],
:widget-type :id}}},
:database 4,
:parameters [{:value [210 237], :target ["dimension" ["template-tag" "package"]], :type "number"}],
:async? true,
:cache-ttl nil},
:status :failed,
:class java.sql.SQLException,
:stacktrace
["org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1695)"
"org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1557)"
"org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1520)"
"org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:256)"
"org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:356)"
"org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:500)"
"com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)"
"--> driver.sql_jdbc.execute$fn__71780.invokeStatic(execute.clj:384)"
"driver.sql_jdbc.execute$fn__71780.invoke(execute.clj:382)"
"driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:392)"
"driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:389)"
"driver.sql_jdbc.execute$execute_reducible_query$fn__71855.invoke(execute.clj:503)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:502)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:489)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:497)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:489)"
"driver.sql_jdbc$fn__105207.invokeStatic(sql_jdbc.clj:63)"
"driver.sql_jdbc$fn__105207.invoke(sql_jdbc.clj:61)"
"query_processor.context$executef.invokeStatic(context.clj:60)"
"query_processor.context$executef.invoke(context.clj:49)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:68)"
"query_processor.context.default$default_runf.invoke(default.clj:66)"
"query_processor.context$runf.invokeStatic(context.clj:46)"
"query_processor.context$runf.invoke(context.clj:40)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:15)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:12)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___69239.invoke(cache.clj:224)"
"query_processor.middleware.permissions$check_query_permissions$fn__64711.invoke(permissions.clj:126)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__68130.invoke(mbql_to_native.clj:24)"
"query_processor$fn__70758$combined_post_process__70763$combined_post_process_STAR___70764.invoke(query_processor.clj:243)"
"query_processor$fn__70758$combined_pre_process__70759$combined_pre_process_STAR___70760.invoke(query_processor.clj:240)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__69150$fn__69155.invoke(resolve_database_and_driver.clj:36)"
"driver$do_with_driver.invokeStatic(driver.clj:92)"
"driver$do_with_driver.invoke(driver.clj:88)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__69150.invoke(resolve_database_and_driver.clj:35)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__65021.invoke(fetch_source_query.clj:316)"
"query_processor.middleware.store$initialize_store$fn__65199$fn__65200.invoke(store.clj:12)"
"query_processor.store$do_with_store.invokeStatic(store.clj:47)"
"query_processor.store$do_with_store.invoke(store.clj:41)"
"query_processor.middleware.store$initialize_store$fn__65199.invoke(store.clj:11)"
"query_processor.middleware.normalize_query$normalize$fn__69439.invoke(normalize_query.clj:25)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__66377.invoke(constraints.clj:54)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__69375.invoke(process_userland_query.clj:151)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__69752.invoke(catch_exceptions.clj:171)"
"query_processor.reducible$async_qp$qp_STAR___59520$thunk__59522.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___59520$fn__59524.invoke(reducible.clj:108)"],
:card_id 284,
:context :question,
:error
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '237\r\ngroup by e.equipmentListId\r\norder by e.tagno' at line 95",
:row_count 0,
:running_time 0,
:data {:rows , :cols }}

can you post troubleshooting info and what you're doing?

I am querying metabase using /api/card/.... etc passing in params for the filter....i am not sure what troubleshotting information you require? - do you want more of the log file from metabase ? it looks like metabase is inserting an "=" instead of "IN" for multi filter. maybe the param type needs to be different for multi filter? (it is set as number)