Hello.
Has anyone needed to create functionality (or is there a forge component) for the following use case with either some of all of the criteria listed?
"As a user, I want to be able to create my own data query (data columns from a select group of entities, grouping, filters, sorts, role access, custom color coding [via css]), so that I can customize the data I see on my dashboard and access my saved queries as needed in order to perform my duties."
Thank you in advance!
P.S. This similar functionality is available in QuickBase, but looking for a solution for Outsystems.
Hi Elyse Gilbert,
Check this post for similar question, you might find here some ideas
https://www.outsystems.com/forums/discussion/59480/dynamic-report-creation-from-the-screen/
Hope that it helps you
Thank you - it's not quite what I'm looking for. I don't want users executing their own SQL or a subscription to a service. More like a screen with various sections for users to configure their reports without injecting SQL.
Something like this (this isn't the full screen):
The main problem with this, is that the user must have understanding of the data model. And that's usually a big problem, as users don't understand rational data models, so they try to make queries that don't perform or run at all. Users are typically way better off with tools like Qlik or other report builders that start from an already flat and prepared data model specifically for reporting.
In most cases, I would totally agree with you. However, these specific customers are quite adept and used to this functionality in their existing tool (QuickBase), but we are trying to get them moved into OutSystems as the existing tool isn't as flexible. So, while I would normally concede, this is existing functionality our client is requesting and that I'm hoping I can replicate in OutSystems.
Hi Elyse,
Take a look at this component for inspiration:https://www.outsystems.com/forge/component-overview/9255/easy-query-maker
Regards,
Daniel
Thank you Daniel. That's a portion of what I need to find a solution for, but not 100%. Thank you for posting!
Hey @Elyse Gilbert
There is a forge component please check this out SQL Sandbox.
URL: https://www.outsystems.com/forge/component-overview/5900/sql-sandbox.
Thanks Shlok Agrawal
Thank you, Shlok. I am trying to avoid allowing users to execute their own SQL statements.