Process Flow dynamicly shows a Process Formatter...

[DrewW]

So I needed the Process Flow formatter to show a Flow Formatter dynamically and since some of the java code was not available I updated the UI Macro "process_flow" to do what I needed. Including it all here for those who mite be interested in such an enhancement.

Add the field "u_view_condition" with a type of "conditions" to the sys_process_flow table.

Here is the new code for the UI Macro "process_flow"

<?xml version="1.0" encoding="utf-8" ?>
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">
    <link rel="stylesheet" type="text/css" href="styles/process_flow_formatter.cssx"></link>
    <tr>
        <td colspan="2" width="100%" nowrap="true">
            <div>
                <table width="100%" cellpadding="0" cellspacing="0">
                    <tr>
                        <g2:flow_formatter var="jvar_flows" table="$[__ref__.getRecordClass()]" current="$[__ref__]" />
                        <g2:evaluate var="jvar_table" jelly="true">
                            var afterCurrent = false;
                            var tableText = "";
                            var show = [];
                            var label = "";
                            var gr = new GlideRecord("sys_process_flow");
                            gr.addQuery("table", current.sys_class_name);
                            gr.orderBy("order");
                            gr.query();
                            while(gr.next()){
                                //If you do not do this you get the last value of gr.label in all elements, do not know why exactly.
                                label = new String(gr.label);
                                //Check to see if the record should be displayed.  If so add element to array.
                                //Array info
                                //   show[] -> Each element is a flow formatter record to display
                                //      show[][0] -> Label for the flow formatter to display.
                                //      show[][1] -> state: used to indicate the state of the flow formatter.
                                //              Possible values: past, current, future
                                //      show[][2] -> next_state: used to indicate the state of the next flow formatter.
                                //              Possible values: past, current, future
                                if(Packages.com.glide.script.Filter.checkRecord(current, gr.u_view_condition)){
                                    show.push(new Array(3));
                                    show[show.length - 1][0] = label;
                                    //Check if this is the current flow that should be green/selected.
                                    if(Packages.com.glide.script.Filter.checkRecord(current, gr.condition)){
                                        show[show.length - 1][1] = "current";
                                        show[show.length - 1][2] = "future";
                                        //Once current is found update the previous element
                                        if(show.length > 1){
                                            show[show.length - 2][2] = "current";
                                        }
                                        afterCurrent = true;
                                    } else {
                                        if(afterCurrent){
                                            show[show.length - 1][1] = "future";
                                            show[show.length - 1][2] = "future";
                                        } else {
                                            show[show.length - 1][1] = "past";
                                            show[show.length - 1][2] = "past";
                                        }
                                    }
                                }
                            }
                            //clear the next_state element so that the process flow has a pointer at the end.
                            show[show.length - 1][2] = "";
                            if(!afterCurrent){
                              show[show.length - 1][1] = "future";
                            }
                            //Build the table
                            for(i in show){
                                tableText += '<td class="process_flow ' + show<i>[1] + '" title="' + show<i>[0] + '">';
                                tableText += show<i>[0];
                                tableText += '</td>';
                                tableText += '<td width="16" height="100%">';
                                tableText += '    <img style="height: 24px; width: 21px; margin: 0px; padding: 0px;" src="images/chevron_' + show<i>[1] + '_' + show<i>[2] + '.pngx" />';
                                tableText += '</td>';
                            }
                            tableText;
                        </g2:evaluate>
                        $[jvar_table]
                    </tr>
                </table>
            </div>
        </td>
    </tr>
</j:jelly>

[DrewW]

I think I need to see a screen shot, I am just not understanding what you are trying to say.

[nataraj1]

Hi Drew

I have implemented this for testing in "https://training1.service-now.com" for Enhancement Table(rm_enhancement).For records (rm_enhancement_list.do)

Please can you verify it that will be very helpful for me.

Thanks
NT

[DrewW]

Ok, I found the issue. The current.getRecordClass() is returning a blank value so to get it to work you have to switch it to "sys_class_name" or make all of your Process Flows have unique names.

I will update the code above to reflect this.

[DrewW]

I guess I should have tested it a little bit more before posting it. Sorry to anyone that did not have this work for them.

[DrewW]

I updated the code above to eliminate a quirk and also made changes so you do not have to make sure that the names are unique.