Hi people,Could you help me please.
I need to hide documents
How to hide documents that have a status “lost” and a role “Marketplace” for my view?
Thanks you very much for help me.
Subject: Selection formula
You’re not that clear whether you want to hide only those that have both, or those that have either, so one of these two would work
!(status =“lost” & role =“Marketplace”)
!(Status=“lost” | role = “Marketplace”)
Subject: two users
apologies for not clarifying my problem.only two users can not see the documents with status “Marketplace”
thanks you
Subject: readers field
Create a group and add all users to the group except for the 2 users “John Doe/ACME” & “Jane Doe/ACME”.
Add the group to the db’s ACL
Create a Role in your db’s ACL “[SeeAllDocs]”
Add the Role to the group
Add a Readers field to your form with the following formula:
users := “John Doe/ACME” : “Jane Doe/ACME”;
add := @If(Status = “Marketplace”; “”; users);
@Unique(@Trim([SeeAllDocs] : add))
After adding the field to your form you will need to refresh all docs that use the form.
You may want to make “users” a field on your documents or link it to a profile document in your db or a group in your DD so that you can add remove names rather than having to modify the form each time.
Subject: roles are user specific
roles are specific to the user ID to which the role belongs but the views are recalculated on the server which results in a sort of dynamic type of view and this will not give you consistent results. Also, @UserRoles does not work in select statements so if it’s not working for you then this is a clear indication why. Use a Readers field instead. This is the only sure fire way of hiding a document, although I am not sure how you could effectively tie this to a field on the document as well.