/TypeScript/Typeorm select join column querybuilder

Typeorm select join column querybuilder

			let query: SelectQueryBuilder<Projects> = this.projectModel
				.createQueryBuilder('projects')
				.select([
					'projects',
					'customers.id',
					'customers.email',
					'customers.phone',
					'customers.is_verified',
					'customers.created_at',
					'property_types',
					'project_executives',
					'interior_design_partners',
					'mitra_produksi_partners'
				])
				.where({ deleted_at: null })
				.leftJoin('projects.customers', 'customers')
				.leftJoin('projects.property_types', 'property_types')
				.leftJoin('projects.project_executive', 'project_executives')
				.leftJoin('projects.interior_design_partner', 'interior_design_partners')
				.leftJoin('projects.mitra_produksi_partner', 'mitra_produksi_partners')

Typeorm select join column querybuilder

this.createQueryBuilder('profile')
            .leftJoinAndSelect('profile.avatarPhoto', 'avatarPhoto')
            .leftJoinAndSelect('profile.coverPhoto', 'coverPhoto')
            .leftJoinAndSelect('profile.primaryCountry', 'country')
            .leftJoinAndSelect('profile.primaryCity', 'city')
            .leftJoinAndSelect('profile.images', 'image')
            .leftJoinAndSelect('profile.practicedSports', 'practicedSport')
            .leftJoinAndSelect(
                (subQuery) =>
                    subQuery
                        .subQuery()
                        .createQueryBuilder()
                        .select(['id'])
                        .leftJoin('user', 'user')
                        .from(SportEvent, 'event'),
                'event',
                'event.user.id = profile.id',
            )
            // .leftJoinAndSelect('profile.sportServices', 'service')
            // .leftJoinAndSelect('profile.lessons', 'lesson')
            // .leftJoinAndSelect('profile.activityRequests', 'request')
            .leftJoin('profile.userAuth', 'auth')
            .where('auth.registered = true')
            .andWhere('auth.blocked = false')
            .take(params.pageSize)
            .skip(itemsNumber)
            .getMany()

Source: stackoverflow.com

Similar codes

0 vote317 views2 answers
How to access contents of an array from another class in java
TypeScript
0 vote367 views1 answer
Angular modal dismisss
TypeScript
25 votes313 views10 answers
Github
TypeScript
1 vote305 views1 answer
Python check if attribute exists in class
TypeScript
0 vote325 views2 answers
How to check if a string contains only alphabets and space in java
TypeScript
1 vote408 views2 answers
When i console log a obj its printing object
TypeScript
0 vote328 views1 answer
DecoDe query string to object javascript
TypeScript
3 votes321 views1 answer
ERROR in node_modules/rxjs/internal/types.d.ts(81,44): error TS1005: ';' expected.
TypeScript
0 vote343 views2 answers
Npm WARN [email protected] requires a peer of tslint@^5.0.0 || ^6.0.0 but none is installed. You must install peer dependencies yourself.
TypeScript
0 vote368 views2 answers
How to set value to readonly property in typescript
TypeScript