How can i filter on this section to do report

mregragui_ext
Tera Contributor

‎08-23-2023 10:12 AM

Hello everyone how can i filter this section in a report to display the list of subscribed users that the value of last time login is last 3 months

Capture d’écran 2023-08-23 180323.png

I did this filter on the report but i am not getting the list of user i want 

Capture d’écran 2023-08-23 180942.pngCapture d’écran 2023-08-23 181008.png

0 Helpfuls
  • 222 Views
1 REPLY 1

Peter Bodelier
Giga Sage

‎08-23-2023 02:45 PM

Hi @mregragui_ext,

You will need to turn your logic around. Run your report on user table, and use Subscribed Users in the related list condition.

One downside is that you can't do this for multiple subscriptions at once. If you want to do that, you will probably need to look at database views.

PeterBodelier_0-1692826921538.png

 


Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.
0 Helpfuls