Dynamic Query Widgets pull real-time data from the Infor Data Lake straight into your Infor OS workspace. Standard SQL, the roles you already manage, and nothing to install in between.
p2-i Widgets are real-time, context-aware extensions that run inside your Infor OS workspace. They read straight from the Infor Data Lake with standard SQL and respect the roles and permissions you already manage in Infor OS.
SQL Data Lake engine Direct queries, no transaction lag, no background loading scripts.
Zero-code configuration Admins paste SQL and publish. Your team builds new widgets on its own.
In-context integration Widgets follow the active session, so the right data lands on the right screen.
Every widget deploys from the standard Infor OS Widget Catalog, and it can live in the Infor Go app, the Infor LN side panel, or the Infor OS homepage.
List & ChartBannerKPIIn-Context
9:20
Part 1: The Big Picture. The ERP visibility gap, the architecture on the Data Lake, and how the widgets respect Infor OS roles.
Widget families
See each family in action
Three episodes, four families. Each one runs on the same SQL engine and the same permissions model.
Built and presented by the p2-i innovation team: Mahmoud Hajri, Alessandro Rappini, and Andrea Guaccio.
Operational
Dynamic Query List & Chart
The List shows Data Lake rows and columns like a grid, configured by pasting standard SQL. Dynamic tags adapt the data to the user, Global Search runs across the database, and Drillbacks open the target Infor LN session from any row. The Chart turns the same query into bar, area, column, and donut views.
When to use When you need a structured, row-by-row view, and when a click should open the record in Infor LN.
Grids configured with plain SQL
Global Search across the full database
Drillbacks straight into Infor LN
Download Data to CSV and Load More
Charts with no frontend code
15:03
Executive
Dynamic Query Banner & KPI
The Banner sits at the top of the workspace with the numbers that matter most, and it scales across legal entities with the same dynamic tags. The KPI widget uses simple SQL aggregations like SUM and COUNT to surface a single metric, with labels and font sizes you can tune. An Info button on every widget shows the query behind the number.
When to use When one number must be seen the moment the workspace opens, or when a manager checks a single metric every day.
Homepage numbers instead of a report hunt
One dashboard across multiple legal entities
SQL aggregations with the returnedvalue alias
Full transparency through the Info button
9:37
Contextual
In-Context Widgets & Testing Tools
In-Context widgets live in the Infor OS side panel and listen to the active Infor LN session, so related information shows up without leaving the screen. The Main Entity Type matches the public context, from BusinessPartner to SalesOrder, and three layouts cover list, chart, and info card. The Tester suite validates Drillback links and reads the logged-in user ID before you deploy.
When to use When the user needs details about the record already on screen, like open orders for the selected supplier.
Admins paste SQL and publish. New widgets ship without a development cycle.
Security-first
Every widget respects standard Infor OS roles and permissions. No second access layer to audit.
No middleware
Pure SQL against the Data Lake. Nothing to install between the ERP and the data.
Team autonomy
Once your people are trained, they build widgets on their own. No endless consulting hours.
FAQ
Questions we hear before a walkthrough
Do we need to install anything?
The deployment is handled by our team, and the implementation curve is low. You do not need a heavy project or new infrastructure on your side.
Does it respect our Infor OS security?
Yes. Every widget uses your standard Infor OS roles and permissions. There is no second access layer to audit.
How much work does this put on admins?
Once a query is briefly aligned to work with the widgets, it is copied and pasted. After a short introduction, admins create and publish widgets on their own.
Which Infor suites does it work with?
It runs on Infor OS, so it works across suites. It reads any table published and synced to the Infor Data Lake.
What can a widget show?
Everything published to the Infor Data Lake, standard or custom, including the data behind your own sessions. The four families cover lists, charts, banners, KPIs, and in-context panels.
What happens in a walkthrough?
A short introductory training, then we build widgets together on your real questions until you are autonomous. When a case is more complex than the dynamic query families can handle, we provide tailor-made solutions.
See it on your data
Bring a real question and we build the widget around it. The demo is interactive, and at the end we can go through your own cases.
9:20
15:03
9:37
11:35