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.