In the example below a local variable was created for orders WebScreen called “searchfilter” which was set as the Search inputs Variable.
There was an Orders Entity and a Customers Entity.
The text below is an aggregate filter checking for all the orders with customer names like the text input into the search box. Remember the “searchfilter” was set as a local variable for the Orders Entity.
Customer.Name like "%" + SearchFilter + "%"
Also because the Orders Entity and the Customers Entity were separate Entities a source was added for the Customers to link the tables so the customer Entity could be found.
The aggregate that had these setting was the “GetOrders” aggregate which was used in the Orders WebScreen preparation.