Re: Is there any way to get the values from an entity without passing all the primary key values to the service which is implemented in minilang?

[Rashko Rejmer <rr...@iguanait.com>]

You can do that as Jacques proposed:

<set field="lookupMap.productId" from-field="parameters.productId"/>
<find-by-and entity-name="ProductAssoc" map-name="lookupMap"
list-name="productAssocs"/>

you will get list(productAssocs) with all records from ProductAssoc
entity that corespond to this expression:
 - ProductAssoc.productId = parameters.productId

Regards,
Rashko Rejmer

On Fri, 2007-12-21 at 04:55 -0800, Kishore.M wrote:
> Hi all,
> Following is the entity model for the entity ProductAssoc
> 
> <entity entity-name="ProductAssoc"
>             package-name="org.ofbiz.product.product"
>             title="Product Association Entity">
>       <field name="productId" type="id-ne"></field>
>       <field name="productIdTo" type="id-ne"></field>
>       <field name="productAssocTypeId" type="id-ne"></field>
>       <field name="fromDate" type="date-time"></field>
>       <field name="thruDate" type="date-time"></field>
>       <field name="sequenceNum" type="numeric"></field>
>       <field name="reason" type="long-varchar"></field>
>       <field name="quantity" type="floating-point"></field>
>       <field name="scrapFactor" type="floating-point"></field>
>       <field name="instruction" type="long-varchar"></field>
>       <field name="routingWorkEffortId" type="id"></field>
>       <field name="estimateCalcMethod" type="id"></field>
>       <field name="recurrenceInfoId" type="id"></field>
>       <prim-key field="productId"/>
>       <prim-key field="productIdTo"/>
>       <prim-key field="productAssocTypeId"/>
>       <prim-key field="fromDate"/>
>       <relation type="one" fk-name="PROD_ASSOC_TYPE"
> rel-entity-name="ProductAssocType">
>         <key-map field-name="productAssocTypeId"/>
>       </relation>
>       <relation type="one" fk-name="PROD_ASSOC_MPROD" title="Main"
> rel-entity-name="Product">
>         <key-map field-name="productId"/>
>       </relation>
>       <relation type="one" fk-name="PROD_ASSOC_APROD" title="Assoc"
> rel-entity-name="Product">
>         <key-map field-name="productIdTo" rel-field-name="productId"/>
>       </relation>
>       <relation type="one" fk-name="PROD_ASSOC_RTWE" title="Routing"
> rel-entity-name="WorkEffort">
>         <key-map field-name="routingWorkEffortId"
> rel-field-name="workEffortId"/>
>       </relation>
>       <relation type="one" fk-name="PROD_ASSOC_CUSM"
> rel-entity-name="CustomMethod">
>         <key-map field-name="estimateCalcMethod"
> rel-field-name="customMethodId"/>
>       </relation>
>         <relation type="one" fk-name="PROD_ASSOC_RECINFO"
> rel-entity-name="RecurrenceInfo">
>             <key-map field-name="recurrenceInfoId"/>
>         </relation>
>     </entity>
> 
> 
> I want to implement a service in minilang.In that service I want to get the
> corresponding values from the entity "ProductAssoc" by passing only
> "productId" without passing all the primary keys.
> Is there any way to do that?
> 
> please help me out.
> 
> regards,
> Kishore.M
>