Hello,
I'm trying to follow this documentations;
https://webfocusinfocenter.inf...nhance_portals57.htm

Here is the issue that I'm having.
I need to first pass in user initials in order to get a fleet list to populate a drop down list box. The list box will the be used as the filter in the portal. When a fleet is selected it will then populate a list of reports for that fleet.

I've tried to create a reporting object against my metadata with the filter as the initials.
I then create a report against this reporting object to pull the correct data. FleetId and description
Then i create an HTML page | Requests & Data Sources - I use the Requests Parameters Filter Panel option.
**The issue here is I don't want to the filter on the initials I want a drop down filter on the fleet.

I've tried to create a reporting object against my metadata with the filter as the fleet.
Go through the same process as above and in the drop down in the settings use the FleetId.
however when I go to run this I'm then getting nothing in there because i didn't pass in initals to pull the list.


Frustrated because I'm using the help document and not getting anywhere. I have the extra initials as a parameter that is making this very hard.

I did get this somewhat working in 8104 however that did not use the filter panel option because it wasn't available. and I had to write javascript to manipulate the data. It was very cumbersome and I was told when we upgraded i shouldn't have to do that.

Thanks in advance,
Kelly

This message has been edited. Last edited by: FP Mod Chuck,

So, the users will only see a list of fleets available to them in the listbox, right? That list shows fleet Ids based on what's available to their user ID they log in with?

We have a similar setup requirement for various content we have displaying in various portals.

What we have done is create and -INCLUDE a "user_filter" fex at the top of our "external procedure" population requests that fill the controls for selection. This ensures that a check has happened against the user logged in for what records are allowed to be selected before the pop. request runs. This is done using a FILTER FILE [tableName] ADD block in the user_filter file. This FILTER request is filtered against a global variable we've made available throughout our entire environment that gives us a list of stores the user logged in can see content from.

So, what I would do is look into creating a procedure that you can make available to everything that runs in your environment either at the edasprof.prf or site profile level that basically makes an OR or , delimited list of fleet IDs that a user logged in has permission to see data for via global amper-variables.

Then once the list of fleet IDs for the user logged in is available via a global &&variable, plug it into a "user_filter" or whatever you want to name it fex (that's specific to the content being ran--whatever table is being used) inside the WHERE clause of the FILTER FILE block you create therein. This restricting records in the table the content is reading from to just fleet IDs the user logged in should be concerned with. Then -INCLUDE this fex at the top of the population requests (fexes) you create for your filtering controls (ones that have the ON TABLE PCHOLD FORMAT XML statement in them that you add into the Requests & Data Sources panel then tie off to the controls in Settings) that hit the table being filtered in the "user_filter" file.

Hope that all makes some sense and helps you!

This message has been edited. Last edited by: CoolGuy,