Process Flow dynamicly shows a Process Formatter...

DrewW · ‎10-07-2011

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 · ‎06-04-2014

For those of you how would like to use the updated version that I put on ServiceNow Share with out having to load the update set here is the updated UI Macro code.

<?xml version="1.0" encoding="utf-8" ?>

<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">

<tr>

<div>

<tr>

<g2:flow_formatter var="jvar_flows" table="$[__ref__.getRecordClass()]" current="$[__ref__]" />

<g2:evaluate var="jvar_elements" jelly="true" object="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()){

//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[].label -> Label for the flow formatter to display.

// show[].state -> used to indicate the state of the flow formatter.

// Possible values: past, current, future

// show[].next_state -> used to indicate the state of the next flow formatter.

// Possible values: past, current, future

if(GlideFilter.checkRecord(current, gr.u_view_condition)){

var item = new Object();

item.label = gr.getValue("label");

//Check if this is the current flow that should be green/selected.

if(GlideFilter.checkRecord(current, gr.condition)){

item.state = "current";

item.next_state = "future";

//Once current is found update the previous element

if(show.length > 1){

show[show.length - 1].next_state = "current";

}

afterCurrent = true;

} else {

if(afterCurrent){

item.state = "future";

item.next_state = "future";

} else {

item.state = "past";

item.next_state = "past";

}

show.push(item);

}

//clear the next_state element so that the process flow has a pointer at the end.

show[show.length - 1].next_state = "";

if(!afterCurrent){

show[show.length - 1].state = "future";

}

show;

</g2:evaluate>

<j2:forEach items="$[jvar_elements]" var="jvar_el">

<g2:evaluate jelly="true">

var label = jelly.jvar_el.label;

var state = jelly.jvar_el.state;

var next_state = jelly.jvar_el.next_state;

</g2:evaluate>

$[label]

</td>

</td>

</j2:forEach>

</tr>

</table>

</div>

</td>

</tr>

</j:jelly>

View solution in original post

DrewW · ‎06-04-2014

For those of you how would like to use the updated version that I put on ServiceNow Share with out having to load the update set here is the updated UI Macro code.

<?xml version="1.0" encoding="utf-8" ?>

<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">

<tr>

<div>

<tr>

<g2:flow_formatter var="jvar_flows" table="$[__ref__.getRecordClass()]" current="$[__ref__]" />

<g2:evaluate var="jvar_elements" jelly="true" object="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()){

//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[].label -> Label for the flow formatter to display.

// show[].state -> used to indicate the state of the flow formatter.

// Possible values: past, current, future

// show[].next_state -> used to indicate the state of the next flow formatter.

// Possible values: past, current, future

if(GlideFilter.checkRecord(current, gr.u_view_condition)){

var item = new Object();

item.label = gr.getValue("label");

//Check if this is the current flow that should be green/selected.

if(GlideFilter.checkRecord(current, gr.condition)){

item.state = "current";

item.next_state = "future";

//Once current is found update the previous element

if(show.length > 1){

show[show.length - 1].next_state = "current";

}

afterCurrent = true;

} else {

if(afterCurrent){

item.state = "future";

item.next_state = "future";

} else {

item.state = "past";

item.next_state = "past";

}

show.push(item);

}

//clear the next_state element so that the process flow has a pointer at the end.

show[show.length - 1].next_state = "";

if(!afterCurrent){

show[show.length - 1].state = "future";

}

show;

</g2:evaluate>

<j2:forEach items="$[jvar_elements]" var="jvar_el">

<g2:evaluate jelly="true">

var label = jelly.jvar_el.label;

var state = jelly.jvar_el.state;

var next_state = jelly.jvar_el.next_state;

</g2:evaluate>

$[label]

</td>

</td>

</j2:forEach>

</tr>

</table>

</div>

</td>

</tr>

</j:jelly>

neil_ryan · ‎11-07-2014

Great solution!

I experienced some minor CSS issues in Eureka (chevrons had opacity applied to them), which was resolved by adding a class attribute to the table tag (class ="proces_flow_formatter").

Row 7: <table width="100%" cellpadding="0" cellspacing="0" class="process_flow_formatter">

DrewW · ‎11-07-2014

If you get it from share there is an update set with the fix you refer to.

atrupe · ‎03-30-2015

I think there's an off-by-one error on the line

if(show.length > 1){

Should be

if(show.length >= 1){

DrewW · ‎03-31-2015

You are correct, the one on Share should have this update.