I converted a classic dashboard which had Jobs Closed and Jobs Completed checkboxes in the tracker.
The converted Kinetic app has the following BAQ Options \ Where List
JobHead_JobClosed = '??{Jobs_Over_Under_Issued_0_6.JobHead_JobClosed,''}'
Are the comma and single quotes before the right brace placed correctly? If so, what does it mean?
Not certain but I believe the double ?? means
if arg1 has value then arg1 else arg2.
So the double ‘’ arg2 means if arg1 is empty or undefined then use empty string.
So something like this sql:
WHERE JobHead_JobClosed = ISNULL(Jobs_Over_Under_Issued_0_6.JobHead_JobClosed,‘’)
Thanks, Josh.
How can I force false value instead of null or ‘’? When the form loads it does not populate the Jobs_Over_Under_Issued_0_6.JobHead_JobClosed field with false value, it leaves it ‘’. I tried the following, ‘??{Jobs_Over_Under_Issued_0_6.JobHead_JobClosed,‘false’}’ but that did not work.
I’m a little confused… this is a BAQ where clause… so I would think you just want:
“where”
Column: JobHead_JobClosed
Condition: =
Value: false
Right now your set up looks like its trying to pass the column’s value back into itself.
I guess I have to create new events to populate the Complete and Closed fields with false values instead of ‘’. I was hoping I could avoid that.
Well, its a where list. Are there other columns it is filtering in the drop down?
Only JobHead_JobClosed and JobHead_JobComplete
The main issue is that the form has only two filters, Job Closed and Complete checkboxes. When the form loads the grid panel does not populate until I check both checkboxes and then uncheck them.
I created new events which bypass the system created events and populated the Jobs_Over_Under_Issued_0_6.JobHead_JobClosed and Jobs_Over_Under_Issued_0_6.JobHead_JobComplete fields with “false” values. Now the grid is populating with the correct data but the checkboxes in the filter area are checked.
I figured it out thanks to the Checkbox displaying wrong value - Kinetic ERP - Epicor User Help Forum post. I was using “false” string instead of false value. The dashboard is working fine.
Glad my post was of use!
