running order by and group by in objection js

Asked May 20 '19 at 08:09

Active May 20 '19 at 08:09

Viewed 2,623 times

I want to add group by and order by in the same query, I have checked so many example where we can do this in mysql but how that will be done in objection. Currently I am doing this with foreach loop which is not good for large result.

logs = await logs.select('id','story_id').orderBy('id','desc'); 
                let ids:any[] = [];

                _.each(logs, (log:any)=>{
                    if(empty(ids[log.thred_id]))
                        ids[log.thred_id] = log.id;
                });

                log = await Logs.query().whereIn('id', _.values(ids)).orderBy('id','desc');

I want to show recent update of story only

asked May 20 '19 at 08:09

HKumar

1,535
3
13
28

Have you checked https://vincit.github.io/objection.js/api/query-builder/find-methods.html#groupby ? – Rashomon May 20 '19 at 08:19
1

@Rashomon yes, I checked this but it gives first log by story_id not the last – HKumar May 20 '19 at 08:32
1

Do you have the equivalent mysql query? – Rashomon May 20 '19 at 11:42
Do you have your schema available? – technogeek1995 Jul 26 '19 at 20:07
1

No, I don't have the schema yet, thanks but solution is not needed now, i have done with this task :-) – HKumar Jul 30 '19 at 08:04

running order by and group by in objection js

0 Answers0