Skip to main content
1-Visitor
November 25, 2015
Solved

Using a Mashup Parameter as the Query Filter?

  • November 25, 2015
  • 7 replies
  • 4657 views

How can I include a parameter passed into the mashup as the input to a query?

For example:

  1. MashupA has a mashup parameter named “PassedSiteId”

    2. The mashup uses the query service “QueryImplementingThingsWithData”.  (Note: SiteId is one of the properties of the instantiated Things and I want to filter on that).

So I want the query in the “QueryImplementingThingsWithData” to be:   SiteId = PassedSiteId

I only see how to place hard coded literals in the query target.

Any pointers to documentation or examples?

Thanks,

Best answer by qn_01

You can create a new service with an input "SiteIdParam". This service executes the "QueryImplementingThingsWithData" with the query which contains "SiteId = SiteIdParam".


Then, in the mashup, you can bind the mashup parameter "PassedSiteId" to the input parameter "SiteIdParam" of this new service.

7 replies

qn_011-VisitorAnswer
1-Visitor
November 25, 2015

You can create a new service with an input "SiteIdParam". This service executes the "QueryImplementingThingsWithData" with the query which contains "SiteId = SiteIdParam".


Then, in the mashup, you can bind the mashup parameter "PassedSiteId" to the input parameter "SiteIdParam" of this new service.

1-Visitor
November 27, 2015

This works.  Thanks for the input.