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

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 Join to answer
Community showcase
Emilee Spencer
Published 9 hours ago in Marketplace Apps

Marketplace Spotlight: DeepAffects

Hello Atlassian Community! My name is Emilee, and I’m a Product Marketing Manager for the Marketplace team. Starting with this post, I'm kicking off a monthly series of Spotlights to highlight Ma...

30 views 0 3
Read article

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot