About marilyncugal

marilyncugal · ‎10-14-2021

Check the type of the fields. e.g. | eval type_of_field = typeof(block_public_acls) If it is "String", then you can wrap the right side of the condition with quotation marks. | eval perm=case(block_public_acls="true" AND block_public_policy="true" AND ignore_public_acls="true" AND restrict_public_buckets="true","Private",1=1,"Public")

marilyncugal · ‎10-12-2021

This might sound weird but if the user account of that employee has been deleted, try recreating it and then login using that account. Then you will see all the knowledge objects under their account. After that, change the permission of those KOs app/global. Logout and login as admin. Reassign those KOs to an existing/active user. Lastly, you can delete the user account of the resigned employee. OR, you can check savedsearches.conf in the backend and copy those which are under the resigned employee's account.

Posts	2
Solutions	1
Karma Given	0
Karma Received	2
Member Since	‎10-15-2019

Online Status	Offline
Date Last Visited	‎03-18-2022 04:45 AM

Re: wrong results for case statement with AND

Re: employee left company reports owned by him not...

Join the Conversation

Re: wrong results for case statement with AND

Re: employee left company reports owned by him not...