Using Date Picker with a BAQ Dashboard (without a BAQ parameter)

[ErpJohn (John)]

Hello!

I would like to understand how to properly bind a Date Picker in a Panel Card Grid to a Data View and use it to filter the grid.

So far I’ve tried

1. Binding my date picker to TransView.dtFrom
2. And adding this Where clause to my View Options: CheckHed_CheckDate >= ‘??{TransView.dtFrom}’

But when I preview the app, the Date Picker is disabled. I can’t open to select a date.

I noticed that there isn’t a TransView in my data views, like I’ve seen in out-of-the-box apps like Order Entry.

I tried manually adding a TransView data view, but it requires a schema type.

But when I look at the TransView from Order Entry, the schema type is blank.

In my app, I cannot delete the schema type, it has to be either ERP, ICE or BAQ.

What do I need to do to setup a data view to bind my selected date to and also to enable my date picker? How do I do this the right way?

I don’t think I need BAQ parameters, so I’m particularly interested in doing this without BAQ parameters.

Appreciate any help from you guys.

[dcamlin (David Camlin)]

Schema doesn’t really matter. Just leave it as ERP.

Once you have your TransView dataview… you’ll also need an event to initiate it.

Its a simple event with a row-update… just row-update any field to something… and that will initiate the dataview.

Mine often look like this:

Row-Update… I just set TransView.Init to a value of true.

The Trigger, I typically leave blank, and I call this event in an “after” windowOnLoad event.

[dcamlin (David Camlin)]

What you need to watch for in your dates… is the format. A Date Picker is going to produce a format like the below:

2026-08-21T00:00:00

Test this out and see if the View Option accepts the date format:
CheckHed_CheckDate >= '{TransView.dtForm}'

[ErpJohn (John)]

Jeepers, that worked! Thanks David! I had some trouble working with the Event setup so it took me a minute… But I didn’t do anything special with the datetime formatting, just whatever defaults were in place already seemed to work.

Thanks very much!

[tmayfield (Tammy Mayfield)]

Something to keep in mind is your date picker may not work, depending on your version mine is 2023.2, if you reorder the columns. Drove me bonkers until I figured out why it wouldn’t work sometimes.

[knash (Ken Nash)]

@dcamlin another great solution. The people didn’t even need to use the @dcamlin signal this time!!!