Ufdjrw

What is the smallest unit of eos?

How to prevent z-fighting in OpenSCAD?

Betweenness centrality formula

Relationship between strut and baselineskip

Is there any official lore on the Far Realm?

Can we say “you can pay when the order gets ready”?

How to stop co-workers from teasing me because I know Russian?

Pulling the rope with one hand is as heavy as with two hands?

Why does Mind Blank stop the Feeblemind spell?

Why does nature favour the Laplacian?

How exactly does Hawking radiation decrease the mass of black holes?

Map of water taps to fill bottles

As an international instructor, should I openly talk about my accent?

Dynamic SOQL query relationship with field visibility for Users

Checks user level and limit the data before saving it to mongoDB

Critique of timeline aesthetic

How can I practically buy stocks?

Implications of cigar-shaped bodies having rings?

Re-entry to Germany after vacation using blue card

How would 10 generations of living underground change the human body?

How to write a column outside the braces in a matrix?

Can SQL Server create collisions in system generated constraint names?

What is the most expensive material in the world that could be used to create Pun-Pun's lute?

What is causing the white spot to appear in some of my pictures

Select multiple attributes with a query in dql

Complex WHERE clauses using the PHP Doctrine ORMWhat's “wrong” with my DQL query?Doctrine 2.1 DQL - Many-to-many query multiple values - Item in multiple categories?Query Builder / DQL not working with INNER JOIN - Syntax IssueDoctrine 2 DQL - Select rows where a many-to-many field is empty?Doctrine2 in ZF2 - DQL gives different result than findOneBy methodJoining two tables on the basis of Two colums in dql(Doctrine)Symfony 2 many-to-many sql translate to dqlDQL query for getting geo spatial points st_within a rectangleDQL Query Doctrine places joined element OrderBy clause in another element's juncture condition's subQuery

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

My goal is to write a dql query, that returns two attributes of an entity in dql.
My query:

$queryEvents = $em->createQueryBuilder('v')
 ->select('e')
 ->from('AppBundle:Event', 'e')
 ->where('e.maxCountParticipants >= e.currentCountOfParticipants')
 ->andWhere('e.finalDateForRegistration >= :now')
 ->setParameter('now', $now)
 ->orderBy('e.finalDateForRegistration', 'DESC')
 ;

the Event class also has a date attribute 'finalDateForRegistration' that I do want to add to the "select" but I cant figure out how.

dql symfony-3.4

share|improve this question

asked Mar 9 at 9:10

Sebastian FriedersenSebastian Friedersen

83

add a comment | 

0

My goal is to write a dql query, that returns two attributes of an entity in dql.
My query:

$queryEvents = $em->createQueryBuilder('v')
 ->select('e')
 ->from('AppBundle:Event', 'e')
 ->where('e.maxCountParticipants >= e.currentCountOfParticipants')
 ->andWhere('e.finalDateForRegistration >= :now')
 ->setParameter('now', $now)
 ->orderBy('e.finalDateForRegistration', 'DESC')
 ;

the Event class also has a date attribute 'finalDateForRegistration' that I do want to add to the "select" but I cant figure out how.

dql symfony-3.4

share|improve this question

asked Mar 9 at 9:10

Sebastian FriedersenSebastian Friedersen

83

add a comment | 

My goal is to write a dql query, that returns two attributes of an entity in dql.
My query:

$queryEvents = $em->createQueryBuilder('v')
 ->select('e')
 ->from('AppBundle:Event', 'e')
 ->where('e.maxCountParticipants >= e.currentCountOfParticipants')
 ->andWhere('e.finalDateForRegistration >= :now')
 ->setParameter('now', $now)
 ->orderBy('e.finalDateForRegistration', 'DESC')
 ;

the Event class also has a date attribute 'finalDateForRegistration' that I do want to add to the "select" but I cant figure out how.

dql symfony-3.4

share|improve this question

asked Mar 9 at 9:10

Sebastian FriedersenSebastian Friedersen

83

$queryEvents = $em->createQueryBuilder('v')
 ->select('e')
 ->from('AppBundle:Event', 'e')
 ->where('e.maxCountParticipants >= e.currentCountOfParticipants')
 ->andWhere('e.finalDateForRegistration >= :now')
 ->setParameter('now', $now)
 ->orderBy('e.finalDateForRegistration', 'DESC')
 ;

share|improve this question

asked Mar 9 at 9:10

Sebastian FriedersenSebastian Friedersen

83

share|improve this question

asked Mar 9 at 9:10

Sebastian FriedersenSebastian Friedersen

83

asked Mar 9 at 9:10

Sebastian FriedersenSebastian Friedersen

83

asked Mar 9 at 9:10

Sebastian FriedersenSebastian Friedersen

83