Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Work Tasks

TABLE OF CONTENTS

Use Date Time Variable to Filter Columns

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedJun 25, 2024
  • 2 minute read

Let us understand this by using a scenario. The Telematics Support Manager wants to create a view to get all the in progress and closed incidents created during the current year. To achieve this, the Manager has to follow the procedure given below:

To use Date System Variable to Filter Columns:

  1. Create a new view with the name In Progress and Closed Issues. Follow steps 1- 4 from the previous section to create a new view.

  2. In the Filter Columns field, click Show items only when the following is true radio button.

  3. Select the and radio button to add additional filters. By default, the Or button is selected.

  4. Add another filter by selecting Incident Status from the When column drop-down list.

  5. Select the is equal to filter condition from the drop-down list.

  6. Select the Value from the drop-down list.

  7. Type In Progress in the empty field.

  8. Select the and radio button to add additional filters. By default, the Or button is selected.

  9. Add another filter by selecting Incident Status from the When column drop-down list.

  10. Select the is equal to filter condition from the drop-down list.

  11. Select the Value from the drop-down list.

  12. Type Closed in the empty field.

  13. Select the And radio button to add additional filters.

  14. Add another filter by selecting CreatedDateTime from the When column drop-down list.

  15. Select the is equal to filter condition from the drop-down list.

  16. Select the Variable from the drop-down list.

  17. Select the Variable.Sys.This Year from the variable drop-down.

  18. Click the Create View button at the end of the screen.

  19. To see the view, choose the In Progress and Closed Issues view from the Create View drop-down list.

    Note: The date is stored in the UTC format in the database. Hence, the user needs to provide the date in UTC format in the filter area. Since, UTC date contains time too, the user should provide the exact time to filter with 'Equals to' operator. The date format for Microsoft SQL Server should be mm/dd/yyyy.

Related Links
TitleResults for “How to create a CRG?”Also Available in