Create a report of 'Requested Item [sc_req_item] created from members of particular group

[hakimbelkou]

Hello,

I need help created a list report of sc_req_item records that are created from users that are members of particular groups.

I tried to use related conditions but I'm having trouble.

Thank you!

[Ankur Bawiskar · Accepted solution]

@hakimbelkou 

the only way is to use scripted report filter condition, see this

Creating dynamic JavaScript filters in reports 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@hakimbelkou 

try to create dynamic filter option and then use that here

Opened by [IS DYNAMIC] Your Filter

Create a dynamic filter option 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@hakimbelkou 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[hakimbelkou]

Hi Ankur,

Thank you very much for your answer!

It's a workaround that I could maybe use for each team. However we have more than 50 teams, so that means that I would need to create 50+ dynamic filters.

My ideal solution would be on their Dashboard, for each team to be able to link the filter Opened by to the filter Group with the membership table. I was not able to recreate this. 

Thank you again for your answer, I will accept as solution if there is no better one now that I have given you more context.