While Sitefinity's APIs are the standard for interacting with module data, some backend scenarios—like data exports, reporting, or syncing with other systems—don't require the overhead of the full API lifecycle. For these tasks, what you really need is simple, read-only access to the raw data in a flat structure that you can quickly map into a POCO.
This stored procedure is designed for that exact purpose. It bypasses the API to provide a direct, high-performance way to query any dynamic module's data. It's a practical shortcut for when you need to get straight to the source.
The GREAT part about this is that you just tell it the module and type you want and it'll:
- Generate you a single row for each item, merging in all the data from the around the DB like scheduled task date
- Search out linked categories and tags automatically, providing the result as JSON with Taxon Ids.
Now obviously it won't do RELATED data (at least yet)... but this is a good start that works for any Sitefinity type (afaik).
I'm sure, full disclosure, Progress would** PREFER YOU USE THE API!**
Enjoy, thanks to Jonathan and Kevin Reed (no relation?)