https://www.growthbook.io/ logo
#announcements
Title
# announcements
m

modern-application-84664

11/16/2022, 12:12 PM
Hello 🙌 Could you help to add sql filtering in where clause in dimension? Cause now we can do that only in metrics not in dimensions Example below
Copy code
where exp_name = '{{ experimentId }}'
       and as_of_date between timestamp'{{ startDate }}' and timestamp'{{ endDate }}'
1
f

future-teacher-7046

11/16/2022, 1:57 PM
Just added a GitHub issue for this feature request. It shouldn't be too hard for us to add https://github.com/growthbook/growthbook/issues/739
❤️ 1
m

modern-application-84664

11/16/2022, 2:31 PM
Thanks, it will allow us to retrieve not whole table rows. Just for certain experiments.
f

future-teacher-7046

11/16/2022, 2:33 PM
Depending on how your data is structured, we also support dimensions directly in the experiment assignment queries. https://docs.growthbook.io/app/dimensions#experiment-dimensions
❤️ 1
17 Views