Hi,
I can't explain a query.
The sql filter contains a term. However, the result does not show the results
that match this filter in the column.
The result shows all data that was found a long time ago with this filter term,
but there are no entries in the column for the displayed results.
If I change the content of one of these filtered rows in the filter column from
"empty" to the new filter term, the whole row with the above filter is no longer
displayed.

That should mean there's a record of that earlier search somewhere. But I can't find it anywhere.

This is perhaps related to the secondary tables.
Could this be a bug?

semperlin wrote:Hi,
I can't explain a query.
The sql filter contains a term. However, the result does not show the results
that match this filter in the column.
The result shows all data that was found a long time ago with this filter term,
but there are no entries in the column for the displayed results.
If I change the content of one of these filtered rows in the filter column from
"empty" to the new filter term, the whole row with the above filter is no longer
displayed.

That should mean there's a record of that earlier search somewhere. But I can't find it anywhere.

This is perhaps related to the secondary tables.
Could this be a bug?

Hi
It's hard to say not seeing the query's SQL. Do you use the SQL view or the visual view?
You are free to report this as a bug or paste more together with screen shots. Minimal example kexi file would be most helpful if you're able to produce it.

Cheers.