I add this on where clause in kinetic-baq widget: ShipHead_PackNum IN (‘158352’,‘158609’) But using develepor mode epicor converts in this and doen’t filter correctly obviously: [image] I appreciate if someone can help me.

[image] Olga: and you know it is not how bugs are supposed to be reported :wink: Can we get an undercover boss situation set up here? Epicor really needs “secret shoppers” to push things through support so they understand the pain that comes with it… Joking… but not really.

idk today I saw 2 new BAQ stories, fixing both. So something still gets to developers somehow :thinking:

Yeah, it’s hit and miss though. More miss than hit. But yes, sometimes they get through.

AI secret shopper: The ErpBaqExecutionFilterService inserts N when the value doesn’t contain only numbers, yet only numbers regex can’t handle comma sep lists. The issue is with the current implementation of the containsOnlyNumbers function and how it’s used for IN clauses. Here’s a detailed expla…

[image] jbooker: Let me know if you want more secret shopping. That’s not what I meant. (like at all…)

[image] jbooker: Let me know if you want more secret shopping. Gotta be Honest Josh, there’s enough Ai garbage on the internet to go around. So for what is worth, no, no more “Ai” anything in my book :man_shrugging: #AiFatigue

geesh. sorry guys. just trying to help. FWIW, I find it interesting, educational, and seems to help move things through support. Suppose I’d agree if it were wrong, thus no utility. :man_shrugging:

[image] jbooker: just trying to help. All good it wasn’t an attack on you, just Ai fatigue haha Just finished fighting with the Avalara Ai support bot… everyone is using these dumb things for everything and it honeslty does a pretty shitty job most of the time even when it is “right” anyway …

while we’re clearing the air, that last ‘let me know’ line was a AI-jab. Didn’t mean me-me. Thanks for all you do. Have a great day.

Yeah, All good. I just mean Epicor needs to put some of their employees through the process to see how working with support goes so they understand what the users contend with.

IN in Where Clause in Kinetic doesn't work properly

Kinetic ERP

jbooker (Josh Booker) September 8, 2025, 4:56pm 33

FYI: This issue has PRB0302923 stuck in status ‘Accepted - Not Yet Planned’ since 8/18/2025

Erp-baq send list parameter to a baq

Topic		Replies	Views
BAQ can not use IN to filter against drop down parameter in table criteria Epicor ERP 10 baq	29	3212	August 30, 2022
BAQ Where List ... NOT IN Kinetic ERP customization , baq , kinetic , dashboard , application-studio , where-list , not-in	3	949	May 24, 2024
Kinetic BAQ widget in Application Studio Kinetic ERP application-studio	10	733	January 5, 2026
Application Studio Dashboard BAQ Where List -- "AND"? Kinetic ERP application-studio	8	1931	June 3, 2025
BAQ - filter dynamic Epicor ERP 10 customization	16	1207	May 6, 2026

IN in Where Clause in Kinetic doesn't work properly

Related topics