This question about Using an extension: Asked
GRID with dbcache connector: How to exclude a topic?
For performance reasons, I would like to use the
connector rather than the
However, I have problems excluding unwanted topics containing the same form, e.g., a *Template topic like NewUserTemplate
This code works:
query="form.name ~ '*UserForm' AND NOT name ~ '*Template'"
But it will display an empty table when setting the connector to
. Supposedly because dbcache has problems with the
Instead, the "! =" operator (without the whitespace in between) can be used, which works for form fields (e.g. Status "! =" 'retired'), but doesn't seem to work with the topic name. First of all, there doesn't seem to be anything like "! ~". But also specifying the full template name does not prevent it from being listed:
query="form.name ~ '*UserForm' AND name != 'NewUserTemplate'"
Any ideas? Anyone?
- 25 May 2013
As a first workaround, which of course won't work for any use case, I am now filtering out any topic with and empty LastName
field, which should usually only match the NewUserTemplate
query="form.name ~ '*UserForm' AND LastName != ''"
A real solution, however, would still be welcome...
- 26 May 2013
The query language has to match the one of the backend you choose. This is different for SEARCH, DBQUERY and SOLRSEARCH.
using the dbcache connector.
- 27 May 2013
Thanks, that worked out, using "topic =! 'NewUserTemplate'"
However, is there any way to get the unsharp '*Template' filter working with the NOT operator? This would be useful, when several similar named topics are to be excluded...
- 02 Sep 2013