Problems with the Kinetic BAQ Designer

[Olga (Olga Klimova)]

So reported it and it was rejected?

[aosemwengie1 (Alisa Osemwengie)]

I can’t remember. There are a lot of issues accepted with no ETA. A lot of issues development is still reviewing (for months or years). A lot of issues I simply don’t report because I don’t have time to do a 2 hour webex to show support how to reproduce it.

[Chad_Smith]

Having spent a bit of time here, I can tell you I would 100 times over choose the BAQ Designer (even the Kinetic one) over Generic Inquiries.

Fair point on the strategic layout of it though.

[LoganDing (Logan Dingess)]

@dylanb

BAQs analyze/ execute fine in the client but fail to run in the Kinetic designer

[dylanb (Dylan Benner)]

I look at it at least once a day

[Chris_Conn]

If I havent said it lately, we all appreciate the hell out of you being here!

[klincecum (Kevin Lincecum)]

@Mark_Wonsil

client that only runs on Windows?

With a little refactoring… that .net 4.5 could move to modern .net, which runs almost everywhere.

[Randy (Randy Stulce)]

+1 to what @Chris_Conn said, we appreciate all the Epicor employees who come here to EpiUsers.

[jbooker (Josh Booker)]

@dylanb

fail to run in the Kinetic designer.

FWIW, one reason this happens, is when your gridModel.columns has some cols not in your BAQ. Like if you put the BAQ on a gridView.BAQOptions.
Case point:

Add PO Line to Sales Order Shipment Status?

I attempted to repoint the zCustomerShipments dataview to MY zCustomerShipments_NFM BAQ, but it didn’t appear in the drop down. If you have AppStudio dataview open BEFORE you duplicate the BAQ, you must refresh the page to get the new baq in the drop down. Upon changing the BAQ in the dataview, new columns are automatically added to the dataview. [image] But as you found, new dataview columns are not added to Grid Model > Columns and dataview BAQ has no affect on BAQ in View options. Int…

[Mark_Wonsil]

@klincecum

With a little refactoring

Little? WinForms uses Windows graphics libraries, and I don’t think those can run on Mac or Linux. Could be wrong.

@klincecum

almost everywhere

Not iOS or Android tablets though…

[jbooker (Josh Booker)]

W A S M ?

[zachg (Zach Griffeth)]

Correct on WinForms - it was ported but is under platform specific code for Windows only. I imagine they would have to license yet another UI frontend to replace the outdated Infragistics version.

This would be a monumental refactor which would almost certainly have problems like Kinetic has faced in the last 5 years.

[NateS (Nate Schoonover)]

@dylanb

Apart from the carpal tunnel the Kinetic designer is going to give me from all the excessive clicking

This 100% is the main issue all my users have. We navigate classic via keyboard. Now we have to use the mouse. If a dialog box pops up, put the flipping cursor in it. If I press enter, flipping accept my input!

[tpogue (Trudy Pogue)]

@mbilodeau

And the ability to copy a subquery from another baq

Thanks for mentioning this. I had no idea but just figured out how to do it!

[tpogue (Trudy Pogue)]

@Chris_Conn

If I havent said it lately, we all appreciate the hell out of you being here!

Yes! Thank you for being here, @Olga

[tgwinn (Tim Gwinn)]

Wow.

LEFT OUTER JOIN of OrderHed to OrderDtl where PARTNUM = ‘zzzzzzzzzzzzzzzzz’ (guaranteeing NULL results from OrderDtl):

Classic:

Kinetic:

That is bad.

[aosemwengie1 (Alisa Osemwengie)]

See this is what I am saying. It is so very confusing when trying to validate the query structure to see records that literally DO NOT EXIST. Maybe need to explain this to Epicor developers.

[mbayley (Michael Bayley)]

At least they aren’t using -1. I see some developers do this instead of just making the type nullable.

[Ernie (Ernie Lowell)]

@aosemwengie1, that is probably the MOST BRILLIANT graphic I have seen. Ever. Anywhere.

[Mark_Wonsil]

Memory Manager?