What would you prefer 🐢 or 🐒? 🐢 A solution where you can have reports that are global searchable. They are defined using a SuiteQL. This to have a simple UI for users to consume reports that cannot be built in suiteanalytics. The results would be presented in a similar way to a dataset, i.e, a table. 🐒 A solution where you define SuiteQL's where the results are periodically stored in a custom record to allow you to use SuiteAnalytics to build tables, pivots and charts on the result. Albeit not with live data.

not sure I want the processing overhead of creating/maintaining all those custom records and definitions (using the 🐒 option) Was just mulling over how to implement the 🐢 option last night. Has someone already come out with a SuiteApp or customisation that does this?

I'm working on a simple setup for 🐢. Works pretty nicely. Will put on github later.

Easier for the end users potentially, but I think harder to develop such a solution

It consists of a custom record where you define your SuiteQL Child subrecords of columns gets created automatically from the results In view mode on the record, all fields are hidden and only a react-table is displayed.

There was some company doing robust SuiteQL reporting as a SuiteApp. I don't remember the name though.

@Shawn Talbert NimbusQL?

Yes, that rings a bell. Does it not fit the need?

No, that's more of a SuiteQL builder. But with features for scheduling and exporting. But it's pretty polished and has really nice autocomplete for queries. For this, I'm not gonna solve the SuiteQL development part.

That looks pretty cool @Watz I can see how one of our consultants that's particularly good with SQL would lap this up. Thank you for sharing this with the community.

I've added a CSV-export option to it now

Nice work!

Just installed in our sandbox and checking it out. Took several attempts to make the query compatible but I'm hopeful. Saw this last week and have a good use case already.