Dear Sir,
Second Question: How do I get ${customerAddress} from
'AkmCustomerAddress' table in list field....when the list is finding
the table named "AkmCustomer".
regards
Avijit
On Mon, May 23, 2022 at 2:34 PM Jacques Le Roux
<[email protected]> wrote:
>
> Hi Avijit,
>
> I did not read all the details. Are you looking for "dependent drop-downs"?
> If yes, you may have a look at
> https://demo-trunk.ofbiz.apache.org/example/control/FormWidgetExamples#DropDownFieldsExampleForm_dependendDropDownFields_title
>
> HTH
>
> Jacques
>
> Le 23/05/2022 à 10:31, Avijit Bose a écrit :
> > Dear Sir,
> > My customer entity is as follows:
> > ---------------------------
> > <entity entity-name="AkmCustomer"
> > package-name="com.akm.ofbiz.import" title="Customer Entity">
> > <field name="customerId" type="id"><description>primary
> > sequenced ID</description></field>
> > <field name="customerTypeId" type="id"></field>
> > <field name="companyName" type="name"></field>
> > <prim-key field="customerId"/>
> > </entity>
> > --------------------------
> > Then I have a customer address entity as follows:
> > ----------------------------
> > <entity entity-name="AkmCustomerAddress"
> > package-name="com.akm.ofbiz.import" title="Customer Address Entity">
> > <field name="customerAddressId" type="id"><description>primary
> > sequenced ID</description></field>
> > <field name="customerId" type="id">
> > <field name="customerAddress" type="name"></field>
> > <field name="shippingAddress" type="name"></field>
> > <prim-key field="customerAddressId"/>
> > </entity>
> > ----------------------------
> >
> > I have find form as follows. This find is from "AKMCustomer" entity.
> > -------------------------------------------
> > <form name="FindCustomers" type="single"
> > target="FindCustomers" default-entity-name="AkmCustomer">
> > <field name="noConditionFind"><hidden value="Y"/></field>
> > <!-- if the above "noConditionFind" field name isn't there
> > then with all fields empty no query will be done -->
> > <field name="customerId" title="${uiLabelMap.customerId}">
> > <drop-down allow-empty="true"
> > current-description="">
> > <entity-options
> > description="${customerId} - ${customerAddress}"
> > key-field-name="customerId" entity-name="AkmCustomer">
> > <entity-order-by
> > field-name="customerId"/>
> > </entity-options>
> > </drop-down>
> > </field>
> > <field name="customerContactPerson"
> > title="${uiLabelMap.customerContactPerson}"><text-find/></field>
> > <field name="searchButton" title="${uiLabelMap.CommonFind}"
> > widget-style="smallSubmit">
> > <submit button-type="button"
> > image-location="/images/icons/magnifier.png"/>
> > </field>
> > </form>
> > -------------------------------------------
> > Request question 1: How do I get the '${customerAddress}' value from
> > 'AkmCustomerAddress' entity in the above drop down list with
> > 'customerId' as the key value?
> >
> > Then I have list form as follows corresponding to the above find form:
> > -------------------------------------------
> >
> > <form name="ListCustomers" type="list" list-name="listIt"
> > paginate-target="FindCustomers"
> > default-entity-name="AkmCustomer" separate-columns="true"
> > odd-row-style="alternate-row"
> > header-row-style="header-row-2"
> > default-table-style="basic-table hover-bar">
> > <actions>
> > <!-- Preparing search results for user query by using OFBiz
> > stock service to perform find operations
> > on a single entity or view entity -->
> > <service service-name="performFind" result-map="result"
> > result-map-list="listIt">
> > <field-map field-name="inputFields" from-field="eximCtx"/>
> > <field-map field-name="entityName" value="AkmCustomer"/>
> > <field-map field-name="orderBy" from-field="parameters.sortField"/>
> > <field-map field-name="viewIndex" from-field="viewIndex"/>
> > <field-map field-name="viewSize" from-field="viewSize"/>
> > </service>
> > <field name="customerId" title="${uiLabelMap.customerId}"
> > sort-field="false"><display/></field>
> > <field name="customerTypeId" title="${uiLabelMap.customerTypeId}"
> > sort-field="false"><display/></field>
> > <field name="companyName" title="${uiLabelMap.companyName}"
> > sort-field="false"><display/></field>
> > <field name="customerAddress" title="${uiLabelMap.customerAddress}"
> > sort-field="false"><display/></field>
> > </form>
> > -------------------------------------------
> > Request question 2: Again how do I get the 'customerAddress' field
> > value in the list with 'customerId' as the key?
> >
> > In short how do I get a value from a second entity in a dropdown and
> > list form field with a first entity key value as a reference in the
> > second table.
> >
> > regards
> > Avijit Bose
>
