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 col.xyz.type = textarea.

In cf table, only an id is stored.

Selection_001.png

Thank you

 

2 answers

1 accepted

0 votes
Accepted answer

Hi Guilherme,

 

Have a look at this faq

https://wiki.idalko.com/display/TGPD/How+is+the+grid+table+identifier+calculated

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,

 

Francis

Selection_001.png

Hi @Francis Martens (iDalko), I know the table that contains field data. But when I have a field with col.xyz.type = 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

http://stackoverflow.com/questions/12155648/how-to-fetch-text-column-value-from-postgresql

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
Asked Thursday in Jira Ops

I'm John Allspaw, Ask Me Anything about incident analysis and postmortems

I'm John Allspaw, co-founder of   Adaptive Capacity Labs, where we help teams use their incidents to learn and improve. We bring research-driven methods and approaches to drive effective inciden...

473 views 2 5
View question

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