Posted by
jonwimp on
URL: http://ofbiz.116.s1.nabble.com/entity-question-FK-join-question-tp144397p144402.html
> No, you can't. Or at least, be careful if you remove values from there.
> For example all the currencies are also stored in that entity and if you
> use the system to process orders you'll need at least one currency.
Christopher said:
>>> I only want to join MyEntity to the Uom entity for Time/Frequency Uom's as
>>> the other Uom's (e.g. Energy) don't make much sense for me.
Yeah, I was wondering what kind of ERP system was being planned that didn't require currencies.
I can't think of any way to create a constraint to force joins to a subset of Uoms. Application
level is the best I can imagine.
Perhaps create another entity, say LimitedUoms, that maps to subset of Uoms? Link MyEntity to
LimitedUoms.
>> If you just don't want users modifying the Uom entity at all, you can
>> disable every part in OFBiz that performs updates to that entity.
>>
>
> This doesn't make sense to me...
Christopher said:
>>> I don't want users to modify the data in the Uom Entity
Jonathon
Jacopo Cappellato wrote:
> Christopher,
>
> Jonathon -- Improov wrote:
>> Christopher,
>>
>> You can delete all Uoms of uomTypeId not equal to TIME_FREQ_MEASURE.
>> Does that do it?
>>
>
> No, you can't. Or at least, be careful if you remove values from there.
> For example all the currencies are also stored in that entity and if you
> use the system to process orders you'll need at least one currency.
>
>> If you just don't want users modifying the Uom entity at all, you can
>> disable every part in OFBiz that performs updates to that entity.
>>
>
> This doesn't make sense to me...
>
> Jacopo
>
>> Jonathon
>>
>> Christopher Snow wrote:
>>> Jonathon,
>>>
>>> I was referring to the Uom Entity in ofbiz common. I don't want users
>>> to modify the data in the Uom Entity, just to be able to select from the
>>> values Uom's where uomTypeId=TIME_FREQ_MEASURE .
>>>
>>> <MyEntity ..
>>> <field name="proximityDate" ..
>>> <field name="proximityDateUomId" ..
>>> ..
>>>
>>> I only want to join MyEntity to the Uom entity for Time/Frequency Uom's
>>> as the other Uom's (e.g. Energy) don't make much sense for me.
>>>
>>> I was hoping not to do this at the service/application layer as I would
>>> need to specify this constraint in multiple places.
>>>
>>> Sorry for the confusion!
>>>
>>> Many thanks,
>>>
>>> Chris
>>>
>>>
>>>
>>> On Thu, 2007-02-08 at 15:54 +0800, Jonathon -- Improov wrote:
>>>> Christopher,
>>>>
>>>> Services/forms/etc, aka application level/layer.
>>>>
>>>> After all, you need to constrain inputs from the end-user first.
>>>>
>>>> Jonathon
>>>>
>>>> Christopher Snow wrote:
>>>>> I have an entity that is related to the Uom entity, but only where
>>>>> uomTypeId=TIME_FREQ_MEASURE
>>>>>
>>>>> Is it possible to set this constraint at the entity level?, or
>>>>> should I create an entity view for this limited subset?, or
>>>>> should all my services/forms/etc constrain the uomTypeId?
>>>>>
>>>>> Many thanks,
>>>>>
>>>>> Chris
>>>>>
>>>>> --This message has been scanned for viruses and
>>>>> dangerous content by MailScanner, and is
>>>>> believed to be clean.
>>>>>
>>>>>
>>>>> --No virus found in this incoming message.
>>>>> Checked by AVG Free Edition.
>>>>> Version: 7.5.432 / Virus Database: 268.17.30/674 - Release Date:
>>>>> 2/7/2007 3:33 PM
>>>>>
>>>>>
>>>>
>>>
>>>
>
>
>