| |
|
|
5
|
For the three tables MC_Header, Chassis,
MC_Detail where MC_Header is carried
in MC_Detail, and Chassis table is
the relator, how can I Filter data
in the Relator for a passed parameter?
|
| |
|
| |
Design
|
| |
Create
a custom UDM with Chassis as a relator
to the MC_Header node. Add a predicate
to filter the records from chassis
to limit by for the customer.
|
| |
Steps
to achieve
|
| |
 Click
on the create custom UDM (name is
as "addRelator").
|
| |
Give
the display name as Add New Chassis
to MC_Header (bottom part of the page).
|
| |
Select the addRelator node and click
on the add child toolbar. |
| |
Enter the parameter to be passed,
here it is "customerId". |
| |
Give any name to the node (say MCHeader). |
| |
Select action type as Insert only. |
| |
Select the table as "MC_Header" and
save. |
| |
Select the MCHeader node and click
on the add relator. |
| |
Enter the relator node name "AssetList". |
| |
Select the table as Chassis. |
| |
zDE
will list the intermediate tables
(linking) tables between MC_Header
and Chassis. (i.e. it will list the
MC_Detail table). |
| |
Select the MC_Detail table and click
on table of check boxes and save the
UDM. |
| |
Click on create predicate enter any
name "custpred" and description "Limit
by customer". |
| |
Select the check box with table as
Chasssis.Id and press add. |
| |
In
the where clause section of the predicate
(I.e. Chassis_customer_Company_Id =
|
| |
Enter the parameter in hooks (I.e.
?custId?). |
| |
The
where clause should look like Chassis_customer_Company_Id
= ?custId? |
| |
Save the predicate. |
| |
Open the custom UDM (addRelator).
|
| |
Click on the relator node (Chassis). |
| |
Custpred will be listed there, select
that custpred predicate. |
| |
Save
the UDM and regenerate the HTML. |
| |
Make the UI Changes and view in the
browser. |
| |
Test
and add data. |
| |
Click
on the create custom UDM (name is
as "addRelator |
| |
|
|
6
|
For the two tables Chassis and
PSU, where ChassisId is carried in
PSU how can I add multiple children
to a parent and view them simultaneously?
|
| |
Design |
| |
Create
a custom UDM with PSU as a child to
the Chassis node. Create a list page
for PSU limited by the parameter passed
which is ChassisId. |
| |
Steps
to achieve: |
| |
Click on the create custom UDM (name
is as "addPSUtoChassis"). |
| |
Give the display name as Add New PSU
to Chassis (bottom part of the page). |
| |
Select the addPSUtoChassis node and
click on the add child toolbar. |
| |
Enter the parameter to be passed, here
it is "chassisId". |
| |
Give any name to the node (say Chassis). |
| |
Select action type as Display only. |
| |
Select the table as "Chassis" and save. |
| |
Select the Chassis node and click on
the add Child toolbar. |
| |
Enter the child node name "AddPSU". |
| |
Select the table as PSU. |
| |
Bind PSU.ChassisId = Chassis.Id |
| |
Create a new UDM list UDM, which takes
chassisId as the parameter. |
| |
Bind the parameter to PSU.ChassisId |
| |
Make the above HTML into two framesets
and assign the second UDM in the lower
frameset. |
| |
Now once the user enters the PSU for
a particular chassis , refresh the lower
frameset so that it
retrieves the latest records. |
| |
|
| |
|
