Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Sorting and Filtering Data > 5.7 Creating a Filter with Advanced Exp...

5.7 Creating a Filter with Advanced Expressions

You can accomplish a lot with basic filters, but sometimes you need more advanced filters containing functions or more complex logic. For these cases, you can create an advanced filter. Advanced filters can be created in the Query Builder or the Filter and Sort task.

Here is a portion of the Bookings data table. This example uses the SUBSTR function in the Query Builder to select rows where the CustomerID starts with the letters "DE." To create a query, click the data icon in the Project Tree or Process Flow and select Tasks Data Query Builder from the menu bar. This opens the Query Builder with the Select Data tab on top. Select the columns that you want in the query result. Then click the Filter Data tab. For this example, select all columns.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint