Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Joining entity_property table to cwd_users



Any suggestions on joining the entity_property table to cwd_users?




2 answers

0 votes
Andy Heinzer Atlassian Team Jan 18, 2019

Is this a question about the Jira database? A Confluence  database?  or some other product?

At least in regards to Jira: These two tables don't contain related elements/fields.  So I'm not sure how you would join them for any purpose of use.

You can see from the database schema in that these two tables don't relate directly to each other in any way.

Is there something that you are looking for within the database here?

Thanks.  This is for Jira.

The fields are able to be joined via API (I can lookup or set properties for a user), so I would think that their has to be some sort of lookup table somewhere...



0 votes

There is no lookup or cross reference, the Atlassian systems that have those tables handle the relationships it needs in its code.

I would want to question what you are trying to achieve, as we can't really tell you where to look in a database without knowing what the actual question is.  Plus, we'd like to tell you how to answer the question without reading the database, as it is the single worst possible way to report on any Atlassian system.

Suggest an answer

Log in or Sign up to answer

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you