How to Link 1 BAQ field to populate data on another BAQ in same dashboard

Hi,

I have a Dashboard that was requested and I’m using 2 BAQ’s to in the same dashboard to do it. The top BAQ is for Job material information and the bottom BAQ is for Job Operation information. I want to make it so if I select 1 row from the top BAQ and its for JOB 1234 then the bottom baq populates for the same Job 1234. I’m not sure how to go about this any help is appreciated.

Please excuse the long field names…

On the top query
Right click the properties.
On the publish tab select the field you want the bottom query to use.

On the bottom query
Right click the properties
On the filter tab. Filter the field on the published field from above.

3 Likes

Thanks Ken, I actually ended up getting that far, The only issue I have now is when I select a row from my top BAQ I have to click on the bottom BAQ then click refresh to ge tthe bottom BAQ to display the correct information, how do I get thebottom BAQ to load the information from top BAQ when it is clicked on?

Nevermind, I got it.

Autofresh on load? That was going to be my suggestion.

I’m not 100% sure what was causing it to happen, but I ended up needing to make it only show closed jobs from the last 3 years, so I deleted the queries fromteh Dashboard after I made changes to my BAQ and when I used Publish/Subscribe it just worked…