Archived from the Bravo community forum (2021–2026). Some answers may refer to older versions of Bravo.
Hello community🙃
Whats up?
I have a product table that has a linked field to my user profile table. In that linked field I have a list of records, once one product can be associate to more then one user, like this:
That said, the same user id can be shown in more than one line in my product table (eg. user id "111111" on the screenshot above).
I want to list all products associated to an specific user id. What Im trying, in my GET resquest API on Bravo is:
But, unfortunately it doesnt working properly. 😭 Thats not returning all the rows where the user id is present, just one row and even then sometimes is the wrong row.
What I have to change to make it works?🤔
2 replies
Try to use something like this: REGEX_MATCH({Userid}, '${user.id}')
Thank you Valter! I tested that and at first didn`t work but I change the single quote ( ' ) for double quote("), so that stay like this: REGEX_MATCH({Userid}, "${user.id}").
It looks like worked but now the problem is that its returning just 2 rows, even if there are more than that on the table.🥺
Wrote something in this thread and want it removed? Request removal
Ask the community on Discord
This archive is read-only. New questions, office hours and product updates now happen in the Bravo Discord.
Join the Discord