/* Disclaimer!!! This is not a real query being executed, but a simplified version for general vision. Executing it with any other tool may produce a different result. */ select [QuoteHed].[QuoteNum] as [QuoteHed_QuoteNum], (REVERSE(stuff(REVERSE(REPLACE(REPLACE(((select (Cast(XFileAttch.Key1…

This is the second occurrence in a week of someone having trouble with FOR XML in a WHERE clause in Kinetic. There’s been no response on any solution to that post, but others were suggesting rewriting the BAQ to avoid the FOR XML in the WHERE clause. If you describe what the query is supposed to do…

Thanks Mark, I want to achieve something similar as explained in the post: [image] BAQ: Calculated Field Concatenate Rows to single field Experts' Corner Here is an example @WesAtITC CustOrder.baq (17.6 KB) [image]

I would follow @Banderson ’s advice and convert that to string_agg. FOR XML in BAQ - ERP 10 - Epicor User Help Forum (epiusers.help)

Solved. One of my friends helped me: Create this setting in Query Execution settings and you are done :slight_smile: [image]

That, is not the query that you posted. But glad you fixed it. (That’s should be converted though. That band-aid isn’t going to last you forever).

[image] Vishal.Sharma185: Create this setting in Query Execution settings and you are done I agree with @Banderson . Make a note of this technical debt for yourself or the person who has to maintain it later. It will have to be paid eventually. :slight_smile: But glad it got you moving forward…

I’m also trying to produce from a BAQ a concatenated list of items (serial numbers for ShipDtl) for a single pack line. I stumbled upon this conversation, downloaded the example BAQ, got the error, made the change to Query Execution Settings and got it to work. However, it appears you can’t set a …

You are really taking the hard way around. FOR XML was a workaround when it was used this way. Now that we have string_agg, it is the way to go. It is simpler, easy to understand, and reliable. Just use it. :slight_smile:

You have to make sure that the hacked formula is the last one. Can you post a screen shot of your criteria?

BAQ incorrect syntax near 'FOR'

Epicor ERP 10

Vishal.Sharma185 (Vishal) October 14, 2022, 1:16pm 4

Thanks Mark,

I want to achieve something similar as explained in the post:

Topic		Replies	Views
FOR XML in BAQ Epicor ERP 10 e10 , baq	33	4997	October 14, 2022
Error while using FOR XML PATH statement Kinetic ERP baq	5	1267	April 25, 2023
FOR XML PATH versus STRING_AGG Epicor ERP 10 baq	66	14298	October 28, 2024
Using FOR XML PATH('') twice doesn't work Epicor ERP 10 baq	2	816	October 23, 2023
FOR XML PATH error on Upgrade Epicor ERP 10 epicor , baq	4	1965	January 27, 2021

BAQ incorrect syntax near 'FOR'

Related topics