Generic SQL Error while using Query Expression
Check in the query expression "Contains" operator used or not. If it then have to replace it as "Like" operator.
Contains not working in 365 because generic SQL error occurred because of full text not enabled in the table. It is only enabled in KBArticleEntity.
So we have used like operator but like we have to manually add % infront of value otherwise data not coming.
https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/developers-guide/gg327700(v=crm.8)#members
Check in the query expression "Contains" operator used or not. If it then have to replace it as "Like" operator.
Contains not working in 365 because generic SQL error occurred because of full text not enabled in the table. It is only enabled in KBArticleEntity.
So we have used like operator but like we have to manually add % infront of value otherwise data not coming.
https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/developers-guide/gg327700(v=crm.8)#members
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.