The explained aproach lacks one thing - schema incremental update. If you add/drop some column, you need to drop whole table, or create DML migration scripts for expando tables (which is entertaining task for one entity, but if you have a lot of entities it could take whole day, if not more)

I've tried to run this code in LR6, but it seems that addTable and getTable are deprecated. If I'm not wrong, what is the right way to add expandos in LR6? Thanks.

Podrías darme una manito u orientarme con esto. Gracias!

Here is how I did it in LR6. Some extra comments in http://www.liferay.com/community/forums/-/message_boards/message/5165696

protected void setupExpandos(long companyId) throws Exception {
ExpandoTable table = null;
try {
table = ExpandoTableLocalServiceUtil.addTable(
companyId, User.class.getName(), ExpandoTableConstants.DEFAULT_TABLE_NAME);
}
catch (DuplicateTableNameException dtne) {
table = ExpandoTableLocalServiceUtil.getTable(companyId, User.class.getName(), ExpandoTableConstants.DEFAULT_TABLE_NAME);
}
String column = "";
column = "alternativeEmail";
try { ExpandoColumnLocalServiceUtil.addColumn(table.getTableId(),column, ExpandoColumnConstants.STRING);
} catch (DuplicateColumnNameException dcne) { System.out.println(column+" already exists!"); }


try {
ExpandoColumn ecolumn = ExpandoColumnLocalServiceUtil.getColumn(companyId, User.class.getName(),ExpandoTableConstants.DEFAULT_TABLE_NAME,column);

//I had to add UPDATE perms to GUEST in order to set column values from the hook.
Permissions.setRolePermissions(companyId,ExpandoColumn.class.getName() ,ecolumn.getPrimaryKey(), RoleConstants.GUEST, new String[] { ActionKeys.VIEW, ActionKeys.UPDATE});

} catch(Exception e) { }
}

[...] Super ! Merci beaucoup pour ces précisions qui me seront très utiles ! Je vais partir sur les Expandos donc, d'autant plus que le nombre de documents dans le système ne sera pas très élevé (pas plus... [...] Read More

Hi Juan!

This article was really helpful, thanks. But I have a doubt: How do you set the length of a string column?

Thanks,
Flor.

Hi Juan,
I wonder if I can use this approch to add custom fields to any entity,
because from GUI Control Pannel/Custom fields only few entities are listed.

Thanks,
Nabil