Jump to content

Filter report by "current user"


Alberto M

Recommended Posts

Hi all.

Tried to find this, but no success.

How can I filter a report by the current user - the user that is navigating Hornbill?

I wanted to list the scheduled jobs but I don't want people to list scheduled jobs not owned by her/him.

image.thumb.png.d0ceca6a9eddc0d08d0fdd1976d40d79.png

Thanks,

Alberto

Link to comment
Share on other sites

I don't think you can... Or certainly you couldn't when I was still using the platform. The "trick" I used was something like this:
image.thumb.png.164621c455f484c505113745b46eea39.png

image.thumb.png.38968eca28ca799bcc98ec1422a9dad1.png

You can change the join to "Join" instead of left join if you want.

Then when running a preview:

image.png.7a11f7954b274019cfba718b3f29ca6a.png

 

image.thumb.png.c9c62a57be3c4c702915314750e0754d.png

Just created a sample for you on the demo site:  https://admin.hornbill.com/demo/app/com.hornbill.servicemanager/reporting/91/

Just in case I also attached the definition.

I LOVE THIS PLATFORM!!! I really miss it, it's so good!

ttest.report.txt

Link to comment
Share on other sites

It would probably be better to have an idea of what you're trying to achieve here.

It doesn't sound like a report is the best method for displaying the list of scheduled tasks to the User who owns them, I would expect them to view those in the Activities View.

A report is usually created so that it runs automatically on a regular basis, in which case there would be no current user - it would be the system that is running it.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...