Report, compare updated by with requested for

[Jess Larsen1]

Hi. 

I dont have PA but I want to compare 2 fields in a "sc_req_item" report but I cant select the fields i want. 

I want to compare "updated by" with the field "requsted for" but i can´t select other fields then the ones shown on the picture. 

In short we sendt updates out from our sc_req_item on delays but we have to manually open them all or go through very long lists to see if any were updated by the requested for. I need to make a report for a dashbord that will update when a requested item is updated by the user it was requested for. 

I hope someone can help with this.

Best Regards

Jess Larsen

[Saurabh Gupta]

Hi,
You can dot walk to requested for => User ID then compare. Don't forget to select "Show related fields" if not selected.

[Jess Larsen1]

Hi Saurabh

I have tried selveral times and also inverted the query to see if I can get the 2 fields to compare. I even tried to make a function field with the same value and it wont let me use the "is same as" in fields to compare.

Hope you have either a step by step (as I might have missed something) or another suggestion. 

Best regards

Jess

[Tai Vu · Accepted solution]

Hi @Jess Larsen1 

Let's try to set the condition in the opposite, such as: Requested for. User ID is same as Updated by.

Or if you can leverage the SNUtils to set the encoded query directly.

1. Double-click to the Filter Breadcrumb.

2. Set the encoded query below

sys_updated_bySAMEASrequested_for.user_name

Cheers,

Tai Vu