Jump to content

Recommended Posts

Posted

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

Posted

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

Posted

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.

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...