Kinetic Dashboard with date search

Kinetic ERP
1

Converting our classic dashboards to Kinetic. I’ve gotten all the easy ones done and now am on to the ones that have search parameters. Currently working on one that has a date search. I’ve looked through Epiusers and built it based on what I’ve found, but I’m having an issue with the date search bringing any data back.

I deployed the existing classic dashboard and created a new layer for it.

The date field is being bound to a TransView.Date

image
image1583×567 19.7 KB

I’m defaulting the value in the date field to today’s date so there is initial data in the field by using the On Create behavior.

image
image1662×410 17.7 KB

For the button i’ve got the OnClick event calling the view name and BAQ.

image
image1863×390 20.6 KB

Now there is something I’m not doing right or it’s a bug in my version. YAY!! :roll_eyes: I can’t edit the Field Data Type it remains as string.

image
image1687×464 15.3 KB

When I run it the date field populates with today’s date, but if I change the date and click search it doesn’t do anything.

When I go in the debugger it shows the transview binding but no column being bound.

image

2

Is “Date” the name of the parameter in your BAQ?

It should pick up the Field Data Type from the query parameter set up in your BAQ:

image
image635×141 3.16 KB

Not sure if your BAQ is being used elsewhere, but, for the longest time I would strip parameters out of my BAQ and then use the BAQ Execute Options to insert a Where clause instead. Not sure if that is an option for you, or not.

3

Do you have an example of doing that? I stripped the parameters out of my BAQ that is probably why it’s not working.

4

In your erp-baq action, go into the BAQ Execute Options and you can add the Where clause there:

image
image392×592 7.28 KB

So your where expression would be:
YourBAQColumn = {TransView.Date} ← I’m assuming you wouldn’t want single quotes because that would pass a string and you’re trying to pass a date.

… either try that, or you can put your Parameter back into you BAQ and see if that will work for you.

This may be why it was not picking up the “date” field data type when you tried it before.

5

I got it to work going off of your suggestion. It’s a little different in my version.

image
image381×423 6.51 KB

6

Oh, well, you’re filtering in the provider model with that Where List. I thought you were trying to do it via an erp-baq event. Sorry if I was going down the wrong path.