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
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:anothertenantaccordingly.Within the example config [1] of the
SELECTstatements for the search facets there is set atenantcolumn, which is directly defined as:'default' AS tenant,.So I think the issue lays within this. As
defaultis set as columntenantwithin the search facet, the solr query with&fq=tenant:anothertenantdoes not match this, correct?I have tried to set this as an array
["default","anothertenant"]like it is done in other columns witharray_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