Pavel Rodionov Il y a 14 années 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) Veuillez vous identifier pour voter. Répondre en tant que ... Annuler Ray Augé Pavel Rodionov Il y a 14 années Why? A simple ExpandoColumnLocalServiceUtil.deleteColumn(ong companyId, long classNameId, String tableName, String columnName);will remove the column from the table as well as all values associated with it! Veuillez vous identifier pour voter. Répondre en tant que ... Annuler Pavel Rodionov Ray Augé Il y a 14 années Hm, so your approach is to pollute code with such statements? So for every added/removed column some precondition should exist? What if I add 50 columns in a row. Also I don't understand how it will work if I want to change type of column, for example from ExpandoColumnConstants.STRING to ExpandoColumnConstants.DATE. Veuillez vous identifier pour voter. Répondre en tant que ... Annuler Juan Fernández Pavel Rodionov Il y a 14 années Hi Pavel:1.- The idea is to avoid doing this by hand in every installation of the product. If you have a plugin you can deploy it in the server and it'll do all that tasks.2.- The number of columns is not important: just add it in the hook code.3.- You can use the type you need for your field using ExpandoColumnConstants and it shouldn't be a problemRegardsJuan Veuillez vous identifier pour voter. Répondre en tant que ... Annuler
Ray Augé Pavel Rodionov Il y a 14 années Why? A simple ExpandoColumnLocalServiceUtil.deleteColumn(ong companyId, long classNameId, String tableName, String columnName);will remove the column from the table as well as all values associated with it! Veuillez vous identifier pour voter. Répondre en tant que ... Annuler Pavel Rodionov Ray Augé Il y a 14 années Hm, so your approach is to pollute code with such statements? So for every added/removed column some precondition should exist? What if I add 50 columns in a row. Also I don't understand how it will work if I want to change type of column, for example from ExpandoColumnConstants.STRING to ExpandoColumnConstants.DATE. Veuillez vous identifier pour voter. Répondre en tant que ... Annuler Juan Fernández Pavel Rodionov Il y a 14 années Hi Pavel:1.- The idea is to avoid doing this by hand in every installation of the product. If you have a plugin you can deploy it in the server and it'll do all that tasks.2.- The number of columns is not important: just add it in the hook code.3.- You can use the type you need for your field using ExpandoColumnConstants and it shouldn't be a problemRegardsJuan Veuillez vous identifier pour voter. Répondre en tant que ... Annuler
Pavel Rodionov Ray Augé Il y a 14 années Hm, so your approach is to pollute code with such statements? So for every added/removed column some precondition should exist? What if I add 50 columns in a row. Also I don't understand how it will work if I want to change type of column, for example from ExpandoColumnConstants.STRING to ExpandoColumnConstants.DATE. Veuillez vous identifier pour voter. Répondre en tant que ... Annuler Juan Fernández Pavel Rodionov Il y a 14 années Hi Pavel:1.- The idea is to avoid doing this by hand in every installation of the product. If you have a plugin you can deploy it in the server and it'll do all that tasks.2.- The number of columns is not important: just add it in the hook code.3.- You can use the type you need for your field using ExpandoColumnConstants and it shouldn't be a problemRegardsJuan Veuillez vous identifier pour voter. Répondre en tant que ... Annuler
Juan Fernández Pavel Rodionov Il y a 14 années Hi Pavel:1.- The idea is to avoid doing this by hand in every installation of the product. If you have a plugin you can deploy it in the server and it'll do all that tasks.2.- The number of columns is not important: just add it in the hook code.3.- You can use the type you need for your field using ExpandoColumnConstants and it shouldn't be a problemRegardsJuan Veuillez vous identifier pour voter. Répondre en tant que ... Annuler
Francisco Aranda Il y a 13 années 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! Veuillez vous identifier pour voter. Répondre en tant que ... Annuler Francisco Aranda Francisco Aranda Il y a 13 années Sorry, I didn't look so well. The method is deprecated but it still exists. the new method has a new added companyId parameter. So I'm going to see what happen if I pass the companyId param. Veuillez vous identifier pour voter. Répondre en tant que ... Annuler Juan Fernández Francisco Aranda Il y a 13 années Hi Francisco:thanks for the update. I didn't realize this has changed. If you add the companyId to the method it'll be ok. Tell me if you achieve this and everything works okSaludos,Juan Veuillez vous identifier pour voter. Répondre en tant que ... Annuler
Francisco Aranda Francisco Aranda Il y a 13 années Sorry, I didn't look so well. The method is deprecated but it still exists. the new method has a new added companyId parameter. So I'm going to see what happen if I pass the companyId param. Veuillez vous identifier pour voter. Répondre en tant que ... Annuler Juan Fernández Francisco Aranda Il y a 13 années Hi Francisco:thanks for the update. I didn't realize this has changed. If you add the companyId to the method it'll be ok. Tell me if you achieve this and everything works okSaludos,Juan Veuillez vous identifier pour voter. Répondre en tant que ... Annuler
Juan Fernández Francisco Aranda Il y a 13 années Hi Francisco:thanks for the update. I didn't realize this has changed. If you add the companyId to the method it'll be ok. Tell me if you achieve this and everything works okSaludos,Juan Veuillez vous identifier pour voter. Répondre en tant que ... Annuler
Francisco Aranda Il y a 13 années Here is how I did it in LR6. Some extra comments in http://www.liferay.com/community/forums/-/message_boards/message/5165696protected 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) { } } Veuillez vous identifier pour voter. Répondre en tant que ... Annuler Michele Celli Francisco Aranda Il y a 12 années This example is no longer available, can anyone tell me where to get this sample ? Veuillez vous identifier pour voter. Répondre en tant que ... Annuler Juan Fernández Michele Celli Il y a 12 années Hi Michele!You can get the code from svn plugins trunk -> http://svn.liferay.com/browse/plugins/trunk/hooksRegards! Veuillez vous identifier pour voter. Répondre en tant que ... Annuler Leo PRATLONG Juan Fernández Il y a 12 années To checkout the code with SVN : http://svn.liferay.com/repos/public/plugins/trunk/hooks/sample-expando-hook/login : guest passwd: Veuillez vous identifier pour voter. Répondre en tant que ... Annuler
Michele Celli Francisco Aranda Il y a 12 années This example is no longer available, can anyone tell me where to get this sample ? Veuillez vous identifier pour voter. Répondre en tant que ... Annuler Juan Fernández Michele Celli Il y a 12 années Hi Michele!You can get the code from svn plugins trunk -> http://svn.liferay.com/browse/plugins/trunk/hooksRegards! Veuillez vous identifier pour voter. Répondre en tant que ... Annuler Leo PRATLONG Juan Fernández Il y a 12 années To checkout the code with SVN : http://svn.liferay.com/repos/public/plugins/trunk/hooks/sample-expando-hook/login : guest passwd: Veuillez vous identifier pour voter. Répondre en tant que ... Annuler
Juan Fernández Michele Celli Il y a 12 années Hi Michele!You can get the code from svn plugins trunk -> http://svn.liferay.com/browse/plugins/trunk/hooksRegards! Veuillez vous identifier pour voter. Répondre en tant que ... Annuler Leo PRATLONG Juan Fernández Il y a 12 années To checkout the code with SVN : http://svn.liferay.com/repos/public/plugins/trunk/hooks/sample-expando-hook/login : guest passwd: Veuillez vous identifier pour voter. Répondre en tant que ... Annuler
Leo PRATLONG Juan Fernández Il y a 12 années To checkout the code with SVN : http://svn.liferay.com/repos/public/plugins/trunk/hooks/sample-expando-hook/login : guest passwd: Veuillez vous identifier pour voter. Répondre en tant que ... Annuler
(Vous) Il y a 12 années [...] 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 Veuillez vous identifier pour voter. Répondre en tant que ... Annuler
Florencia Gadea Il y a 11 années 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. Veuillez vous identifier pour voter. Répondre en tant que ... Annuler
Nabil Bahtat Il y a 9 années 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 Veuillez vous identifier pour voter. Répondre en tant que ... Annuler