Converting dashboard to Kinetic with Publish and Subscribe (parameters)

Kinetic ERP
, , , ,
1

I have a simple Dashboard with few BAQs.
First BAQ is publishing some figures.
Other BAQs are having parameters. Parameters are filled out by subscribing figures from first BAQ’s.

When I am running a preview for Kinetic App, I noticed a slider panel asking for parameters for each BAQ.

What is the current Kinetic status for this. Is it still not working correctly or I am missing something?

2

Since nobody else has replied . . . I haven’t been able to get this to work (2022.2.20).

3

I don’t have any update on this as well. Still doesn’t work.

4

I have this exact same issue - I am being prompted for the second set of Parameters.

Has anyone been able to slay this dragon?
DaveO

1 Like
5

So one workaround i found is to create a calculated field that uses the Prompts from the top level BAQ. I.e. make a calculated_StartDate = @StartDate and calculated_EndDate = @EndDate.
That way the parameters will be part of EVERY record at the top BAQ.

Then in the main query of the dashboard Publish the Calculated_StartDate and Calculated_EndDate.

Then in the subquery baq remove all the parameters. In the Dashboard add a filter to the subquery and have your Second query filter by the calculated fields in the top query.

Sorry not very elegantly put - but hopefully you get the gist.
DaveO

Then in the

6

If you need to pass in the same date range parameters to multiple BAQs, then add two date fields on your dashboard and link them to transview.fromdate and transview.todate, then add a button for getting data. on the button click event add a baq event action, in the baq event action there is a way of passing parameters to the query, like orderhed_orderdate >= ‘?{transview.fromdate}’ (one ? for triggering BAQ only when parameter has value and ?? if that does not matter) this way you only have to pass the parameters 1 time and all of your baq event actions can use the same transview dates for the execution. Hope this helps..