Question about Idalko Table Grid Edtior

Hi, i'm using Table Grid Editor version 1.20.1 and I want to know what is the name of table that store data from a  column type = textarea.

In cf table, only an id is stored.


Thank you


2 answers

1 accepted

0 votes
Answer accepted

Hi Guilherme,


Have a look at this faq

All tge based data is stored in a table which is managed by the add-on.  The number in the CF is the number of rows in the grid for that particular issue.


Let me know if this helps,




Hi @Francis Martens (iDalko), I know the table that contains field data. But when I have a field with = textarea, it doesn't save text itself in the column (Check "comments2") it's a key from another table. This table is what I want.

Thank you

Textarea columns are clobs allowing to store huge comments.  This clobs are implemented differently depending on the database system.

What database are you using ?

Hi @Francis Martens (iDalko), I'm using PostgreSQL smile

(sorry that I didn't followup earlier - JIRA is much easier to track issues than answers)

Can you check following stackoverflow document

Locate the last answer ...


select convert_from(loread(lo_open(comments2::int, x'40000'::int), x'40000'::int),  'UTF8') from <yourtablename>;


Not sure if this will work - but can you give it a try ?


Thanks for your support.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 09, 2018 in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

375 views 6 0
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