I am creating one opportunity report that will show the percentage to complete the next stage. And the report is having group by Stage field. Formula - (Next stage record count/Current stage record count)*100.
I tried with existing function “PREVGROUPVAL” working fine but it’s not suitable for my requirement. However do we have the same kind function or any solution to get Next Group Value (means Next stage record count). Anyone who has worked related to such issue can expedite their help.
Need DML update details in trigger or apex. if any field is updated? is there way to find that DML update happened from either manual or Data Loader or some other API.
Requirement:- If I update any field manually, do not want to update the same field from data loader or some other API.
I am facing couple of challenges with Dynamic SOSL. Records are available with "test.abc1@test.digital or test.abc@test.com" and "(123) 456-7890"(based on locale).
we are using Dynamic SOSL query with multiple search terms and asterisk match (*)
Email field not working with :-
1)searchTerm ="@test.digital*" 2)searchTerm ="abc1*" 3)searchTerm ="abc1@test.digital*" or searchTerm =".abc1@test.digital*"
***We ant fetch records with any character from email field and any number from Phone number field.***
we tried multiple ways suggested by salesforce i.e. https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_sosl_find.htm
Code :- SearchCaseByMultipleId(string searchText){ String searchTerms = '('; for(string str : searchText.split(',')){ if(str.length()>0){ searchTerms = searchTerms+' "' +str +'*'+'" '+'OR'; }else{ } } searchTerms = searchTerms.removeEnd('OR'); searchTerms = searchTerms+')'; string finalQuery = 'FIND :searchTerms IN ALL FIELDS RETURNING '+objectName+'(' + quryFields +' ORDER BY CreatedDate DESC NULLS last)'; list<list<Sobject>> results = search.query(finalQuery); } search term looks like :- ("@test.digital*" OR "abc1*").
is there any other way for my requirement or is something missing?
We have a requirement like Table scroll should be horizontal and vertical but when we scroll vertically, title should be Freeze. I have tried two scenario's 1) Single Table:- Horizantal scroll is working but when i scroll vertically table header also moving up. But title should freeze. 2) Two tables:- one is for Header and second is for body, but table alignments are not displaying properly.Even though two tables are having same width or measurement.
Finally i come to know one table is suitable for my requirement.
Please fine the below Code( title and body with One table).
My Requirement:- we want display to the notifications without reloading the page and with out any streaming api. if any change happen on the record from custom lightning page. I have done some R&D. then i found something like PlatformEvents and empApi Components. I tried two scenario's Created One platform Event Object. 1)Publishing the notification from Process Builder and able to get notifications in Bell Icon. 2)Publishing the Notification from process builder.For Subscribing the event, created lightning component with help "empAPI component" and added my component to a lightning page, then i can able to see the notification in cosnole. But if add the same component into Lightning Application, not able to see the notifications. i guess event not subscribing, little confusing. Below is the code snippet. Component:-
Controller:- ({ init : function(component, event, helper) { alert('init() calling'); var empApi = component.find("empApi"); var errorHandler = function (message) { console.log("Received error ", message); }.bind(this); empApi.onError(errorHandler); var channel='/event/Custom_Notification__e'; var sub; var replayId=-1; var callback = function (message) { component.find('notifLib').showToast({ "title": "Message Received!", "message": message.data.payload.Notification_Title__c }); console.log("Notification Title>>>>>>" + message.data.payload.Notification_Title__c); }.bind(this); empApi.subscribe(channel, replayId, callback).then(function(value) { console.log("Subscribed to channel " + channel); sub = value; component.set("v.sub", sub); }); } })
Am quite new to Lightning and trying to understand Events so far i have created two components making Parent Child compoent with help of Events. But getting "Action failed: c:MySampleChildCmp$controller$handleClick [Cannot read property 'setParams' of null] Failing descriptor: {c:MySampleChildCmp$controller$handleClick}" Unable to identify the Error.
Need DML update details in trigger or apex. if any field is updated? is there way to find that DML update happened from either manual or Data Loader or some other API.
Requirement:- If I update any field manually, do not want to update the same field from data loader or some other API.
I am facing couple of challenges with Dynamic SOSL. Records are available with "test.abc1@test.digital or test.abc@test.com" and "(123) 456-7890"(based on locale).
we are using Dynamic SOSL query with multiple search terms and asterisk match (*)
Email field not working with :-
1)searchTerm ="@test.digital*" 2)searchTerm ="abc1*" 3)searchTerm ="abc1@test.digital*" or searchTerm =".abc1@test.digital*"
***We ant fetch records with any character from email field and any number from Phone number field.***
we tried multiple ways suggested by salesforce i.e. https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_sosl_find.htm
Code :- SearchCaseByMultipleId(string searchText){ String searchTerms = '('; for(string str : searchText.split(',')){ if(str.length()>0){ searchTerms = searchTerms+' "' +str +'*'+'" '+'OR'; }else{ } } searchTerms = searchTerms.removeEnd('OR'); searchTerms = searchTerms+')'; string finalQuery = 'FIND :searchTerms IN ALL FIELDS RETURNING '+objectName+'(' + quryFields +' ORDER BY CreatedDate DESC NULLS last)'; list<list<Sobject>> results = search.query(finalQuery); } search term looks like :- ("@test.digital*" OR "abc1*").
is there any other way for my requirement or is something missing?
My Requirement:- we want display to the notifications without reloading the page and with out any streaming api. if any change happen on the record from custom lightning page. I have done some R&D. then i found something like PlatformEvents and empApi Components. I tried two scenario's Created One platform Event Object. 1)Publishing the notification from Process Builder and able to get notifications in Bell Icon. 2)Publishing the Notification from process builder.For Subscribing the event, created lightning component with help "empAPI component" and added my component to a lightning page, then i can able to see the notification in cosnole. But if add the same component into Lightning Application, not able to see the notifications. i guess event not subscribing, little confusing. Below is the code snippet. Component:-
Controller:- ({ init : function(component, event, helper) { alert('init() calling'); var empApi = component.find("empApi"); var errorHandler = function (message) { console.log("Received error ", message); }.bind(this); empApi.onError(errorHandler); var channel='/event/Custom_Notification__e'; var sub; var replayId=-1; var callback = function (message) { component.find('notifLib').showToast({ "title": "Message Received!", "message": message.data.payload.Notification_Title__c }); console.log("Notification Title>>>>>>" + message.data.payload.Notification_Title__c); }.bind(this); empApi.subscribe(channel, replayId, callback).then(function(value) { console.log("Subscribed to channel " + channel); sub = value; component.set("v.sub", sub); }); } })
