0

I have a problem, when trying to filter a data grid, the default option does not allow to filter for multiple value. I tried to implement it with insert reference selector but get an error from association (see below). Does anynone has an example how to implement a multiple value filter for a data grid or how to solve this?   com.mendix.core.CoreRuntimeException: Exception occurred in action '{"xpath":"//Module_SHS.SHS_CDD[Module_SHS.SHS_CDD_SHS_XX/Module_SHS.SHS_XX/Filter.Filter_Entity_SHS_XX/Filter.Filter_Entity= '36873221949096547']","amount":20,"offset":0,"returnsCount":true,"sort":[],"type":"RetrieveXPathSchemaRawAction"}', all database changes executed by this action were rolled back     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.processErrorState(CoreActionHandlerImpl.scala:151) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):      InternalLimitedXPathTextGetRequest (depth = -1, amount = 20): //Module_SHS.SHS_CDD[Module_SHS.SHS_CDD_SHS_XX/Module_SHS.SHS_XX/Filter.Filter_Entity_SHS_XX/Filter.Filter_Entity= '36873221949096547']     at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:63) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: 'Filter.Filter_Entity_SHS_XX' is not a valid entity type., exception occurred on mapping the following query: SELECT x1Module_SHS.SHS_CDD.ID FROM Module_SHS.SHS_CDD AS x1Module_SHS.SHS_CDD INNER JOIN x1Module_SHS.SHS_CDD/Module_SHS.SHS_CDD_SHS_XX/Module_SHS.SHS_XX/Filter.Filter_Entity_SHS_XX AS j1filter$filter_entity_shs_XX WHERE x1Module_SHS.SHS_CDD/Module_SHS.SHS_CDD_SHS_XX/Module_SHS.SHS_XX/Filter.Filter_Entity_SHS_XX/Filter.Filter_Entity = '36873221949096547', exception occurred on mapping the following query: SELECT Module_SHS.SHS_CDD/* FROM Module_SHS.SHS_CDD WHERE Module_SHS.SHS_CDD.ID IN (SELECT x1Module_SHS.SHS_CDD.ID FROM Module_SHS.SHS_CDD AS x1Module_SHS.SHS_CDD INNER JOIN x1Module_SHS.SHS_CDD/Module_SHS.SHS_CDD_SHS_XX/Module_SHS.SHS_XX/Filter.Filter_Entity_SHS_XX AS j1filter$filter_entity_shs_XX WHERE x1Module_SHS.SHS_CDD/Module_SHS.SHS_CDD_SHS_XX/Module_SHS.SHS_XX/Filter.Filter_Entity_SHS_XX/Filter.Filter_Entity = '36873221949096547') LIMIT 20     at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.getMappedQueries(QueryMapper.java:276)  

asked 2020-11-05

1 answers