Create an interface for filtering date and time data

Create two fields that enable you to filter motors based on their manufacture date and time.
  1. Create the
    From
    field:
    1. Right-click
      MainWindow (type)
      and select
      New
      Base controls
      Date and time
      .
    2. Hover-over the object, select
      Edit
      , and enter
      FilterFromDateTime
      .
    3. In
      Properties
      , set
      Value
      to the oldest Motor manufacture date.
      TIP: Motor manufacture dates are set while creating the Motor object type and object instances.
  2. Create the
    To
    field:
    1. Right-click
      MainWindow (type)
      and select
      New
      Base controls
      Date and time
      .
    2. Hover-over the object, select
      Edit
      , and enter
      FilterToDateTime
      .
    3. In
      Properties
      , set the
      Value
      property to the newest Motor manufacture date.
      TIP: Motor manufacture dates are set while creating the Motor object type and object instances.
  3. Create labels:
    1. Create three labels by right-clicking
      MainWindow (type)
      and selecting
      New
      Base controls
      Label
      .
    2. Rename the labels by hovering-over each label, selecting
      Edit
      , and entering:
      • FilterDateTimeLabel
      • FilterFromDateTimeLabel
      • FilterToDateTimeLabel
    3. Select
      FilterDateTimeLabel
      and in
      Properties
      , set
      Text
      to
      Filter motors by manufacture date
      .
    4. Select
      FilterFromDateTimeLabel
      and in
      Properties
      , set
      Text
      to
      From:
      .
    5. Select
      FilterToDateTimeLabel
      and in
      Properties
      , set
      Text
      to
      To:
      .
  4. Make the data grid filterable:
    1. Select
      MotorDateTimeGrid
      .
    2. In
      Properties
      , create an advanced dynamic link between the
      Query
      property and
      To
      and
      From
      objects values by using a string formatter.
      Format
      SELECT * FROM Model WHERE ManufactureDate BETWEEN {0:sql_literal} and {1:sql_literal}
      {0} DynamicLink
      ProjectName
      UI
      MainWindow (Type)
      FilterFromDateTime
      Value
      .
      {1} DynamicLink
      ProjectName
      UI
      MainWindow (Type)
      FilterToDateTime
      Value
      For more information about dynamic links, see Create dynamic links.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.