Using Debian Stretch default:
libmongoc-1.0-0/oldstable,now 1.4.2-1+b1 amd64 [installed,automatic]
Kamailio 5.1.9
Best Regards Lars ________________________________ From: Daniel-Constantin Mierla miconda@gmail.com Sent: Wednesday, November 6, 2019 1:29 PM To: Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org; Lars Olsson lars.olsson@optimobile.se Subject: Re: [SR-Users] MongoDB findone(). Is projection supported?
Hello,
what is the version of mongo c library?
Cheers, Daniel
On 06.11.19 12:53, Lars Olsson wrote: Hi,
I am using NDB_MONGODB to ask some questions to a database. My database structure is pretty heavy, so I like to return as little data as required to Kamailio.
I have tried the following MongoDB syntax for projection to include only given (my_field) column in the response.
mongodb_find_one("srv_name", "database", "collection", "{ "user_id" : "$var(user_id)" }, { "my_field" : 1}", "mgr1")
I always get full DB entry back. Is this supported? The same string works OK in the vanilla mongo client.
How can I limit the result?
Thanks Lars
_______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-- Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda Kamailio World Conference - April 27-29, 2020, in Berlin -- www.kamailioworld.comhttp://www.kamailioworld.com