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.

[Mandeep Karan]

Use this URL to construct your query builder for m2m table

http://www.cavucode.com/blog/2016/1/21/filter-edit-list-reference-list-results

kindly mark it as helpful and correct answer if it helps you.

Regards,

Mandeep

[seraias2016]

I try too by this option, the client script function well, but the collector data not show only the values desired :(. 

Thanks for your response. 

Regards

[seraias2016 · Accepted solution]

I solved the requeriment for my customer.

I describe the step for it.

• I modified the UI Action "Edit".
• into script I obtained the sys_id of record of problem.
• I opened the table of problem and get the value of field that is pivot
• I added the sysparm_query to uri.set.
• I builded the url and "ta-da👍" I view only the data desired.

So very thank you for your ideas.

Regards

kindly mark it as helpful and correct answer if it helps you.

[Mandeep Karan]

Nice approach!

[Community Alums]

Hi Seraias,

  This is very mice approach and exactly what we need, could you mind share your code or a little more implementation details with me?

Thanks lot!

Jerry