manage-dynamic-view-entities

What problem does it solve?

This Skill allows for the programmatic construction of complex database queries, especially when the join structure or selected fields need to be determined at runtime, overcoming the limitations of static entity definitions.

Core Features & Use Cases

• Runtime Query Variability: Dynamically build queries based on user input or changing application logic.
• Complex Joins: Supports conditional joins, including self-joins (aliasing the same entity multiple times).
• Use Case: Create a dynamic search screen where users can select which related entities to join and which fields to display, all configured through code rather than static XML.

Quick Start

Use the manage-dynamic-view-entities skill to programmatically build a query joining OrderHeader and OrderItem entities, selecting order IDs and item quantities.