I am creating an app where there should be a list view of users of that org. I have created a custom object which looks up to the User object. Based on some criteria of the current logged in user for example gender of the user(custom field in custom object), I want a list view to show users of that gender only. And there can be other criteria too.

So what are the ways to achieve this type of scenario?

I am still new to Salesforce. ;)

1 Answer 1


Unfortunately, you can not compare the value of two fields in the list view filter, It only supports values. But, you can create a list using a custom lightning page and custom lightning component with lightning-datatable. You will need to query the data based on the logged-in users' gender.

You have two options for implementation, Aura, and LWC.

Check out the lightning datatable docs Aura | LWC

  • okay thanks. You sure there is no declarative approach? Jun 9, 2020 at 8:30
  • yes. as of now. @RijulGanguly Jun 9, 2020 at 9:00
  • okay. I'll look at lwc. Jun 9, 2020 at 10:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.