Hi,
I’m trying to build a three‑level database view based on an entity hierarchy. We have three entity types: Domain, Process, and Sub‑process. These entities are related through an entity hierarchy table with the following relationships:
Domain (upstream) → Process (downstream)
Process (upstream) → Sub‑process (downstream)
My requirement is to create a single database view that displays Domain → Process → Sub‑process together in one row.
Could you please advise on the best approach to model or create this view in ServiceNow?
