Hi Maheshwari,
This may also help you with some examples:
https://cwiki.apache.org/confluence/display/OFBIZ/Revisions+Requiring+Data+Migration+-+upgrade+ofbiz
HTH
Jacques
Le 20/05/2023 à 14:04, Nicolas Malin a écrit :
What's didn't works ?
When you recreate all the db with OFBiz after a change, or just restart OFBiz
on existing database ?
On the second you need to apply an ALTER TABLE on your field.
For the first, check that you modified the good fieldType file.
Nicolas
On 20/05/2023 12:06, Mahi maheshwari wrote:
Hello Community,
I'm trying to change the size of groupId column of the SecurityGroup entity.
I tried changing the size from 20 to 80 as mentioned below.
Method: 1
<field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"/>
I replaced this line with the below line of code
<field-type-def type="id" sql-type="VARCHAR(80)" java-type="String"/>
Method: 2
and also tried changing the below-mentioned code, I changed the type to the
description for groupId.
<entity entity-name="SecurityGroup"
package-name="org.apache.ofbiz.security.securitygroup"
default-resource-name="SecurityEntityLabels"
title="Security Component - Security Group">
<field name="groupId" type="id"></field>
<field name="groupName" type="value"></field>
<field name="description" type="description"></field>
<prim-key field="groupId"/>
</entity>
both methods didn't work, please guide me If I'm going wrong anywhere.
I'm also attaching the screenshot for you to have a look at.
Regards,
Maheshwari.
