Announcement

Collapse
No announcement yet.

Show report filtered for "Current user"

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Show report filtered for "Current user"

    Hello,

    is there any way how to limit a report which is "grouped by" user, to show information only for the current user?

    For example to put there a filter with the logic "user = CURRENT_USER()" instead of putting there exact name(check screen pls)

    I would assume that it is somehow possible via "Complex expression" however I am not familiar with this and I cannot find much information about expressions in docs.

    Basically what we are trying to achieve is to have a report on each user's dashboard, which shows values just for the current user. I hope I made it clear to understand. Thank you! Click image for larger versionName:	report_current_user.jpgViews:	0Size:	54.7 KBID:	82740
    Last edited by Jakub Grufik; 09-09-2022, 06:30 AM.

  • #2
    Hi Jakub,

    A complex expression should work.​

    Click image for larger version

Name:	image_7659.png
Views:	151
Size:	10.3 KB
ID:	82744

    Comment


    • #3
      Hey Yuri,

      thanks a lot for your help as always.

      Will try and let you know.

      Comment


      • #4
        Is there a way to apply similar logic to assignedUsersIds?
        I need to fetch records, where assignedUsersIds contain current user id, but I can't figure out how to properly do it (if it is possible)​

        Comment


        • #5
          Yes.

          Click image for larger version

Name:	image.png
Views:	24
Size:	10.7 KB
ID:	105158

          Comment

          Working...
          X