CURRENT_USER_IN_GROUP

Parameter	Type	Description
`organization`	string	the name of the organization
`group_id`	string	the id of the group

Returns: string

Example

query:

SELECT animal_type,
       breed,
       age_upon_outcome,
       sex_upon_outcome
  FROM austin_animal_center_age_at_outcome
  WHERE CURRENT_USER_IN_GROUP ("ddw-doccorp/members")

siyeh/austin-animal-center-statistics-oct-1-2013-to-dec-7-2017 Run query Copy code

SELECT animal_type,
       breed,
       age_upon_outcome,
       sex_upon_outcome
  FROM austin_animal_center_age_at_outcome
  WHERE CURRENT_USER_IN_GROUP ("ddw-doccorp","members")

siyeh/austin-animal-center-statistics-oct-1-2013-to-dec-7-2017 Run query Copy code

results:

animal_type	breed	age_upon_outcome	sex_upon_outcome
Dog	Spinone Italiano Mix	6 years	Neutered Male
Dog	Spinone Italiano Mix	7 years	Neutered Male
Dog	Miniature Poodle Mix	2 years	Neutered Male
Dog	West Highland Mix	3 years	Spayed Female
Dog	Cavalier Span Mix	7 years	Intact