Dataset filter owner with code

Ask the community
,
1

Hi everyone,
I need to filter the owner user from the dataset using the code cause then I need to query the field.

Can you help me, please?

Thanks in advance as always

2

Hi, you can do this the dataset filter in the setting panel (filter->owner, see image below) or with [setFilter API ]( Avi Guzansky 1:31 PM (4 minutes ago) to me Dataset - Velo API Reference - Wix.com)
(hope this helps, not sure this is what you meant, if not, need more details…)
thanks!

363×551 33.6 KB

3

Hi, @ayeletgv
Yes, I know, but I need a code because I have to do a query with the result field. So You can write me or indicate the code to filter owner user in the dataset?

4

If using the datasets own settings is not suitable, then simply do what Ayelet suggested and use the Wix Dataset setFilter function, you will find code examples and full info about it from her link.
https://www.wix.com/corvid/reference/wix-dataset.Dataset.html#setFilter

5

Hi, @givemeawhisky

Tthank You, I’ve seen this API, but I don’t understand how to insert the filter “on the user owner”. Could you help me more please?

6

@info60119

Just use Wix Users to get their id as they should already be logged in.
https://www.wix.com/corvid/reference/wix-users.User.html#id

See this previous post for an example that uses email address.
https://www.wix.com/corvid/forum/community-discussion/filtering-a-dataset-by-user-not-owner

Also, about dataset fields.
https://support.wix.com/en/article/about-your-database-collection-fields#system-fields