Set a default value in a Dashboard tracker prompt / BAQ Paramaters & tracker inputs

Epicor ERP 10
1

I have a dashboard with a tracker input prompt for a date field.

Is there anyway I can have that field default to today’s date when the dashboard loads?

And preferably, the value is applied prior to the Auto Refresh on Load of the dashboard.

Can dashboard tracker inputs override conditions in a BAQ? For example, in the BAQ, add a parameter for a date, and set table condition to use that parameter. Set the default of that param to TODAY().

Would a dashboard that uses this BAQ always need to have the parameter supplied via the BAQ’s pop-up window? Or could the tracker input be passed to that BAQ parameter?

1 Like
2

I think I can answer the question:

Is there anyway I can have that field default to today’s date when the dashboard loads?

image
image.png824×232 7.54 KB

And then in the InitializeCustomCode(), set the value for the control to DateTime.Today

public static void InitializeCustomCode()
{
	// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **
	// Begin Wizard Added Variable Initialization

	dteCalculated_LoadDate.Value = DateTime.Today;
	// End Wizard Added Variable Initialization

	// Begin Wizard Added Custom Method Calls

	// End Wizard Added Custom Method Calls
}

For the other question, I guess you can take the condition out of the BAQ, and use the Trackview data as the filter instead.

2 Likes
3

Not without coding the BAQ. Go vote for this one. We all want it!

4

I VOTED!!!
And its the clear winner of desired features

image

1 Like
5

I wonder how many it will take for Epicor to put it on a priority list? 21 doesn’t seem like enough. :frowning_face:

@aidacra? @Bart_Elia? @Olga? @Edge?

2 Likes
6

I’d guess that improvements that reduce tech service calls - including “How do I …?” are the things they’d address first.

7

Maybe while they do this fix same goes for “BAQ Reports” that despite having Filters it runs the BAQ “Widely” open and only applies your filters POST-Query.

You end up with 1000+ Rows but the SSRS only shows 1 or 10. Problem: BAQRpt filters POST Query.

WhyIHateBAQReports
WhyIHateBAQReports.png1007×427 37 KB

8

That depends on when you want it filtered though. Depending on your BAQ, if you are aggregating, you need to be able to specify whether or not you want pre or post filtering.

9

So how would this work in E9?
I tried to do the same thing but that would not compile.
I then did the following and that compiled but then encountered a runtime error stating that the Guid didn’t exist.

EpiNumericEditor FiscalYear = (EpiNumericEditor)csm.GetNativeControlReference("68684510-3529-4853-9659-4f0d08dd5c38");

FiscalYear.Value = DateTime.Today.Year;

10

22 posts were split to a new topic: Setting Defaults in quick job

32

Hi @ckrusen

i do not know if this idea will help you on this requirement, but why don’t you create dataview field on your dashboard tracker and bind it to CallContextVariable, then use this variable as a constant value criteria in your BAQ, using this syntax [EpiBinding:BPMData.XXXXX],

33

This works great, thank you!