IF i try this query i get expected result [ SELECT Id, OutOfOfficeMessage,Alias FROM User ]
but i need result with this query and it doesn't give results , but it has to be show results
[ SELECT Id, OutOfOfficeMessage,Alias FROM User WHERE OutOfOfficeMessage != null ]
Note : OutOfOfficeMessage is text field in User Object
7 réponses
Instead go for
SELECT StartDate, EndDate, Id ,IsEnabled, Message, UserId FROM OutOfOffice
This will return the exact result