Re: [SR-Users] MongoDB findone(). Is projection supported?

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 &lt;miconda(a)gmail.com&gt; Sent: Wednesday, November 6, 2019 1:29 PM To: Kamailio (SER) - Users Mailing List &lt;sr-users(a)lists.kamailio.org&gt;rg>; Lars Olsson &lt;lars.olsson(a)optimobile.se&gt; 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.org<mailto:sr-users@lists.kamailio.org> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users -- Daniel-Constantin Mierla -- www.asipto.com<http://www.asipto.com> www.twitter.com/miconda<http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda<http://www.linkedin.com/in/miconda> Kamailio World Conference - April 27-29, 2020, in Berlin -- www.kamailioworld.com<http://www.kamailioworld.com>