Create URL to open report based on a filter value

JonT shared this question 26 days ago
Answered

I found this article that is effectively what I am looking to do, but when I follow the instructions I do not see the filter and filter ID (numeric) listed in the response.

https://www.yellowfinbi.com/resources/forum/yfforum-how-do-i-access-a-specific-report-with-parameters-using-a-url-thread-212141


The pictures in the link do not work so I cannot see for sure what is expected to be used for the filter, but this is what I have from my browser when inspecting the filter.

/90334e2e65eca6da8527c301504ec67f


I tried adding &filterTitle='hostname' to the end of the URL, but that did not work or provide any different data than what the report had. In fact, it seemed as though it dropped the additional part from added to the original URL altogether. The word hostname is just how it was formatted, I used an actual valid host from the original list, but nothing was output.


I plan to keep digging, but has anyone been able to edit or modify a URL to perform something like this? We are looking to build a URL based on a hostname and have a report that has some pre-defined information and then filter on the host selected from the external application. The idea is, when a user is working with a host in particular, they can click a link that will launch the reporting UI and basically run the report with input for the hostname as a filter. We have the report and link, just need the additional info to get the filter added to the URL correctly so we can have the template ready to go.


Thanks

Comments (5)

photo
2

Hi Jon,


You should be able to find the filter ID in the 'filter list' div, a few code blocks above where you are looking. I tried the instructions described in the article with success by appending '&filter71679=Hard' to filter all the tennis tournaments with a Hardcourt in my particular dataset.


/20850407295bb644c97f2b526ec71295


/925c466125b7b6b2ef7254a351c005b0


Let me know how you go.


Kind regards,

Simon

photo
1

Simon, thank you and thanks for the screenshots! That was the ticket, I had my blinders on. Worked like a champ. We are going to play around with the functionality, but this will get us started.

photo
1

Hi Jon,


Not a problem.


Another way you could find filter ID values could be through the Yellowfin Configuration Database, by looking at the ReportFilter and ReportHeader tables. Please always make sure to exercise caution when using the Configuration Database as any changes may cause irreversible damage to your Yellowfin instance.


Let me know if there is anything else I can help with, or if I can go ahead and close the ticket.


Kind regards,

Simon

photo
1

Hi Jon,


I'm going to go ahead and mark this question as completed. If you still require assistance with this, please don't hesitate to respond and we will get back to you shortly.


Kind regards,

Simon

photo
1

Yes, thank you. I have another topic open and if things work out, I will be sure to flag it answered. Appreciate the help!