Database View - Change Request Approval - Approval Status RAG

mrswann · ‎03-02-2016

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 · ‎03-02-2016

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

View solution in original post

Inactive_Us2053 · ‎03-08-2016

My 'Approve' UI Action does not have the 'Client' box ticked, so runs server side. The code for it when using my database view is:

var appr = new GlideRecord('sysapproval_approver');

appr.get(current.apr_sys_id);

appr.state = "approved";

appr.update();

Inactive_Us2053 · ‎03-08-2016

Sounds like you'll need to change the line:

appr.get(current.apr_sys_id);

to

appr.get(current.ar_sys_id);

mrswann · ‎03-08-2016

Thanks - still no cigar!! The client tick allowed the script to execute successfully as the alert was displayed but no updates to the approvals

Sent from my iPhone

mrswann · ‎03-11-2016

Solved!!

I was over complicating, massively. OOTB functionality - glide system property to show extended fields, go in to approvals list and configure list layout. Bring through the fields. Only downside is anyone not using Change Request would see blank fields. Currently no one for us .

Thanks all....

Sent from my iPhone