Unable to locate "Process Stage" table

[haoest]

guys, this is driving me nuts. I wanted to locate "Process Stage" table and add to it to my solution. Somehow this table ain't showing up for me. I can even use Azure Data Studio to query "select * from processstage" and I get hits. I can also add the "Process" table to my solution, Just that somehow "Process Stage" ain't coming up when open the Tables page in the Maker portal.

Been hanging out with chatgpt for half a day now and follow the precise steps... Just can't get it to come up.

what's going on?

[Fubar]

If you mean the "Stage Category" (Develop, Qualify etc etc) for Business Process Flows? if so, it is not a Table - it is a Global Option Set (Choices).

[haoest]

No I don’t mean stage category. I mean “process stage” which stores all stage names of BPF processes. 

[Fubar]

When you create a BPF now, a new Table is created for that BPF (i.e. create 3 BPF's get 3 new Tables) - so all you need is to include that new Table (in the old days it used to be structured differently).

[haoest]

@Fubar 

I am able to find my BPF table. This table has processid, which refers to an entity in "process" entity (whose underlying table is "workflow" table).

In the BPF table there is also another field called "activestageid". This guid refers to an entity in "Process Stage" (whose underlying table is supposed to be "processstage" table). Strangely, I can use SQL Server Management Studio to query "select * from processstage" to get a hit, but I am not able to add "Process Stage" table to my solution. This goes back to my original question. This table is not found in my developer environment...

[Fubar]

So workflow, if your BPF triggers a workflow - in which case include the Workflow that it triggers.

Active Stage id refers to the data.  E.g. when a user uses the BPF a instance/transaction record is created and the Active Stage is from that transaction is recorded.

For moving your BPF to a new environment in a Solution, you just need to include the BPF (Process), Table of your BPF, the Global Option Set (only if you have added any new Categories), any Workflows your BPF may call.  Also, you will want to update Security Roles as the users will need privileges to your the BPF Table to be able to use it.

[haoest]

thank you for trying, but you misunderstood my question. At this moment in time, I just wanted to add a system table called "Process Stage" to my solution.

[haoest]

And to add a minor detail, the fact that I can do

select * from sys.tables where name ='processstage'

and get a hit, I know the table is there. It maybe some configuration or permission issue that's hiding it from me...

[Fubar]

Not every Dataverse Table is exposed via the interface (e.g. some are only available in code such as the many to many intersect tables), if you can't see it as a user with the System Administrator security role then it is probably marked as an internal object.  The question is why do you need it? It is an out of the box table that will not have been customized and it should already be in the Target environment.

[AKampen · Accepted solution]

You won't add this table to your solution, you wouldn't want to customize it at all.  When you publish your solution to a production environment the refecnes to this table iwill hook up to the Process Stage table in that environment.

I'm going to go out on a limb and asusme you want to interact with this table to add a lookup to the active stage in a custom table or column of yours, and this is definately possible.

To add a lookup for the Process Stage table, you have to use the classic interface; you can't do it in the modern experience.  

These screenshots should help a bit.

If you are not familiar at all with the classic interface, don't let it scare you because it is mostly the same but with the old names.  Tables are called entities and columns are called fields.

In my case, I want to add a custom table to track the history of every BPF stage, so I created a table called Stage History and in order to add a lookup for the active stage of my BPF process stage, I had to go into the classic experience as below.