Anton Kuzmin

I've got a similar need -- need to be able to use tsqueries https://www.postgresql.org/docs/12/datatype-textsearch.html

@johannesschobel I am planning to use it with GraphQL.

Also keen to have an elegant solution to this issue. Have to use a workaround for now.

Rubber 🦆 !!! Seems to be performant after changing the primary key from id to the composite one in `ListingApplicationChannelStat` view entity: ``` @PrimaryColumn() listingApplicationChannelId: string @PrimaryColumn() memberId: string ```

It's still an issue though as it stops using an index when there is some number of union-ed selections. I think it will be faster to run multiple queries instead...

I'd like to know too. @danielkv have you found a good workaround? I am thinking to create a database view, connect it to a typeorm model and then filter.

@danielkv Thanks! There is a lot of code! :) Which commit from https://github.com/danielkv/pronto-entregue-nest/compare/nestjs-query?expand=1 is it? I managed to implement it using typeorm @ViewEntity, which I linked to my other typeorm...

@doug-martin For example, I am querying `project` from my GraphQL server, and project has tasks. Projects reside in the local database. Tasks, however, exist in another system and can be...

@smolinari In typeorm it is required to use `manager` instance provided by transaction call. It's not possible to pass this instance to the nestjs-query's QueryService. For now, I not using...

@doug-martin No, I haven't tried since my workaround works with typeorm repositories. I would like to find a workaround to get database transactions work with the nestjs-query query service instead...