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

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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published Thursday in Marketplace Apps

Calling all developers––You're invited to Atlas Camp 2018

 Atlas Camp   is our developer event which will take place in Barcelona, Spain  from the 6th -7th of   September . This is a great opportunity to meet other developers and get n...

77 views 0 5
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