Fulltext search service / solr in multi tenant environment

[danceb]

I did not get the solr search to work within a multi tenant environment.

I discovered, that part of the sending solr query is: &fq=tenant:default.
With another tenant this is &fq=tenant:anothertenant accordingly.

Within the example config [1] of the SELECT statements for the search facets there is set a tenant column, which is directly defined as: 'default' AS tenant,.

So I think the issue lays within this. As default is set as column tenant within the search facet, the solr query with &fq=tenant:anothertenant does not match this, correct?

I have tried to set this as an array ["default","anothertenant"] like it is done in other columns with
array_to_json(array_append(ARRAY['default'::text], 'anothertenant'::text))::text AS tenant, but this didn't solve the issue.

So do you have any hints for that?

Thanks!

[1] https://qwc-services.github.io/master/topics/Search/#fulltext-search-with-solr-backend