Forums

Filter on linked entity yes/no attribute Cancel The title field is required!

1. geoff.white

   

   31 posts
   Registered:
   27 Jan 2015
   16 Aug 2016

   Link to this post

   I've got a CRM Grid View displaying a Yes/No (Two option field in CRM) on a linked entity and I cannot filter it.
   
   I've tried various methods including:
   Contains: No
   StartsWith: No
   EqualTo: No
   IsNull
   NotIsNull
   
   Any suggestions? 
2. Missing user

   
   Answered

   17 Aug 2016 in reply to geoff.white

   Link to this post

   Hi Geoff,
   
   Please use 0 or 1 to filter based on any Boolean field . 0 represents false and 1 represents true.
   
   Thanks
   Syed
3. geoff.white

   

   31 posts
   Registered:
   27 Jan 2015
   17 Aug 2016 in reply to Missing user

   Link to this post

   Syed,
   
   It doesn't filter with 0 or 1 (equalTo/notEqualTo).
   
   This is a field from a linked entity.
   
   Geoff
4. Missing user

   
   18 Aug 2016 in reply to geoff.white

   Link to this post

   Hi Geoff,
   
   Can you please post your fetch xml or email it to me to review. Also, can you please check the parent and linked entity are not using N:N relationship because N:N is not supported except in CRM Sub Grid Views.
   
   Thanks
   Syed