User filter in Record from a different table

Question

Hi,
I have created a record for "Students". It's an entity-backed record. In the record type, I have chosen "students" as data store entity. In the record
list view, I have used 'grid' list style and displayed the student skill which I have stored in another table "student skills". I have used the "Student Id" (Primary Key)
in the "students" table as the foreign key in "student skills" table to retrieve the data. I am trying to create a user filter to search the "Students"
record based on "student skills". Is it possible to create this user filter? Can anyone suggest me how to achieve this?

aloks0189 · Answer

I agree with alexp750 view will be the best choice, however you can have one more possibility, if you have related student and skill CDT using nested CDT then you can create a queryEntity or queryRule on the parent CDT which will retrieve all the rows with relationship and you can pass filtering value there as skill. But as per Appian best practices I will not recommend you to go for Nested CDT option, so view could be the best option.