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

[Lars Olsson]

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 at gmail.com>
Sent: Wednesday, November 6, 2019 1:29 PM
To: Kamailio (SER) - Users Mailing List <sr-users at lists.kamailio.org>; Lars Olsson <lars.olsson at 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 at lists.kamailio.org<mailto:sr-users at 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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20191106/0d289ee5/attachment.html>