Exercise 04.01 - Filter Items with contains, plus Count
Create the following:
-
Create a request that retrieves the junction box panels in As-Built project, where the panel name contains 'JB'. Include the number of panels and sort by the panel name.
-
Modify the request and select only the following Junction Box properties: Id, Panel Name, panel sub-category, panel manufacturer.
-
Add a condition so that you only get the 'Fieldbus plug-and-socket JB' sub category.
Exercise 04.02 - Filter Items with Contains two search conditions
This exercise uses a Contains with multiple search condition.
-
Create a request that retrieves all Instruments in Project ('As-Built'), where their Instrument Name contains 'FT', and their Loop Name contains '221'.