Question & Answer > View Question

Clean Unused Column By Joget Form

Confluence User - 06 May, 2020

hi, since joget automatically created column table when we designing form, this will leave a lot of unused column on table. is there any script that can detect which column is used by the form, so we can do some housekeeping to drop unused column on specific tables.

database

3

Confluence User •

06 May, 2020 •

confluenceUser •

•

confluenceUser •

Hi, don't know is there any script that can detect which column is used by the form...

But what I know is that you can use HeidiSQL to check which column data is always updated, which is unused, especially column with null value.

Confluence User •

06 May, 2020 •

confluenceUser •

1 •

confluenceUser •

Hi there,

Please see Clean Up Unused Columns in Form Data Table.

Thanks.

Hugo

Confluence User •

07 May, 2020 •

confluenceUser •

•

confluenceUser •

many thanks.

1

CSV | Excel | XML | PDF

Your answer

Print

Clean Unused Column By Joget Form

3

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

Clean Unused Column By Joget Form.builder-style-81f79436-ed02-4d2d-9545-f8c2fd9a3c66{background: #efefef59 !important; margin: 0px !important; padding: 10px !important; border-radius: 5px !important; border: 1px solid #ddd !important; text-align: left !important; color:#0E4A40 !important;}

3.builder-style-9da3f418-ec84-4fb1-a10e-51b5dc59c8cc{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-601d5ed6-6aa9-4c40-9ce2-2ed4dafd94fb{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

Clean Unused Column By Joget Form

3

Your answer