Hello!
As promised during the Insights EpiUsers panel, I am posting these tools freely for community use! This post is a Wiki if anyone would like to help me flesh out the documentation/screenshots.
The development history can be viewed in the previous thread.
Download (Contains both SQL On The Fly and Dev Tools 1/2)
DevToolsDebug_v2.zip (660.5 KB)
Version 2 - Contains BAQ/SQL Schema in Panels
What’s in the Solution.zip (2025.1+ supported)
- Functions
- DevTools
- Loki
- SQLOnTheFly
- Bifrost
- BAQs
- GF_Heimdallr
- GF_BPMOnTheFly
- Apps
- Ice.UIDbd.SQLOnTheFly
- Ice.UIDbd.DevTools
- Ice.UI.DevTools
- Menus
- System Setup / System Maintenance /
- Dev Tools
- Dev Tools Part Deux
- SQL On The Fly
- System Setup / System Maintenance /
SQL On The Fly
- A kinetic dashboard, compatible with 2025.2+ that supports input of a SQL Query (T-SQL compatible). The query can be run directly within the dashboard and return results immediately (the columns are dynamically drawn)
- The generated and validated SQL query can be saved as a BAQ. Check the “Save Query” checkbox and your generated SQL will be saved as a BAQ under the name/description entered vs. being executed (this is nice to execute a few times til you see the data you want, then save it)
- Allows you to specify table/column aliases at all levels (sub query, cte, top-level) - now you don’t need Part_PartNum, you can have [PartNumber], same for calculated expressions, no longer need Calculated_ prefix.
- Wider Query Syntax is supported vs. Epicor OOB SQL-to-BAQ converter.
- Windowing Queries (ROW_NUMBER() OVER (PARTITION BY … ORDER BY …) AS rn FROM xxx)
- Recursive CTEs
- Fancy Expressions
- Diagnostics are output to the dashboard; this allows ease of correcting input SQL
- Save as excel is not compatible with a Kinetic Grid that has no defined columns at this time, save as CSV is offered as alternative
Please report any bugs you may find!
Dev Tools / Part Deux
Dev tools positions itself to be a Developer’s swiss army knife, giving visibility into all the things as you work.
See more detailed screenshots at the previous thread
Features:
- Visibility into all component states, including a timeline based view that allows monitoring of all network traffic, dataview changes, row rule changes, event actions, timers, etc.
- Visibility into all Dataviews and read/write, allowing you to change the contents of dataviews in memory.
- “Hover Inspector” which creates an on-hover tooltip in Kinetic, allowing you to see the properties of objects you hover over.
- “File Browser” combines with “Trace Flags” to give you increased visibility into what Kinetic is doing, and allow you to delete files easily and in bulk.
- AppStudio Editing via raw JSON
- “Generate for Design” style report editing directly in the dashboard via .rdl/xml vs. Reports.zip download/upload