Friday, June 25, 2010

Business Activity Query Designer

Business Activity Query Designer is availabe in Epicor under:
System Management > Utilities

It is used to create queries in Progress ADL, which can be used is dashboards, or to export data using Business Activity Query Export Process (located in same path). Business Activity Query Export Process can export a file in .csv or .xml, either as a one time process, or on a schedule.

Unfortunately, as a data export tool, ADL lacks many functions in SQL. For instance, I wanted to return only distinct rows from a table, but there is no equivalent of "SELECT DISTINCT".

No comments:

Post a Comment