How to modify, the list of incidents from an value of field in Problem Management

[seraias2016]

Hello Experts.

I have an request from my customer.

he want select an incident and to relate to problem. but the request is that not want view all incidents

 

he want view only incidents that belongs of an account, (the account is refence field in PM, but also exists in IM).

I tried it with the filter, but not can create filter dinamic with value of account field of PM.

I tried it with a dinamic filter witn script include, but also not function.

The script include get value the account in PM.  if I call the Script Include in BR it function well, but in the filter don´t funcion, 

Also I reviewed the list control but I can´t create an filter before show information in collection.

Do you have an idea, to solve it.

Is posible create an filter before show the collection.

[seraias2016]

Hi,  

jerry2zhou

Of course, I share the script in ui action. 

Regards

var uri = action.getGlideURI();
var path = uri.getFileFromPath();
uri.set('sysparm_m2m_ref', current.getTableName());
uri.set('sysparm_collection_related_file', current.getTableName());
uri.set('sysparm_form_type', 'o2m');
uri.set('sysparm_stack', 'no');

//Para mostrar unicamente los INC. 
var liga = uri.toString('sys_m2m_template.do');
var param= liga.slice(153,185);


var problema;
var estacion;
var alcance;

    var gr = new GlideRecord('problem');
	gr.addQuery('sys_id', param);
    gr.query();
    if (gr.next()) {
    problema = gr.number;
    estacion = gr.u_estacion; 
	alcance = gr.u_alcance;
	     }

//para Estación
if(alcance=="Estación") { //if Estación
uri.set('sysparm_query',"u_cuenta_del_solicitante="+estacion+"^stateIN6,7");
action.setRedirectURL(uri.toString('sys_m2m_template.do'));
}

I hope it be useful for you

[Community Alums]

Hi seraias2016,

Yes, it help a lot and thanks so much!

still have 2 questions need your help:

1)Does the change made on the original global out of box Edit.. UI Action or a new one, I assume it is new one since if it is the global one I expected to see something " if the table is problem, then add this...".  But I tried to create new EDIT.. one to many UI action to overwrite the global one for a particular table, it seems the overwrite did not happen, did I miss anything?

2)Does this query "

uri.set('sysparm_query',"u_cuenta_del_solicitante="+estacion+"^stateIN6,7");

"

actually apply to the related incident table,  instead of parent problem.

I missed this point as well.

Thanks lot and Happy New Year!!

Jerry

[seraias2016]

Hello

1) you can modify the original UI ACtion or create a new UI Action, depends on your requeriment.

2) the query, filter two fields in the table. the Ui action calls an table depends on where button appears. the bucle if works with fields on problem, you can modify accordint to fields and table.

happy new year my friend!.