This topic contains 1 reply, has 2 voices, and was last updated by Mike Kudelya 7 years, 3 months ago.
- Topic
Hi,
I tried to use a binded parameter as a parameter for a delete route. But i do not want to select the column id as in the select list because i get a group by it.
I need something like this:
1234567891011121314151617181920212223242526272829303132333435query:select:- pv.id- >MAX(CASE WHEN (ev.id IS NULL) THEN0ELSEev.statusEND) as availablefrom:- { table: %panel_views.entity.class%, alias: pv }join:left:-join: pv.reservationsalias: r-join: pv.eventsalias: evwhere:and:- :reservation MEMBER OF pv.reservationsbind_parameters:- reservation...properties:id: ~rid: reservation # HERE IS THE PROBLEMdelete_link:type: urlroute: xxx_reservation_api_delete_reservation_pviewparams:rid: ridid: idIt could be done like this:
123456789101112131415161718192021222324252627282930313233343536query:select:- pv.id- r.id as rid- >MAX(CASE WHEN (ev.id IS NULL) THEN0ELSEev.statusEND) as availablefrom:- { table: %panel_views.entity.class%, alias: pv }join:left:-join: pv.reservationsalias: r-join: pv.eventsalias: evwhere:and:- :reservation MEMBER OF pv.reservationsbind_parameters:- reservation...properties:id: ~rid: r.iddelete_link:type: urlroute: xxx_reservation_api_delete_reservation_pviewparams:rid: ridid: idBut this will group by pv.id and r.id and i need only by pv.id.
Thanks for any suggestions!
The forum ‘OroPlatform – How do I? Questions’ is closed to new topics and replies.