2024.2 "where" statement on grid view no longer working Kinetic Application Studio

Kinetic ERP
,
1

I built a couple grid views while I was at Insights last year. I took a class on Application Studio and duplicated what I learned to one of our existing BAQ’s. The BAQ takes data, which includes some user defined fields, and ties the order releases to a job number. This is a customization we had in classic and I was trying to get it to work in Kinetic. In Kinetic, instead of showing all data from the BAQ, I want to only show the job number that is currently open. I did that with this formula JobProd_JobNum=??{JobHead.JobNum} in the “where” field. This made sure to only show data from the BAQ that was the same Job Number as the current job in JobEntry. Removing the data in the “where” field ends up showing all data in the BAQ, so the BAQ is working properly.

I took screenshots of all of the fields I used when creating the grid.

The BAQ is called OFOrderRelFlags and the View is called OrderRelFlags.

This has been working fine until the latest update. Does this formula from the “where” field no longer work or use a different syntax now?

image
image383×802 9.48 KB

image (1)
image (1)386×801 9.62 KB

image (2)

1 Like
2

Try: JobProd_JobNum='{JobHead.JobNum}'

I just used something similar today in a dashboard I was creating:
LaborDtl_JobNum = '{Backlog.JobAsmbl_JobNum}'

That format/syntax worked for me.

3

I just tried that, but it didn’t make any difference.

4

What does the payload look like in the Network tab of Dev Tools when you have it set like that?

What happens if you use the Where List instead?

1 Like
5

If you’re using a dataview field, I believe the question marks are required.

JobProd_JobNum='??{JobHead.JobNum}'
6

That worked! Is there a reason, until now at the 2024.2 update, that it worked without the single quote marks, but now it is required?

7

Hopefully because they’re fixing the inconsistencies between property fields.
JobNum is a string, so you should have the single quotes to denote a string.

2 Likes
8

Epicor may need to let people know this. I took notes at the Application Studio session at Insights last year and I wrote the formula the way I was taught.
There are probably many people incorrectly using the formulas based on that session. They need to update their training.

9

They won’t. They’ll just silently update their documentation if they have any out there for that.

Bad. Bad trainer. They should have been teaching single quotes from the beginning.

10

@jwphillips don’t you unicorn me! A girl can dream…

3 Likes
11

I appreciate everyone’s help on this forum! I have had countless issues in the past where EpiCare told me their was nothing they could do and closed the ticket, but someone in this forum had a solution. I really do appreciate everyone on here!

I opened an EpiCare ticket 2 days ago and they still haven’t figured it out.
I’m going to leave it open and let them keep trying. I’m not going to tell them it is fixed, it is up to them to solve this problem!

It’s amazing that big tech companies can cause so many issues and not be required to come up with solutions. Our site was affected by Crowdstrike earlier this year, the Windows 2024 H2 update has caused many issues for our users including corrupting the boot files for our users, Adobe Acrobat is also having issues, and our users using the smart client have to delete a folder EVERY TIME they log in because that issue is not fixed. The only way we have been able to get by is by searching reddit and other forums to find workaround solutions.

Tech Companies need to be held responsible!

2 Likes