Query for Dashboard where clause in BAQ Execution

Epicor ERP 9
1

I am trying to read the where clause to do some calculations in the post processing of getlist in a baq. I see the where clause in the paramDataSet in the trace file, but can’t figure out how to access that information.

I am currently trying to save the information using the log BAQ routine that @jawt posted and then read it out in the baq.

Any ideas on how to get to it?

Greg

image.png1022×529 288 KB

2

are you SQL or progress?

3

SQL

Greg

4

hmmm maybe i’ll retract my thought. SQL profiler popped in to my head but you are on E9 and that might not get you what you’re after on that version.

5

I have the where clause in an informational message in the dynamicBAQ.ExecuteParameterized.
It is in the ttQueryTable.WhereClause field.

I just need to parse it and then either store it a UD table or try to pass in the ttCallcontextBPMData.

6

I got this to work. I put UD02 checkboxes on the tracker view and then passed them in the DynamicBAQ.ExecuteParamatized to the CallContextBPMData and then I can use that in get list to populate the baq results.

I can now calculate any field I want in getlist of any baq. Thanks Rob and to @kentreardon for the beginning of this process.

Greg

for each ttQueryTable no-lock.
	

If Index(ttQueryTable.WhereClause,"UD02.CheckBox01 >= True") > 0 Then 
		ttCallContextBpmData.Checkbox01 = True.

If Index(ttQueryTable.WhereClause,"UD02.CheckBox02 >= True") > 0 Then 
		ttCallContextBpmData.Checkbox02 = True.

If Index(ttQueryTable.WhereClause,"UD02.CheckBox03 >= True") > 0 Then 
		ttCallContextBpmData.Checkbox03 = True.

If Index(ttQueryTable.WhereClause,"UD02.CheckBox04 >= True") > 0 Then 
		ttCallContextBpmData.Checkbox04 = True.

If Index(ttQueryTable.WhereClause,"UD02.CheckBox05 >= True") > 0 Then 
		ttCallContextBpmData.Checkbox05 = True.

message " where clause " + string(sWhere) + " check boxes " + string(ttCallContextBpmData.Checkbox01) + string(ttCallContextBpmData.Checkbox02) + string(ttCallContextBpmData.Checkbox03) + string(ttCallContextBpmData.Checkbox04) + string(ttCallContextBpmData.Checkbox05).

End.