Oracle SaaS Stories: Creating a Custom App Extension with Visual Builder | Part Three: Filtering Data

Next step after what we posted here is how to implement a mechanism to filter results. Taking a look to the REST APIs we can notice that the query parameter q is the one that can help us to implement what we are pretending:

So the q parameter works as a field1<operator1>value1;fieldn<operatorn>valuen expression that can be passed as a parameter to the REST service. Let’s hands on.

Create a global variable for the search criteria:

Drag and drop an InputText onto the Page Structure pane:

Create a new Event for storing in a variable the value of the InputText when it changes:

• 

• 

• 

Drag and drop a Button same way:

Create new Event and implement action chain:

• 

• 

• 

• 

• 

In the success branch of the Rest call put a Call Component Method and select the refresh method of the table object:

In the failure branch put a Fire Notification Error and configure it as follows:

Hope it helps! 🙂