View Options of panel-card-grid is not working

Kinetic ERP
1

Hi,

I’m new to Kinetic UX. I’m trying to figure out why the “View Options” (Open/Closed Cases) isn’t working. I converted from the classic dashboard to the Kinetic App. Everything else works fine except for this view option using the top combo box. What am I missing?

Thanks in advance!

image

image

2

Try double quotes:

“??{Constant.NullData}”

Hope it works

3

Thanks, Jordie.
Unfortunately, it didn’t work with either single or double quotes.

4

I had never encountered the Constant dataview before … but maybe it should be Constant.NullValue?
image

5

Good question here. Trying out now, but nullable dates seems to be a pain in the ass

6

Does this help:

“whereClauseHDCase”: “HDCaseStatus = ‘OPEN’ and CompletionDate IS NULL by HDCaseNum DESC”

image
image1440×916 43.7 KB

btw this is option “Rest Params”

7

If this is a rest call to Erp.BO.HelpDeskSvc then the BAQ Options will not do anything at all. In which case, the Rest Params is the best option.

Epicor rarely stores data as NULL … but I just confirmed that an empty CompletionDate in this table is stored as null. In your BAQ Where List, then the operator is IS NULL (with nothing in the Value field) instead of =

8

Yeah, I think this method would be more intuitive. But I’m using BAQ, not the BO service. I don’t want to mess things up by changing it. I’m trying to create a new application using the “New Application Wizard” because there’s a step to build view options. Hopefully this would work.

9

Thanks! Always tried using some stuff in the value field, like IS in the operator and NULL in the value. :sweat_smile:

10

Are you referencing your own BAQ?

11

Try the IS NULL operator.

NULL does not equal the empty string and Where List uses pseudo SQL in its comparison

12

Yes, it’s a revised BAQ based on the existing BAQ for the classic dashboard (Case Tracker).

13

Then I would suggest… instead of trying to filter by a null date… create a calculated field in your BAQ as a bit field.

iif(HDCase.CompletionDate IS NULL,1,0)

Then you can just filter by 1’s and 0’s instead of trying to battle null values.

Actually… may make more sense to reverse it. Calc field called “CaseComplete” or something like that…

iif(HDCase.CompletionDate IS NULL,0,1)

That way if the case is complete, it gets a 1… if not it is a 0.

3 Likes
14

Thanks David!

I had to replace the one of the auto-generated conditions in View Options.

  • from : HDCase_CompletionDate = ‘??{Constant.NullDate}’
  • to : Calculated_Status = ‘Open’

your advice saved my time. Thank you!

2 Likes