Issue with getting query and parameters from GenericFilter

seit.art.develop · September 13, 2025, 1:23pm

I found a possible bug in the provided bean QueryConditionProcessor:

The query is generated incorrectly when there are two data stores and a table from one store has a reference to a table in another store.

Generated query:

select e from Student e where e.room = :roommNYDXfvb

Parameters:

{roommNYDXfvb=019941e6-f9ee-7787-b543-aaee4cde11dc}

The parameter "roommNYDXfvb" is assigned the ID value instead of the Room entity.

It should be:

select e from Student e where e.room.id = :roommNYDXfvb

I have provided a test project that demonstrates this issue.

Reference information about QueryConditionProcessor on the forum:

github.com/jmix-framework/jmix

Create public API for converting Condition to JPQL query

opened 12:22PM - 07 Apr 25 UTC

knstvk

size: S in: core origin: user

For example: ``` package com.company.onboarding; import io.jmix.core.querycondi…tion.Condition; import io.jmix.data.impl.jpql.generator.ConditionGenerationContext; import io.jmix.data.impl.jpql.generator.ConditionJpqlGenerator; import io.jmix.data.impl.jpql.generator.ParameterJpqlGenerator; import org.springframework.stereotype.Component; import java.util.Collections; import java.util.HashMap; import java.util.Map; import java.util.Set; @SuppressWarnings("JmixInternalElementUsage") @Component public class QueryConditionProcessor { public record QueryWithParameters(String query, Map<String, Object> parameters) {} private final ConditionJpqlGenerator conditionJpqlGenerator; private final ParameterJpqlGenerator parameterJpqlGenerator; public QueryConditionProcessor(ConditionJpqlGenerator conditionJpqlGenerator, ParameterJpqlGenerator parameterJpqlGenerator) { this.conditionJpqlGenerator = conditionJpqlGenerator; this.parameterJpqlGenerator = parameterJpqlGenerator; } public QueryWithParameters process(String query, Condition condition, String entityName) { Condition actualizedCondition = condition.actualize(Set.of(), true); if (actualizedCondition != null) { String processedQuery = conditionJpqlGenerator.processQuery(query, new ConditionGenerationContext(actualizedCondition)); Map<String, Object> parameters = new HashMap<>(); parameterJpqlGenerator.processParameters(parameters, parameters, actualizedCondition, entityName); return new QueryWithParameters(processedQuery, parameters); } else { return new QueryWithParameters(query, Collections.emptyMap()); } } } ``` See the [forum discussion](https://forum.jmix.io/t/capture-parameters-from-genericfilter-and-grid-filter-to-use-and-execute-another-jpql-statement/6489).

Could you please advise on possible workarounds for this bug?

Jmix version: 2.6.1
IntelliJ IDEA 2025.2.1 (Ultimate Edition)

issueQueryConditionProcessor (2).zip (109.3 KB)