Re: [SR-Users] ndb_mongodb -Sending Query to Mongo

2016-09-22 Thread Jonathan Hunter 
Hello,
Ok cool thanks Daniel will do that.
Cheers
Jon

To: sr-users@lists.sip-router.org
From: mico...@gmail.com
Date: Thu, 22 Sep 2016 07:28:19 +0200
Subject: Re: [SR-Users] ndb_mongodb -Sending Query to Mongo


  

  
  
Hello,

in case of ndb_mongodb, the result is the json returned by the
  server. Maybe you can run with debug=3 and see if you can get more
  info about what happens there.

To access part of result, you need to use a json module over
  $mongodb(mgr1=>value).

Cheers,

  Daniel





On 21/09/16 14:36, Jonathan Hunter
  wrote:



  
  
Hi Guys,



I am using the ndb_mongodb module, and Im just trying to
  return values from the dispatcher table, in particular the
  setid of a particular entry depending on its attrs value.



If I query using mongodb shell command it works fine, here
  I enter test.com and it returns only the setid value, or 2;



db.dispatcher.find( { attrs: "test.com" }, { setid: 1, _id:
  0 } )
{ "setid" : 2 }






However I have been having issues getting this to work
  using mongodb_find_one, as I would of thought the following
  route return the same;



if(mongodb_find_one("ml-mongodb", "kamailiosbc",
  "dispatcher", "{ \"attrs\" : \"test.com\" },{ \"setid\":
  \"1\", \"_id\": \"0\" }", "mgr1"))



However it returns all the entries relating to that attrs
  columm from dispatcher table, instead of just setid.



Is it possible to do this? I  am stuggling to find the json
  format to acheive the same thing.



Also in terms of the mgr1 response, I see its contained
  within the  $mongodb(key), can I drill down to get
specific fields from it or would I need to use
transformations or jansson to do this?



Many thanks



Jon
  
  

  
  

  ___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users




-- 
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Berlin, Oct 24-26, 2016 - http://www.asipto.com
  


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users   
  ___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] ndb_mongodb -Sending Query to Mongo

2016-09-21 Thread Daniel-Constantin Mierla 
Hello,

in case of ndb_mongodb, the result is the json returned by the server.
Maybe you can run with debug=3 and see if you can get more info about
what happens there.

To access part of result, you need to use a json module over
$mongodb(mgr1=>value).

Cheers,
Daniel


On 21/09/16 14:36, Jonathan Hunter wrote:
> Hi Guys,
>
> I am using the ndb_mongodb module, and Im just trying to return values
> from the dispatcher table, in particular the setid of a particular
> entry depending on its attrs value.
>
> If I query using mongodb shell command it works fine, here I enter
> test.com and it returns only the setid value, or 2;
>
> db.dispatcher.find( { attrs: "test.com" }, { setid: 1, _id: 0 } )
> { "setid" : 2 }
>
>
> However I have been having issues getting this to work using
> mongodb_find_one, as I would of thought the following route return the
> same;
>
> if(mongodb_find_one("ml-mongodb", "kamailiosbc", "dispatcher", "{
> \"attrs\" : \"test.com\" },{ \"setid\": \"1\", \"_id\": \"0\" }", "mgr1"))
>
> However it returns all the entries relating to that attrs columm from
> dispatcher table, instead of just setid.
>
> Is it possible to do this? I  am stuggling to find the json format to
> acheive the same thing.
>
> Also in terms of the mgr1 response, I see its contained within
> the  $mongodb(key), can I drill down to get specific fields from it or
> would I need to use transformations or jansson to do this?
>
> Many thanks
>
> Jon
>
>
> ___
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users@lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Berlin, Oct 24-26, 2016 - http://www.asipto.com

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users