Hi All,

I have a requirement wherein we need to send an email to a group of users if cases is not assigned within 4 hours after it gets created.

• The case is getting created in salesforce using Email-To-Case and assigned to Queue as default case owner.

I've written a SOQL query which gives case records that are updated in last 4 hours but not sure how we can get cases which are not updated or not have actioned in 4 hours after cases's created time.
 

List<Case> casesUpdatedInLastFourHours = [select id, Subject, LastModifiedDate from Case where LastModifiedDate = TODAY AND HOUR_IN_DAY(LastModifiedDate) > 4];

Any help or sugegstion is highly appreiciated.

I have case object having it's 2 record types (Pricing Case ,Billing Case)

And i have a picklist field called Is deal standard having Yes/No values in case object

Whenever I update a value of Is deal standard in Billing case, I saw the same is not getting reflected in Pricing case.

I need updated value in Pricing case because there are approval processes for pricing case and those approval processes checks for value of is deal standard field

How could we resolve this? Any suggestion please.

I created a custom object Task Tracking with 3 custom fields:

1) Lookup to user object.
2) Number of open task (number field) 
3) Number if closed task (number field)

When a task is created by user A with let's stay status is IN PROGRESS, I need to create record in Task Tracking object record with these details :

1) Lookup field = user A
2) Number of open task = 1 
3) Number of closed task = 0;

Now next time, when same user A creates another task, the new Task Tracking record shouldn't be created but it should only increment/decrement Number of task field.

I have tried this much. I was able to create Task Tracking record whenever a Task is created but It was creating new Task Tracking Object for every Task that I am creating

trigger TrackTask2 on Task (before insert) { 
List<sujya__Task_Tracking__c> li = new List<sujya__Task_Tracking__c>(); 
sujya__Task_Tracking__c s = new sujya__Task_Tracking__c();
if(Trigger.isBefore && Trigger.isInsert){
 for(Task t:Trigger.new)
{
 s.sujya__User__c = t.CreatedById;
 li.add(s); 
} 
insert li; 
}
 }

Appreiciate your help :) 
 

Hello Everyone, 

Hope you're doing well.

I am having issue while saving a record that i am displaying using standard list controller for Account object. Record is not getting updated when I click on Quicksave button

Here is my code and let me know if something went wrong

<apex:page StandardController="Account"
recordSetVar="acts">
<apex:form >
    <apex:pageBlock title="Account List">  
        <apex:pageBlockTable value="{!acts}" var="a" rows="20">
            <apex:column value="{!a.name}"/>
            <apex:column value="{!a.industry}"/>
            <apex:column value="{!a.rating}"/>
            <apex:column value="{!a.phone}"/>
        </apex:pageBlockTable>

          <apex:commandButton value="Save it now" action="{!Quicksave}"/>
        
        <apex:inlineEditSupport/>
    </apex:pageBlock>
    </apex:form>
</apex:page>

Appreciate your help in advance :)

Hi All,

I have a requirement wherein we need to send an email to a group of users if cases is not assigned within 4 hours after it gets created.

• The case is getting created in salesforce using Email-To-Case and assigned to Queue as default case owner.

I've written a SOQL query which gives case records that are updated in last 4 hours but not sure how we can get cases which are not updated or not have actioned in 4 hours after cases's created time.
 

List<Case> casesUpdatedInLastFourHours = [select id, Subject, LastModifiedDate from Case where LastModifiedDate = TODAY AND HOUR_IN_DAY(LastModifiedDate) > 4];

Any help or sugegstion is highly appreiciated.