Adding a workflow state field to the list view of an application over a join table where the workflow is the secondary table rather than primary

We need access to add the workflow state field to the list view of an application over a join table where the workflow is the secondary table rather than primary

For example in 25.1RPDevPartner, in a Sales Order app, we have a search action on the Customer field, which points to a search app, which is over a join table where Directory is the primary table and a partner owned table is one of the secondary tables. We want to show the workflow from the partner owned table in the list view of the search app; however, it seems we don’t have access to that field. Is that because it’s the secondary table? We only want to show workflow of that record in the list view of the search app then add a mapping to only show those with certain limited workflow statuses. Is this possible? Or, no since it’s a join over the secondary table, so we would have to show all vehicles and then throw an error in logic they cannot choose vehicle’s in those WF states on FVC of Customer ?

We don’t currently support adding workflow from a secondary join table on the list view. One workaround that you can do is to not have the search app be over a join table, but over a table that has a table lookup to the secondary table. Then you can add the workflow from the secondary table as a related field and filter by that field.

2 Likes