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.
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:
In summary, how can I setup the where parameter to determine what results to display based on a value in an included pointer?
Hello,
Could you show us screenshots with DB structure?
Sure.
This is the DB that the service is using, and that is the pointer field that looks at the second DB
This is the second DB, and that is the pointer field that looks at the third DB:
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.
You have to use "_id" column in requests with type=pointer. But it is impossible to use requests to pointer of pointers.
Ok, thank you Sergiy.