How to Foreach to check each record and if to validate.
Question
Application Type
Reactive

Reactive Web-I wanted to validate the username in my Entity[Authorized Individual].Table structure below.

        

DepartmentAmountUsername
Accounts10Karthik
HR100Rahul
Admin1000Roshan

Now I am doing below logic where it is validating the first row i.e Karthik and rest false statement is executed.

I am new to Outsystems.

My thinking is how should I apply foreach to check each record or ListFilter.

Please help me. 

I presume that in the table AuthorizedIndividual you store User identifiers? If so then it's really simple. Just create an Aggregate with a filter on the UserId = GetUserId(). GetUserId() will contain the current logged-in user and retrieve the record(s) that matches the value. If you get a non-empty list back then you know that the current user is inside that list and you can give him access.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.