{"id":13400,"date":"2016-11-16T08:50:53","date_gmt":"2016-11-16T08:50:53","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=13400"},"modified":"2016-11-16T08:50:53","modified_gmt":"2016-11-16T08:50:53","slug":"display-count-of-your-opportunities-against-company","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/","title":{"rendered":"Display Count of your Opportunities against Company"},"content":{"rendered":"

In my previous blog, I have explained how to display Current User Name under custom tab. Here, I am going to explain how to display the count of records (say Opportunities) which are in progress and assigned to me i.e. Current Logon User against respective companies using jQuery mechanism.<\/p>\n

New Stuff:\u00a0<\/em><\/strong>Event Management in Sage CRM<\/a><\/span><\/span><\/p>\n

To see the above functionality, refer the below steps.
\n1.<\/strong> Prepare a .js file with following code –
\ncrm.ready(function()<\/em>
\n{<\/em>
\n if (crm.getArg(“Key0”) == “1”) <\/em>
\n {<\/em>
\n var OppoAssignUserCount=””;<\/em>
\nif(document.getElementById(“HDNCount1”))<\/em>
\n {<\/em>
\n OppoAssignUserCount = document.getElementById(“HDNCount1”).value;<\/em>
\n if(OppoAssignUserCount==”” || OppoAssignUserCount==”null” || OppoAssignUserCount ==”undefined”) OppoAssignUserCount=”0″;<\/em>
\n }<\/em>
\n $(“td.TABOFF:contains(‘Opportunities’),td.TABON:contains(‘Opportunities’)”).text(“Opportunities (” + OppoAssignUserCount + “)”);<\/em>
\n }<\/em>
\n});<\/em>
\n2.<\/strong> Give the path of your Custom Page in the Custom Content Box. Also, copy the below code and paste it in the create script of Company Name field of \u201cCompanyBoxLong\u201d<\/strong> screen. Refer Below Snapshot.
\nvar sCompanyId=new String(Values(“Comp_CompanyId”))<\/em>
\nif(sCompanyId==”null”||sCompanyId==”undefined”||sCompanyId==””)<\/em>
\n{<\/em>
\n sCompanyId=new String(FormValues(“Comp_CompanyId”))<\/em>
\n if(sCompanyId==”null”||sCompanyId==”undefined”||sCompanyId==””)<\/em>
\n {<\/em>
\n sCompanyId=new String(CRM.GetContextInfo(‘company’,’Comp_CompanyId’))<\/em>
\n if(sCompanyId==”null”||sCompanyId==”undefined”||sCompanyId==””)sCompanyId=”0″;<\/em>
\n }<\/em>
\n}<\/em>
\nvar User_ID = CurrentUser.user_userid;<\/em>
\nvar sPrimaryUserSQL=”select Oppo_AssignedUserId,Count(*) as OppoCount from Opportunity(nolock) where oppo_deleted is null and Oppo_PrimaryCompanyId=”+sCompanyId+” and Oppo_AssignedUserId=”+User_ID+” and Oppo_Status=’In Progress’ group by Oppo_AssignedUserId”;<\/em>
\nvar RecPrimarySQL=eWare.CreateQueryObj(sPrimaryUserSQL);<\/em>
\nRecPrimarySQL.selectSQL();<\/em>
\nif(!RecPrimarySQL.eof)<\/em>
\n{<\/em>
\n Count1=RecPrimarySQL(“OppoCount”); <\/em>
\n if(Count1==”null”||Count1==”undefined”||Count1==””)Count1=”0″;<\/em>
\n Count1=parseInt(Count1);<\/em>
\n}<\/em>
\nelse{ Count1=”0″;}<\/em>
\nCaption+=”Company Name:<input type=’hidden’ id=’HDNCount1′ name=’HDNCount1′ value='”+Count1+”‘>”<\/em>
\n\"Image01\"<\/a>
\n3.<\/strong> Repeat above steps under opportunity entity as well. See below snapshot.
\n\"Image04\"<\/a>
\n 
\n4.<\/strong> After saving this, you will be able to see the effect as shown below.
\n\"Image02\"<\/a>
\n\"Image03\"<\/a>
\nHappy Scripting..!!
\nAlso Read:<\/strong><\/em><\/span>
\n1.<\/strong> Changing max allowable length of Text field using Jquery<\/a>
\n2.<\/strong> Sort Dropdown list items using jQuery<\/a>
\n3.<\/strong> Apply underline to a Column Header in List or Grid<\/a>
\n4.<\/strong> Displaying date fields in Nonstandard formats<\/a>
\n5.<\/strong> Linked selection fields through client side scripting<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In my previous blog, I have explained how to display Current User Name under custom tab. Here, I am going to explain how to display the count of records (say Opportunities) which are in progress and assigned to me i.e. Current Logon User against respective companies using jQuery mechanism. New Stuff:\u00a0Event Management in Sage CRM\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71,77,201,269,332,352,1],"tags":[771,772,781,855,877,1466,1709],"class_list":["post-13400","post","type-post","status-publish","format-standard","hentry","category-company","category-context","category-jquery","category-opportunity-sage-crm","category-sage-crm","category-script","category-uncategorized","tag-count-of-opportunities-against-company","tag-count-of-opportunity-from-company-context","tag-create-script","tag-custom-content","tag-custom-tab","tag-j-query","tag-opportunity-count"],"yoast_head":"\nDisplay Count of your Opportunities against Company - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Display Count of your Opportunities against Company - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In my previous blog, I have explained how to display Current User Name under custom tab. Here, I am going to explain how to display the count of records (say Opportunities) which are in progress and assigned to me i.e. Current Logon User against respective companies using jQuery mechanism. New Stuff:\u00a0Event Management in Sage CRM\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2016-11-16T08:50:53+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/11\/Image01.jpg\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/\",\"name\":\"Display Count of your Opportunities against Company - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/11\/Image01.jpg\",\"datePublished\":\"2016-11-16T08:50:53+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/11\/Image01.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/11\/Image01.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Display Count of your Opportunities against Company\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Display Count of your Opportunities against Company - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/","og_locale":"en_US","og_type":"article","og_title":"Display Count of your Opportunities against Company - Sage CRM \u2013 Tips, Tricks and Components","og_description":"In my previous blog, I have explained how to display Current User Name under custom tab. Here, I am going to explain how to display the count of records (say Opportunities) which are in progress and assigned to me i.e. Current Logon User against respective companies using jQuery mechanism. New Stuff:\u00a0Event Management in Sage CRM\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2016-11-16T08:50:53+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/11\/Image01.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/","name":"Display Count of your Opportunities against Company - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/11\/Image01.jpg","datePublished":"2016-11-16T08:50:53+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/11\/Image01.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/11\/Image01.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/16\/display-count-of-your-opportunities-against-company\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Display Count of your Opportunities against Company"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/13400","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=13400"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/13400\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=13400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=13400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=13400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}