Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
CTE or Recursive Query for Hierarchical Data (Employee / BOM)
I would like to get insights on retrieving hierarchical data (e.g., employee reporting structure or BOM/Sub-BOM hierarchy) using CTE queries via ODBC/ADO.NET or recursive logic.
From my understanding, SuiteQL does not support CTEs or recursive queries, so I am exploring alternative ways to achieve this. I noticed some colleagues have implemented similar solutions and would like to learn from your experience.
Specifically:
- How did you implement hierarchical data retrieval using ODBC/ADO.Net or SuiteQL?
- Are there any workarounds or best practices for recursive queries in NetSuite?
- Any references to existing SuiteAnswers articles or SuiteIdeas enhancements that address this would be very helpful.
0