Hi guys,
Was wondering if you could guide me on how to filter a aggregate via a foreign key?
For example, I have user.name as a the filter I want however the table only has CreatedbyID which links to the user table. So when I filter by my search keyword it's obviously asking for a different data type. But I all I want to search by user.name for the CreatedByID field hence why I don't want the conversation to happen.
Essentially I want to search keyword on the below screenshot or any other foreign key in that table by the actual name and not the ID on the search bar:
Hi Salim,
You need change these filters. Unifying into a only one filter and using an OR operation
Like this:
InectoClientRole.RoleTitle like "%"+ Session.ClientRole_SearchKeyword +"%" or User.Name like "%" + Session.ClientRole_SearchKeyword + "%"
Pedro Costa wrote:
Thanks seems to do the trick. Are there any limits of how many or I can use?
Check if in your aggregate already exists a join with user table like this, if not, click "Add Source" and add the User table.
After this, go to filter tab and change your filter to compare using by the attribute User.Name
Note: Change the operation = to like
Regards
Hi Pedro,
Thanks for your reply.
I have tried that before however the search doesn't seem to return the record when attempting it this way.
Here the is the record
But when I search:
Any idea?
No, it's like writing a SQL query
Thanks and have a great day