Database View - Change Request Approval - Approval Status RAG

[mrswann]

I have created the view which seems to be working OK

u_change_request_approvals

change_request as chg, sysapproval_approver as ar, where chg_sys_id = ar_sysapproval (against the ar table)

I have started building out the table view fields for each

as (this seems a common requirement from the community, as there are a few threads...) clearly I need to include additional information about the Change Request at the Approval User level so they can "sort Approvals by Scheduled Start" as the most obvious use case; if they need much more info they need to just access the change request but some aesthetics like short description, change type, requested by, are all nice to haves...

the issue is when I try this - the lovely coloured icon (RAG) next to the state is not showing as it would do under the main list of the approvals in the root table

Am I missing something? I can't find any other queries about this but it certainly feels a step back

I triedmoving the join to the chg table and making it a left join and seeing if that made a difference... no difference

[Steve McCarty · Accepted solution]

If I am reading your question correctly the colored icons are the field styles defined for the Approval tables.   Those styles only apply to the approval table, not your database view.   Your database view is treated as a new table in this case.   So to get those icons on your database view you have to define the field styles for your new "table" explicitly.   You should be able to find the style definitions for the change table and the recreate them for your database view.

-Steve

[mrswann]

Thank you! I have definitely learned something more

Unfortunately - the latter issues (which I've since realised) mean I may have a nice pretty "view" - but functionally this is still not quite there.

I'm guessing a UI Action against the view to enable the Right Click > Approve type functionality, but as we have locked down the Rejections to enforce via the form, there doesn't seem an easy way to open the Approval Record itself from this newly created view? I think that could solve it.

[mrswann]

This is getting more involved and less accessible!

As this is a view, it is not updatable in the same way. This means the form view of the records in the view are not the same. I do not have the approver summarizer available. I am unable to "approve" from the list view, or see the comments/activities in the form view.

This may be why the RAG status is not available as the field is not really the same "type"

It was looking good from the chart level (dashboard), and then the list view looked more akin to what I expected (allow me to order by scheduled start of the parent) - but functionally this is further from what I need than the original Approval list.

Anyone else had similar experiences?

[mrswann]

Sorry I am going mad here.

There is a difference between clicking the and clicking the State of the Approval from the DB View list record.

The is a custom form being generated against the DB View which causes issues but if I click the Approval Record State it takes me to the normal Approval Record.

So I need to affect the link