Dashboard Filtered based on the user role.
Country: ["USA", "CANADA", "MEXICO", "CHINA", "INDIA"]
Company: ["ALPHABET", "GOOGLE", "APPLE"]
Role/Dashboard Filters | Company | Country |
---|---|---|
Admin | All Companies | All Countries |
Editor | All Companies | USA, CANADA, MEXICO |
Viewer | Alphabet | USA |
<code>SELECT "name" FROM "public"."countries" WHERE isEnabled=true</code>
fetches active country names.<code>columnName</code>
specifies the field in the query result to use as filter values.