Query two Entities : Elgg.org

Query two Entities

By adrew22a 1615 days ago

I would like to query two entities at the same time. Lets say I want to get all the entities "images" where (User Object) user->status = 'active'.

I use to do this like the following:

https://elgg.org/discussion/view/2705400/list-photos-entities-based-on-users-metadata

but this way has been deprecated.

Nikolai Shcherbin 1615 days ago

Try to use elgg_list_entities with these 'wheres' clauses:

'wheres' => function(QueryBuilder $qb, $alias) {
   $qb->joinMetadataTable($alias, 'guid', 'status', 'left', 'ma');

   return $qb->merge([
     $qb->compare('ma.name', '=', 'status', ELGG_VALUE_STRING),
     $qb->compare('ma.value', '=', 'active', ELGG_VALUE_STRING),
   ]);
},

- adrew22a@drew22a
adrew22a 1615 days ago
- 0 likes
what is $qb and $alias?
- Nikolai Shcherbin@rivervanrain
Nikolai Shcherbin 1615 days ago
- 0 likes
Learn it:
https://www.doctrine-project.org/projects/doctrine-dbal/en/2.10/reference/query-builder.html#sql-query-builder
https://github.com/Elgg/Elgg/blob/3.3/engine/classes/Elgg/Database/QueryBuilder.php

Query two Entities

Elgg Technical Support

Navigation

Contact

Legal