How to filter and search values in Oracle Visual Builder collections whether they are ServiceDataProvider or ArrayDataProvider based. Related blog - blogs.oracle.c...
What if you want to filter with multiple attributes, but those attributes are optional? Like in this example, if you want to be able to search by just name, by name and manager, or by just manager. Is there a way to do that?
@ShayOracle
2 жыл бұрын
See the blog about compound conditions - blogs.oracle.com/shay/post/filtering-data-in-visual-builder-lists-and-tables-revisited
@jennabarrett4341
2 жыл бұрын
@@ShayOracle I did read that, and it explains what to do if you want to get results that include null, but not what to do if you want to search and a search parameter may be null. If you set up a search "if name= $variables.name AND manager=$variables.manager" but $variables.manager is null, it won't work. And you can't check for $variables being null using the filterCritereon.
@ShayOracle
2 жыл бұрын
@@jennabarrett4341 please post questions on our forum: community.oracle.com/customerconnect/categories/oci-visual-builder
@leasaliba3686
2 жыл бұрын
Hello Shay, Please can you show us in a video how to use pagination (numbers at the bottom of the table) for an SDP array? Thanks!
@ShayOracle
2 жыл бұрын
The table has built in pagination - blogs.oracle.com/shay/post/table-pagination-and-scrolling-in-visual-builder-explained which is much more natural user experience than having to press next 10 every time.
@cricthugzz
Жыл бұрын
Hello Shay, when we try to customise the action chain of sdp variable, filtering does not work. Please help.
@ShayOracle
11 ай бұрын
Are you handling the filtering in your code correctly? Post on the visual builder forum with further info on what doesn't work.
@Ramikelesli
Жыл бұрын
can we show loading while fetching data
@ShayOracle
Жыл бұрын
Yes - there is a default table loading effect in Redwood, or you can show a popup - blogs.oracle.com/shay/post/improving-perceived-performance-for-visual-builder-pages
@AyushSharma-xe8hz
3 жыл бұрын
Can we filter table populated by ADP variable ?
@ShayOracle
3 жыл бұрын
Yes - the filterCriterion for ADP is defined under the requestTransformOperations parameter in the call REST action.
@AyushSharma-xe8hz
3 жыл бұрын
@@ShayOracle thank you very much Shay. It worked.
@shyamasundarpatil5243
2 жыл бұрын
@@ShayOracle Can you please help me on how we can filter using ADP, Any links will highly appreciated
@ShayOracle
2 жыл бұрын
@@shyamasundarpatil5243 the filterCriterion for ADP is defined under the requestTransformOperations parameter in the call REST action.
Пікірлер: 16