Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- мне нужно переписать этот запрос на запрос с использованием EntityFieldQuery:
- $result = db_query('SELECT nid, title, field_external_id_value FROM {node}'
- .' JOIN {field_data_field_external_id} ON {field_data_field_external_id}.entity_id = {node}.nid'
- .' JOIN {field_data_field_external_rule_id} ON {field_data_field_external_rule_id}.entity_id = {node}.nid'
- .' WHERE type = :type AND status = :status AND field_external_rule_id_target_id = :rule_id',
- [
- ':type' => 'simpleads', ':status' => 1, 'rule_id' => $rule_id,
- ]
- );
- Вот этот запрос с EntityFieldQuery:
- $query = new EntityFieldQuery();
- $query->entityCondition('entity_type', 'node')
- ->entityCondition('bundle', 'simpleads')
- ->propertyCondition('status', NODE_PUBLISHED)
- ->fieldCondition('external_rule_id', 'target_id', $rule_id, '=')
- ;
- EntityFieldQuery не позволяет "из коробки" получить field_external_id_value простым способом
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement