6 Nov
2019
6 Nov
'19
8:33 p.m.
The code has a define/macro compile time option for returning one result
-- see:
-
https://github.com/kamailio/kamailio/blob/master/src/modules/ndb_mongodb/mo…
I see that the define is on version 1.5.0, maybe that needs to be changed.
The commit introducing it is:
-
https://github.com/kamailio/kamailio/commit/c70d831aee5a95613de69568d8f1863…
I am not able to verify the code/docs of the library at this moment to
see what exactly should be used for that version to retrieve one record.
Can you test with newer library version or check docs/code if there are
known limitations of your specific version?
Cheers,
Daniel
On 06.11.19 13:48, Lars Olsson wrote:
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(a)gmail.com>
*Sent:* Wednesday, November 6, 2019 1:29 PM
*To:* Kamailio (SER) - Users Mailing List
<sr-users(a)lists.kamailio.org>rg>; Lars Olsson <lars.olsson(a)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:
--
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio World Conference - April 27-29, 2020, in Berlin -- www.kamailioworld.com
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(a)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>