How to fill a table automatically with one field?

[CRS123456]

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.

[CRS123456 · Accepted solution]

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.