Dear Avijit,
<field name="customerId">
<drop-down allow-empty="true">
<entity-options entity-name="AkmCustomer"
key-field-name="customerId" description="${customerId} - ${customerAddress}
">
<entity-constraint name="customerId"
env-name="customerId" />
<entity-order-by field-name="customerId"/>
</entity-options>
</drop-down>
</field>
Above is the overall signature you can pass entity name and constraints as
you wish.
Hope that helps!
Best Regards,
--
Rishi Solanki
*CTO, Mindpath Technology*
Intelligent Solutions
cell: +91-98932-87847
LinkedIn <https://www.linkedin.com/in/rishi-solanki-62271b7/>
On Mon, May 23, 2022 at 4:45 PM Avijit Bose <bose.avi...@gmail.com> wrote:
> 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
> <jacques.le.r...@les7arts.com> 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
> >
>
