I want to filter the document based on reference which is a relationship with other table 'references'. reference field can be nullable
TL;DR
If you have document security enabled with read access for certain users, they will only be able to fetch documents they have access to. It is not currently supported to filter List Documents with relationships.
To use OR between multiple queries instead of AND, you will need to make separate API calls.
There is no direct workaround to filter relationships.
If you want to show the guests of the person who is currently logged in, you will need to find another approach as it is not supported.
You can filter documents based on a reference field that is a relationship with another table 'references'. The reference field can be nullable, but there is no solution providedNot supported
Yet
then how can I do that, is there any work around?
I have to only show the guests of the person who is currently logged in
is there any other way? Please there must be something we can do if we can't able to filter the relationships
atleast tell me the how to use OR between multiple queries instead of AND
Not supported yet. You would need to make separate API calls
If you have document security enabled and documents are configured with read access for certain users, people will only be able to fetch what they have read access to
Recommended threads