We are migrating from E9 (Progress) to Kinetic and identified that the First (Selection) from E9 does not translate to Kinetic correctly. Some BAQ’s are returning thousands of records beyond what is actually expected.
I would appreciate any assistance or information on how to modify the BAQ to work properly.
Thanks in Advance.
Miguel Lopez
Could you share the BAQ Structure and the generated SQL from the BAQ Designer? It will be easier to troubleshoot if we can see some detail.
Been there, we had over a hundred baqs which used more than one find FIRST or find LAST joins that had to be converted.
Yes they can be converted but… its a definitely harder in sql.
You will be doing a sub BAQ to a CTE join on the table and numbering the records in the the table you want to grab the last record for first record for then adding TABLE CRITERA for filtering and returning row 1.
Don’t worry the SQL world is much better when you get there. You will be open to more tools like pivot tables, STRING_AGG command, etc.
Here is my query layout:
