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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.