I guess I should try to use enumeration.sequnce_id as a replacement of my ids.
MrJohnBrown wrote: > > The problem is that these enum_ids in my case are used as the values in > product table fields. And there is running "Order By" on them. So they are > ordered from Low to High sets, in other words have grading. That is why in > my old system I used the numeric 1,2,3..etc sequence. And then it was very > easy to get sortable lists of products by those fields. In my old system I > have each enumeration in its own table, so that was not a poblem with > primary key. But in ofbiz it is the one table of all the enumerations that > is why the problem has arised. > > > Adrian Crum wrote: >> >> I have used unique IDs that have some kind of semantic meaning. For >> example: >> >> enum_id enum_desc >> ----------- --------- >> MATL_TYPE_1 Brick >> MATL_TYPE_2 Paper >> MATL_TYPE_3 Sand >> >> METAL_TYPE_1 Gold >> METAL_TYPE_2 Platinum >> METAL_TYPE_3 Silver >> >> -Adrian >> >> >> MrJohnBrown wrote: >>> Hi Guys, >>> >>> I have a number of the enumerations sets of different types but the >>> problem >>> is that they have same ids. Example: >>> >>> >>> http://www.nabble.com/file/p11946308/enum.jpg >>> >>> But in the ofbiz enumeration entity enum_id is the only primary key, so >>> I am >>> not able to load those sets as is. Will it no be a problem with ofbiz >>> dependant stuff if I change the primary key of Enumeration entity to be >>> a >>> composite key which will include two fields (enum_id, enum_type_id) ? >>> Please, let me know if it can cause any problems to the legacy data >>> model? >>> >>> Thanks for any replies. >> >> > > -- View this message in context: http://www.nabble.com/Enumeration-entity-Primary-Key-tf4200307.html#a11947535 Sent from the OFBiz - Dev mailing list archive at Nabble.com.