Reports Using Text Based Filters (url aware) In Rest APIs
  • Updated on 28 Jan 2015
  • 1 minute to read
  • Print
  • Dark
    Light

Reports Using Text Based Filters (url aware) In Rest APIs

  • Print
  • Dark
    Light

This tutorial demonstrates how to use text based Filters as URL parameter for Service call in Reports .
Example:
We begin with creating a simple Report . In the Designer Folder we click Create Report > Create Report from the Folder Actions Panel.

2016-12-19_142611.png

Then, we Name Report and click Create to proceed to the Report Designer.

2016-12-19_142943.png

In the Report Designer we add Account Data Source…

2016-12-19_143329.png

And desirable columns to the Report . In this example we add Account Id and Email Address.

2016-12-19_143655.png

Next, we add Email Address Contains Filter from Data Filters > Field Filters > Email Address category in the Toolbox .

2016-12-19_144044.png

With this Filter selected, we navigate to its Settings . Then, we select Runtime Editable option from Runtime Behavior dropdown. This completes our Report . We save and close Report Designer .

2016-12-19_144228.png

Back in the Designer Folder we locate a Thumbnail for our Report . Then, from Action menu on the Thumbnail we select Run [Advanced] > Integration > View Integration Details.

2016-12-19_144429.png

On the Integration Details Page we Setup Report to Run As UI/Form , we set theEmbed Type to Direct url, and the display type to HTML . Then, we click Generate UI Code for testing in the further steps in this tutorial.

2016-12-27_083013.png

Paste generated URL into the browser and click Return on the keyboard…
Service call returns us an Html file with Report data. We should see all Portal Accounts because we did not provide a value for the Filter parameter in the URL.

2016-12-27_083334.png

We use our URL again but this time we provide Filter parameter with “admin ” value…
Service call returns an Html file with filtered data…

2016-12-27_083559.png

Was this article helpful?