The Integration blog covers the latest in product updates, best practices, customer stories, and more.

Try Our Advanced Filtering in Process Forms

We have recently added more powerful filtering functionalities in Forms. Previously, you were limited to combining filter conditions with Or logic only, and you couldn't filter existing filters further. Additionally, we have expanded our logging capabilities so users can see the return values of filters.

Now you can:

  • Combine filter conditions with and logic
  • Filter other filters
  • Debug Filters with Logs

Combine Filter Conditions with And Logic

When defining a filter, you can define any number of filter conditions. For example, if you have a connector call for employees at a company, you can filter the employees based on their zip code, level, or any other property in the employee json object. Previously, you could only combine filter conditions with or logic. For example, you can filter the employees with direct reports or who work at the company's California office. Now, you can combine filters with and logic. For example, you can filter the employees with direct reports and who work at the company's California office. Adding the and logic opens up many more combinations of filter conditions.

Filter Other Filters

There are some use cases where you might want to filter an existing filter. Say you have a connector with nested arrays i.e. an array of companies and each company has an array of investors. 

You can filter the connector and populate a select dropdown with the filter results. For instance, say you want to filter the companies with a founding date in the year 2010 or later. The select dropdown will display all of the companies founded in 2010 or later. You can then populate a second select dropdown based on the selected value of the first dropdown. For example, let's say the user selects a company from the first dropdown. You can then populate the second dropdown with the list of prominent investors in the selected company by 1) filtering the companies with the name equal to the selected value of the first dropdown and 2) filtering the first filter's result with the investors who invested more than X dollar amount. 

In the second screenshot below, the value is set to selectedCompany[0].investors because the result of a filter is another array. You need to access the first index of the selectedCompany filter. From there you can access the investors array. 

When setting a filter as the source of another filter, be sure the source filter is already defined in the event editor. You can easily change the order of filter blocks by using the up and down arrows in the top right corner of each filter block.

Debug Filters with Logs

Use logs to help debug and diagnose events when you get unexpected values, or to simply ensure that the filter conditions you defined result in the expected filter output. You can access logs by clicking on the Preview button and choosing the Log tab at the bottom of the Preview page. We also have logging capabilities for connectors, actions, conditions, loops, and reusable snippets.

See https://docs.oracle.com/en/cloud/paas/integration-cloud/user-processes/create-web-forms.html for more info!

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.