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
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 https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
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
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/mon...
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/c70d831aee5a95613de69568d8f18637...
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@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.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
-
Daniel-Constantin Mierla -
Lars Olsson