Does anyone have an example of the correct syntax to be able to number the rows in a query? It would be sincerely appreciated.

[image] BAQ return only 1 row per part number ERP 10 You would recreate this SQL using the BAQ editor. It can be challenging if you don’t know SQL. But you can compare what shows up on the general tab for the BAQ this to see if you are on the right track. The one Ken Poste…

So I have a calculated field in the Epicor10 BAQ and put this in OrderDtl.SysRowID_RowNum but saying it is invalid. There are quite a few tables joined in this query but I am sure the SysRowID is unique to all rows.

No you need a calculated field here @Banderson explains it in more detail in this thread. [image] BAQ to evaluate consecutive rows in table ERP 10 Occasionally receiving errors happen, causing unexpected changes in part costs. I am trying to write a BAQ to compare the hi…

row_number() over (partition by table.field, table.field etc order by table.field asc) You use the groupings if for what you want to group by (you might be able to skip that if you literally only want row numbers) and order by is what the numbering uses to order by. You can also add asc or dec for …

Did you ever get this resolved? Trying to do the same thing to just number the number of rows returned in the query displayed at the time of retrieval.

Could not use sysrowid. Had to go another route. [image001.png]

Not sure what exactly you need, but this would give you row numbers for each baq line result row_number() over(order by field you want to sort it)

Number Rows in BAQ

Epicor ERP 10

josecgomez (Jose C Gomez) April 27, 2021, 8:11pm 4

No you need a calculated field here @Banderson explains it in more detail in this thread.

Topic		Replies	Views
BAQ Result Record Numbering Epicor ERP 10	4	770	October 23, 2017
BAQ to evaluate consecutive rows in table Epicor ERP 10 dmt	13	5102	March 26, 2019
BAQ return only 1 row per part number Epicor ERP 10	20	9245	April 3, 2024
BAQ Running Total Epicor ERP 10	12	10504	December 19, 2018
Limit BAQ results based on field Epicor ERP 10 e10 , epicor , baq	5	637	September 18, 2019

Number Rows in BAQ

Related topics