How can i delete old column from database table?

Confluence User - 25 Apr, 2018

i create new text field with ID = textfield_a.

When i submitted new process, it'll create new column textfied_a in target table.

 

After that, i create other text field with ID = textfield_b. And then i remove textfield_a

.

Before submit other process, i drop target table. So the data still empty

When i submitted other new process, BUT it still generate OLD column (textfield_a). 

 

How can i delete old column/unused column in target table on database? 

 

Regards,

forms;datalists

7


25 Apr, 2018
confluenceUser
confluenceUser

Hello, if you are sure you do not need the old field, you can generate the table yourself using a create script, omitting the old field. In fact you can use the script that a DB client shows you automatically in the properties of the table. As long as joget finds the table and the fields that the form needs, it will write correctly. Normally I prefer to do that creation of the tables myself, to specify some types of field of a specific type to save me effort when making queries and reports, since Joget by default creates all fields as text.

26 Apr, 2018
confluenceUser
confluenceUser

Hi, to prevent data lost, the columns are created based on all version of your apps. Meaning if your app version 1 has "textfield_a", and your app version 2 deleted "textfield_a" and created "textfield_b". The database will still create "textfield_a" and "textfield_b".

26 Apr, 2018
confluenceUser
confluenceUser

yes, my apps is in v4 right now. So how can i delete the old version (1-3) in database? i already deleted the prev version in joget web. What i have now is only the v4 version

26 Apr, 2018
confluenceUser
confluenceUser
04 Jun, 2018
confluenceUser
confluenceUser

Prima Politico Did you find a solution to this problem? I am facing the same issue

05 Jun, 2018
confluenceUser
confluenceUser

Balakumar Gopalakrishnan i create new table with different name but the same database column. i dont know any other solution because i already deleted previous version app

05 Jun, 2018
confluenceUser
confluenceUser

Prima Politico Thanks mate.!

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print