Hi there,
In perspective you need to call a named query.
In your case you have to create a named query with parameter “Filter” for instance.
Then you replace ‘%{Root Container.txtlistJobsFilter.text}%’ with :Filter, you can also use drag and drop.
When you call your query in perspective, you will see Filter under parameters. You can have it fixed value, expression or binding.
Please note I didn’t check query syntax, I am just showing a method.
Hope this helps!