04-22-2024 09:05 AM
I have a dashboard that pulls Workflow status information. It is currently hard coded to look at a top level Workflow parent, as it is for Group use only.
I want to make this dashboard available for the regions too, and change the hard coded workflow selection in the dashboard to instead run from the Text 1 property in the user's security setup.
How can I do that?
I managed to pull Text 1 using a SQL query, but this only seems to work for me when I set the Parameter as a Bound List. The problem with that is that the Bound list pops up as a selection when the dashboard is run, which I don't want to happen. It should be seamless.
Solved! Go to Solution.
04-22-2024 12:29 PM
You said you want to avoid a BR, so what about this Substitution Variable |UserText1| ? This example uses Text4:
04-22-2024 09:49 AM
Hi @Beeswing77 , Parameters are frustrating to me in this regard.
In your situation, I would use an XFBR rule to query and return the text1 value. This takes parameters out of the whole equation and puts the code in your hands.
04-22-2024 11:46 AM
I was hoping to avoid a BR, as I'm not quite sure where to start with one. If that's the only option though I might have to look into that.
04-22-2024 10:13 AM
I'm a bit confused. Is this what you have in mind?
04-22-2024 11:27 AM
Yes, correct.
04-22-2024 12:29 PM
You said you want to avoid a BR, so what about this Substitution Variable |UserText1| ? This example uses Text4:
04-23-2024 03:43 AM
Perfect! That works.
04-22-2024 11:37 AM
@Beeswing77 - You can also try current WF selection. based on the Current WF Profile it will displays the status. It is more dynamic, in this method the user should select the WF Profile before executing the dashboard.
04-22-2024 11:45 AM
Hi,
Yes, that was our starting point.
In this instance though that doesn't work for us. The dashboard shows the workflow status for all workflows in the Group. We have a button set up so that if you select one line of the dashboard and then press the button it jumps you straight to the relevant entity's workflow. If the dashboard is dynamic, like you suggest, when we jump back to the dashboard it will only show the entity that we drilled in on, instead of the Group.