Question about Idalko Table Grid Edtior

[Guilherme Nogueira]

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

Selection_001.png

[francis · Accepted solution]

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

[Guilherme Nogueira]

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

[francis]

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

What database are you using ?

[Guilherme Nogueira]

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

[francis]

(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 ?

[Guilherme Nogueira]

Thanks for your support.