Chassis
and PSU are the two table where Chassis ID is
carried in PSU table as a foreign key. Can I
see all the PSUs added for one Chassis?
Design
Create a custom UDM with PSU as the vector node and child
to the Chassis node
Steps to achieve
Click
on the create custom UDM (name is as "viewPSUforchassis").
Give
the display name as PSUs for Chassis.
Add
a parameter as chassisId.
Select
the viewPSUforchassis node and click on the add
child toolbar.
Give
any name to the node (say Chassis).
Select
action type as Display only.
Bind
the chassis.Id - chassisId (parameter passed).
Select
the table as "Chassis" and save.
Select
the Chassis node and click on the add child.
Name
it as PSU (Note: No white spaces, underscores
allowed here).
Make
it as Display only.
Check
the vector node radio button.
Select
the PSU table.
Select
the correct binding between both the tables i.e.
: Chassis.id =PSU.Chassis_id
Save
the UDM , preview the HTML and save the HTML.
Make
the UI Changes and view in the browser by passing
the chassisId to be viewed.
Check
the output
4
After
designing a custom UDM with Time_avl_detail as
a node and add a predicate to show the timings
available in the future for Time_Avl_Detail table,
how can we provide Query to check if the Device
is available in future (an Example for simple
predicate)?
Steps
to achieve:
Click
on the create custom UDM (name is as "viewStatus").
Give
the display name as View booking device details
(bottom part of the page).
Select
the viewStatus node and click on the add child toolbar.
Give
any name to the node (say Timeavailable).
Select
action type as display only.
Select
the table as "Time_Avl_Detail" and save.
Click
on create Predicate, Enter any name and description
to the predicate.
Check
the check box "Time_Avl_Detail.Id".
Select
the check box which shows as Time_Avl_Detail .Start_date
Select
the operator as grater than ">".
Enter
"sysdate" in the text box , click OK.
Now,
open the custom UDM(viewStatus) and click the node
Timeavailable.
It
list you the Predicate which was created.
Check
the predicate and save.
Save
the UDM , preview the HTML and save the HTML.
Click
on the create custom UDM (name is as "viewPSUforchassis").