const qb = dbConnection .getRepository(AssignedWorkload) .createQueryBuilder(“aw”) .leftJoinAndSelect(“aw.workload”, “workload”) .leftJoinAndMapMany( “aw.assignments”, “aw.assignedInteractions”, “workloadInteraction” ) .leftJoinAndSelect(“workloadInteraction.interaction”, “interaction”) .leftJoinAndSelect(“workloadInteraction.evaluation”, “evaluation”) .leftJoinAndSelect(“workload.interactionFilter”, “interactionFilter”) .leftJoinAndMapOne( “interaction.metadata”, `interaction.${IntegrationSystem.CHAT.toLowerCase()}Metadata`, “metadata”, `metadata.id = interaction.${IntegrationSystem.CHAT.toLowerCase()}MetadataId` ); I have this query that I created. Instead of hardcoding the left join column as such interaction.${IntegrationSystem.CHAT.toLowerCase()}Metadata. My “workload” table has a relationship with interaction_filter table where can […]

I wrote a subsriber that listen for review changes and updates the average rating in the target column.

I have a query with some filters applied and then I want to use the same query but with one column condition removed to group and count categories on that column to use it as facets and let user know how many results belongs to that category. This is my query for a single facet:

In my Entity I have Column

I have columns id (string), parentId (string or null) and order (number). It’s tree like structure where rows with the same parentId are children of the same node. order is used to sort children for each parent (so they might be the same for childs of different parents).

I have CourseEntity like this: