Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,364,726
Community Members
 
Community Events
168
Community Groups

How to fill a table automatically with one field?

Hello to members of the community,

I use Jira server and recently I installed Table Grid Next Generation add-on. I read the documents and I couldn't find what I wanted.

I'm not a master in MySQL but I do my work with some searches.

I connected Table Grid to MySQL database and I can see my database also I wrote some queries and saw the results.

I want to know if it's possible when I select the ID field, other fields automatically show in their own fields.

If someone has any experience with it I appreciate it help me.

1.jpg

1 answer

1 accepted

0 votes
Answer accepted

Finally, I found it by myself.

I thought it has an option or some setting but thought wrong.

It depends on my query. for example in the Fname static option I wrote this query:

 

select users_firstname from usvn_users where usvn_users.users_id = '{column:ID}'

 

Also, I wrote something like that in the LName.

Now, if I choose some ID, for the next field I only can choose one Fname and this formula is working for LName too.

maybe it helpful for someone.

Suggest an answer

Log in or Sign up to answer