Tables for Custom attributes

Message Boards

Manish Kumar Jaiswal, modified 11 Years ago.

Tables for Custom attributes

Regular Member Posts: 153 Join Date: 11/25/08 Recent Posts

Where does the entries for custom attributes and there values goes when we create it for suppose User entity?

Regards
Manish

David H Nebinger, modified 11 Years ago.

RE: Tables for Custom attributes

Liferay Legend Posts: 14919 Join Date: 9/2/06 Recent Posts

They are expando values and go into the expando tables.

You should not access these tables directly, instead use the Expando APIs to access the values.

Hitoshi Ozawa, modified 11 Years ago.

RE: Tables for Custom attributes

Liferay Legend Posts: 7942 Join Date: 3/24/10 Recent Posts

All the information pertaining to custom attributes regardless of where it is used are saved to expando tables. There are expandocolumn, expandorow, expandotable, and explandovalue tables. If you create too many custom attributes with many rows, performance may degrade because of this.

Nagendra Kumar Busam, modified 11 Years ago.

RE: Tables for Custom attributes

Liferay Master Posts: 678 Join Date: 7/7/09 Recent Posts

Hi Hitoshi,

What will be the best approach to go forward If I have to create extra fields for OOTB liferay components such Organization/User.

Is it by creating a custom table using new service.xml for extra fields which stores all those extra fields.

For e.g., I need to create 5-8 extra fields for organization, In my case I might be having 50,000 organizations.

Thanks,
- Nagendra Kumar