Step 1 – Create a View

  1. In the Navigation Library, go to Data Management and then go to Views 
  2. Click New View and call it Age View; set Primary Object to Client; click Save
  3. Click on the Fields tab and move FirstName and Age to the right-hand panel
  4. Click on the Where tab
    1. Click Add Term
    2. Set Type to Compare
    3. Under Expression 1 set Field to Age
    4. Set Operation to Greater or equal
    5. Under Expression 2 set Constant to Number 30
    6. Click Save at the top left of the screen
    7. The SQL code at the bottom of the page should look like this: select A0.COL_ID ID, A0.COL_FIRSTNAME CLIENTFIRSTNAME, A0.COL_AGE CLIENTAGE from TBL_CLIENT A0 where (((A0.COL_AGE >= 30)))
    8. Click Save at the bottom right of the page
  5. Deploy your solution; log out and log in again

Step 2 – Create a View Page

  1. Create a new page called Age View
  2. Add a Unified Store called storeAgeView
    1. In properties set Data Source Type to Business Views
    2. Set Data Source to Age View
    3. Check the List checkbox
    4. Click Save
  3. Drag a Grid into pnMain and call it grdAgeView
    1. Click on Settings and set Data Source to storeAgeView[list]
    2. Move the ClientFirstName and ClientAge columns over to the right
    3. Change the header of ClientFirstName to First Name and of ClientAge to Age
    4. Check the AutoExpand checkbox in ClientAge; click Apply
    5. In the General tab, check the Use Paging checkbox and select Row Selection in the Selection Model; click Apply and Save
    6. Click on Preview to preview your page.
    7. Click Save Page at the top left of the screen. 
    8. Attach your page to your application and deploy; log out and log in to find the page in your application
  4. The result should be this:
  • No labels