Loading javascript API report with filters

Will Volin shared this question 2 weeks ago
Awaiting Reply

Hello,

We're integrating our reports using the Javascript API, but we're having trouble loading filters prior to the first render of a report.

Our use case is a report that just needs to be filtered by column before being rendered to the user.

A simple example of this might be:

All Customers Page -> Customers Report showing all customers

Department >> Customers Page -> Shows Customers filted by department ID


What we have now:


yellowfin.reports.loadReportFilters(uuid, this.loadReport);
this.loadReport = () => {
// ... filters report correctly and sets options and runs
yellowfin.loadReport(options)
}
The issue we are having is that on the first load of this report, it does not have the filters or the report loaded.


Is there something I'm missing, or is it mandatory to load the report first, then filter against it?


Another acceptable solution would be a way to load the report without rendering it (we do not want the full dataset to show until it has been rendered with the filters)

Thanks!

Comments (4)

photo
1

Hi Will,

Thanks for reaching out.

I can point you to the resources we have available for Web Services. We have a General Report Services Wiki and a Legacy Report Services Wiki entry, that seem may be pertinent here, if you haven't already come across these.

All of our Report Web Service options should be contained within the above referenced documentation. As far as I can tell, to filter a report you'd use a FILTEROPTIONS request. You need to look into the ReportFilter table for both the FilterID and the ReportID in the Yellowfin configuration Database in order to accomplish this. Our documentation does provide an example of this:

/D+nf7iebdQOJAAAAABJRU5ErkJggg==

Unfortunately though, I'm afraid it is outside the scope of Standard Support to write any code, so I can really only provide high-level information and links to assist with this. Any specific coding solutions would fall in the realm of Consulting services, if that's something you'd be interested in obtaining or if you have purchased consulting hours left... I believe you've worked with our Consultant Justin in the past. He may able to provide quick pointers on how to set this specific to your environment should our documentation prove insufficient.

Hopefully this clears things up a bit though. Please let me know if you have any further questions or concerns regarding this.

Regards,

Mike

photo
1

Hi Will,

I just wanted to check in and see how things are going with this.

Regards,

Mike

photo
1

We spoke to a support engineer that is helping us with this case – I’ll try my best to explain the resolution once we’ve figured it out 😊

Thanks for your help!

From: Support Queue <support@Yellowfin.bi>

Reply-To: Support Queue <support@Yellowfin.bi>

Date: Wednesday, May 15, 2019 at 3:21 PM

To: William Volin <will@tiltify.com>

Subject: New Comment in "Loading javascript API report with filters"

photo
1

Hi Will,

Great! Thanks for the update.

Regards,

Mike