That’s not what I meant. (like at all…)
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 
#AiFatigue
3 Likes
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.
1 Like
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 carry on 
wasn’t meant as an ofense mostly just a jab at the dumb Ai being the flavor of the moment for everything.
I did eventualy manage to convince the Avalara Ai to get me a real human, boy was that a fight. It kept telling me to reconfigure my Netsuite….
2 Likes
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.
8 Likes
I thought of that too, I created a calculated field but being a string, besides being really gross, and I couldn’t still filter, don’t remember what the problem was.
I’d give ‘OR’ another shot. Concatinating a valid SQL OR statement is a workaround until they fix the IN() clause comma problem.
ShipHead_PackNum=158352 OR ShipHead_PackNum=158609
Things like this remind me of why MS SQL seriously needs to support array types.
Ok, that might work, but only for static values, in my application a function returns results, and can’t pass to “Where” like that, I tried ShipHead_PackNum = 158352 OR 158609, but just gives me all packs. I already opened a Support Case on Epicare, thanks for trying to help.
Yeaah..
Say your results were rows in a dataview field Results.PackNum, you could set the kinetic-baq where expression like so:
#_ trans.data("Results").map(row => `ShipHead_PackNum = ${row.PackNum}`).join(" OR "); _#
FYI: This issue has PRB0302923 stuck in status ‘Accepted - Not Yet Planned’ since 8/18/2025
1 Like
This PRB is still sitting not yet accepted since August - marked ‘no workaround’.
3 Likes