Hello, to have full flexibility here I am thinking of adding a new module parameter to set the order-by string when the retrieve_order=1, as it may be different for various db connectors. The default will be 'priority', which is what is done right now.
That will practically cover also the case of retrieve_order=0, where the order by is done on received_time, but for backwards compatibility I think it should stay there. Cheers, Daniel On 01/06/16 12:20, Aleš Šturm wrote: > > Hello, > > > > yes, when retrieve_order=1, then order has to be combination of > columns »priority« and »received_time«, because there can be multiple > records with the same priority, but with different received_time. And > we would like to publish the newest status. > > > > > > My example: > > > > mysql> select id,username,received_time,priority from presentity where > username=3915 and event='presence' order by priority desc, > received_time desc; > > | id | username | received_time | priority | > > +----+----------+---------------+----------+ > > | 34 | 3915 | 1464775887 | 60 | > > | 33 | 3915 | 1464775876 | 60 | > > | 32 | 3915 | 1464775869 | 40 | > > | 30 | 3915 | 1464775844 | 40 | > > | 26 | 3915 | 1464775811 | 40 | > > | 35 | 3915 | 1464775894 | 20 | > > +----+----------+---------------+----------+ > > > > All the best, > > Ales > > > > > > *From:*Daniel-Constantin Mierla [mailto:mico...@gmail.com] > *Sent:* Wednesday, June 01, 2016 11:47 AM > *To:* Aleš Šturm; 'Kamailio (SER) - Users Mailing List' > *Subject:* Re: [SR-Users] Wrong Publish status > > > > > > > > On 01/06/16 10:42, Aleš Šturm wrote: > > Hello, > > > > yes, if the priority is the same, records should be ordered by > received_time. Acting in this way, when “presentity” table has > more than one record of the same user with equal priority, to > watcher would be send Notify message with last received status. > > > > SQL like: > > select * from presentity where username=X and priority=Y order by > received_time desc; > > > > > > Well, the priority is not known in advance, query is like: > > select ... from presentity by matching the user and event, ordering > either by receive_time when retrieve_order=0 or by priority if > retrieve_order=1. > > Here it looks like order by has to be a combination of the two columns. > > Cheers, > Daniel > > > -- > Daniel-Constantin Mierla > http://www.asipto.com - http://www.kamailio.org > http://twitter.com/#!/miconda <http://twitter.com/#%21/miconda> - > http://www.linkedin.com/in/miconda -- Daniel-Constantin Mierla http://www.asipto.com - http://www.kamailio.org http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
