Hi all,
I have a table that contain all competences and i have in my canvas app a search page that contain multicriteria logic where i can search users that match with competences I've selected.
Competences are splitted in 3 catégories
Product, sector, transverse
When I'm selecting a product competence, I collect the selection in a collection named colProductSelected,
When I'm selecting a sector competence, I collect the selection in a collection named colSectorSelected
When I'm selecting a transverse competence I collect the selection in a collection named colTransverseSelected
Now, when I'm clicking in the Search button, I want to retrieve in the competence table all the competences that are in the 3 collections I've created.
Is that the correct way? If yes, how can I do that?
Thanks for help
Use Collect or ClearCollect (there are better ways to do this) to create a new collection with all the ones you created earlier. In the database world, this is called a JOIN operation. In this link you can get a better idea of how to get the expected result.
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 1