How do I match custom fields with Current User?

I am trying to make a report in EazyBI to identify who is logged into confluence and extract issues based on their names.

Using the [Assignee].[User].getmemberkey(currentUser()) Works well if I want to check against reporter or assignee.

However it does not work when trying to compare with another user value in a custom made Field. Asking for matches with a spesific name Works, so I know that EazyBI is able to read the value in the Field.

How can I match it to the value of the currently logged in user?

3 answers

1 accepted

HI!


CurrentUser() works only with default user dimensions, as this function returns user key value which is not imported in the custom dimension.

You can use CurrenUserName() function instead: 

[Field1].[Field1].getMemberByKey(CurrentUserName())

Could it be a solution for you?

 

Ilze / support@eazybi.com

 

Tested and works perfectly.

This can be retrieved easily from the com.atlassian.confluence.user.AuthenticatedUserThreadLocal class which will give you the current logged in user as a com.atlassian.confluence.user.ConfluenceUser object.

ConfluenceUser confluenceUser = AuthenticatedUserThreadLocal.get();

It seems to me Your answering a different question than the one I asked. I want EazyBI to identify the current logged in user in confluence and compare it to the value in a Jira-Field so that the diagrams and such Return all issues With that persons id in my custom made Field.

Could you please write the way you try to get user value in a custom made Field?

Let's call the custom JIRA-field "Field1"

At first i tried this code with assignee, and it shows me graphs and diagrams with all the issues where I am the assignee (the currently logged in user in cofnluence or eazyBI for that matter)

[Assignee].[User].getMemberByKey(CurrentUser())

Then i tried applying that in the new field (Custom field in dimension category) wich is also a field that only allows for JIRA users as a value.

[Field1].[User].getMemberByKey(CurrentUser())

 

This returned nothing.

Double-checked by adding a calculated member that said
[Field1].[Doe, John]

 This returned all cases where John Doe was registered in the custom field, so nothing wrong with the data in itself.

Then I tried a bunch of variations that either returned nothing or gave me error messages that said I could not compare dimensions with labels and so on.

Example 1: IIF([Field1] = CurrentUser(), result1, result2)

Example 2: IIF([user].getMemberByKey(CurrentUser()) = [Field1], result 1, result 2)
(No function matches signature  <Member> = <Dimension>

Example 3: [Field1].[user].getmemberByKey(CurrentUser()) = [Field1].CurrenMember (or currenUser etc) AT this point I was just experimenting.

I'm pretty new to this (and self-taught) so I'm probably barking up the wrong tree entirely and should maybe just discard my attempts? smile

It seems that [Field1] accept String values which are UserName.
You might try to  [Field1].[CurrentUser()]

I tried adding a calculated member that said [Field1].[CurrentUser()] and nothing more.

It Returns no values and it does not work With the assigne Field instead of Field1 either.

Hi,

To get loggined user in confluence :

$action.remoteUser,$remoteUser

The currently logged in user, or null if anonymous user.

User

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Asked May 24, 2018 in Confluence

What are the resources that you use to learn more about Atlassian Products?

I am gathering information about resources available for Atlassian product knowledge transferring for a presentation in our local Atlassian User Group. I want to group them in four categories From ...

603 views 18 16
View question

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you