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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Friday in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

327 views 17 10
Join discussion

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