{"version":"1.0","provider_name":"Sage CRM \u2013 Tips, Tricks and Components","provider_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm","title":"Limitation on SearchSQL Property - Sage CRM \u2013 Tips, Tricks and Components","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"34GhR1quqr\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/20\/limitation-on-searchsql-property\/\">Limitation on SearchSQL Property<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/20\/limitation-on-searchsql-property\/embed\/#?secret=34GhR1quqr\" width=\"600\" height=\"338\" title=\"&#8220;Limitation on SearchSQL Property&#8221; &#8212; Sage CRM \u2013 Tips, Tricks and Components\" data-secret=\"34GhR1quqr\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/* ]]> *\/\n<\/script>\n","description":"Did you ever come across the problem of SQL criterion not getting fired while dealing with Search Select Advance filed in CRM? If yes, then here is what you must have a look at: 1. Check whether the SSA field has been customized in ASP pages or on Create Script then check with SQL condition\u2026 Read More &raquo;"}