Page 1 of 1

Use value within an include pointer in a where query

Posted: Thu Oct 29, 2015 8:39 pm
by Jack Bua

I have a list service running on my schedule collection. In that collection is a pointer to the job_lineitem collection, and in that collection is a pointer to the jobs collection.

Image

Image

I want to use that value "_id" in the where parameter for the list service.

This is what I have so far in the mapping to the where parameter:

Image

In summary, how can I setup the where parameter to determine what results to display based on a value in an included pointer?


Use value within an include pointer in a where query

Posted: Fri Oct 30, 2015 8:14 am
by Serhii Kulibaba

Hello,

Could you show us screenshots with DB structure?


Use value within an include pointer in a where query

Posted: Fri Oct 30, 2015 8:35 am
by Jack Bua

Sure.

This is the DB that the service is using, and that is the pointer field that looks at the second DB

Image

This is the second DB, and that is the pointer field that looks at the third DB:

Image

And this is the third DB and the the value that I want to use to "filter" the service on the first DB by using it in a where parameter.
Image


Use value within an include pointer in a where query

Posted: Mon Nov 02, 2015 9:21 pm
by Serhii Kulibaba

You have to use "_id" column in requests with type=pointer. But it is impossible to use requests to pointer of pointers.


Use value within an include pointer in a where query

Posted: Mon Nov 02, 2015 9:41 pm
by Jack Bua

Ok, thank you Sergiy.