function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
CRM ADMIN 8CRM ADMIN 8 

Reg: SOQL Query not working in my production enviranment.

Hi Team,

I created a case in my production. It is created. When i want to retrieve that case with SOQL query it shows "No Response from Server". Please do needful.

 
William TranWilliam Tran
You should try again. 

Try a simple query like [Select id from case]  and see if that run.

 If you still have issues, can you post the query and the error message if possible.

Thx
CRM ADMIN 8CRM ADMIN 8
Hi William,

Thank you for your response. Iam getting same issue. actucally i created a custom field "Ticket_Status__c" and "Trippro_User_ID__c" in my production org. when iam trying to query with that field it showing "No Response from the Server". Error Querry :SELECT id, subject, Trippro_User_ID__c, status FROM Case WHERE Trippro_User_ID__c = 'prasad@trippro.com' AND Ticket_Status__c = 'Ticketed'. when iam remove the "Ticket_Status__c,Trippro_User_ID__c" fields in query it is working fine.
William TranWilliam Tran
But you query has status instead of Ticket_Status__c.
  
SELECT id, subject, Trippro_User_ID__c, status FROM Case WHERE Trippro_User_ID__c = 'prasad@trippro.com' AND Ticket_Status__c = 'Ticketed'

Should it be this?
  
SELECT id, subject, Trippro_User_ID__c, Ticket_Status__c FROM Case WHERE Trippro_User_ID__c = 'prasad@trippro.com' AND Ticket_Status__c = 'Ticketed'

Also check the object model in PROD just to make sure you didn't change in your DEV environment thinking it's PROD.

Thx
 
CRM ADMIN 8CRM ADMIN 8
Hi William,

i placed below query but still same problem.

SELECT id, subject, Trippro_User_ID__c, Ticket_Status__c FROM Case WHERE Trippro_User_ID__c = 'prasad@trippro.com' AND Ticket_Status__c = 'Ticketed'.
Could you please tell me how to check object modelin prod...
CRM ADMIN 8CRM ADMIN 8
Hi William,

when iam searching with recordtypeid it cames
SELECT id, subject, casenumber, Trippro_User_ID__c, recordtypeID, Ticket_Status__c FROM Case WHERE Trippro_User_ID__c='prasad@trippro.com' and Ticket_Status__c ='Success' and recordtypeID='012700000001iETAAY'.

Without recordtypeid it won't come. I want to query without recordtypeid.please help me why it is came with recordtypeId and why it is not came without recordtypeId.
William TranWilliam Tran
But you changed your status from Ticket_Status__c = 'Ticketed'  to  Ticket_Status__c ='Success' 

in theory the RecordTypeId will only limit the result set not return more rows.  It is likely because you changed the ticket Status criteria to "Success" that results are returned.

It's also possible that there are Too many rows and your query is hitting the limit and timing out so narrowing it with a RecordTypeID brings it down to a reasonable result set and data is returned.

Thx
 
CRM ADMIN 8CRM ADMIN 8
Without recordtypeid the query is not working even i changed the Ticket_Status__c = 'Ticketed'  to  Ticket_Status__c ='Success'. With recordtypeID it is working. This is not depending on Ticket_Status__c picklist values.
William TranWilliam Tran
Do a count, do you have too much data?

Thx
CRM ADMIN 8CRM ADMIN 8
no, i have one only in production for that query.
William TranWilliam Tran
Can you paste the whole class/controller?

Thx
CRM ADMIN 8CRM ADMIN 8
Hi William,

Same Site and Same Class is working in sandbox. Problem only in production.

Site:
https://trippro.secure.force.com/TripproAgentsCaseSelfTicketing?loginid=prasad@trippro.com&ticketingstatus=success

Class:

public without sharing class TripproAgentsCaseSelfTicketingcls{     public list<selectoption> lstOptions{get;set;}     public string selOption{get;set;}     public integer TotalPage{get;set;}     public Integer listSize;     public Boolean firstOff{set;get;}     public Integer pageNumber{set;get;}     public integer offsetval;     public integer limitval;     public String loginId{get;set;}     public String ticketingstatus{get;set;}     public string searchCondition;     public list<Case> CaseObjectList{get;set;}     public String SortOrderSearchResults {get;set;}     public String SortFieldSearchResults {get;set;}     public String PreviousSortField {get;set;}     public Boolean lastOff{set;get;}     public case caseObj{get;set;}     public case caseObj1{get;set;}     public boolean isshowConsol{get;set;}     public boolean isshowDates{get;set;}     public date fromDate{get;set;}     public date toDate{get;set;}     public boolean isshowpnr{get;set;}     public boolean isshowTicketNumber{get;set;}     public boolean isshowCaseNumber{get;set;}     public String pnr{get;set;}     public String invoiceNumber{get;set;}     public String caseNumber{get;set;}     public String ticketNumber{get;set;}       public TripproAgentsCaseSelfTicketingcls(){       loginId = ApexPages.currentPage().getParameters().get('loginId');         ticketingstatus = ApexPages.currentPage().getParameters().get('ticketingstatus');         caseObj = new Case();         caseObj1 = new Case();         isshowConsol = false;         isshowDates = false;         lstOptions = new list<selectoption>();         selOption = '';         TotalPage = 0;         listSize = 0;         firstOff = false;         pageNumber = 1;         offsetval = 0;         limitval = 10;         searchCondition = '';                 CaseObjectList = new list<Case>();         SortOrderSearchResults = 'asc';         SortFieldSearchResults = 'Ticket_Status__c';         PreviousSortField = SortFieldSearchResults;          doSearch();     }     public PageReference doSearch(){         CaseObjectList = new list<Case>();          String soql = '';         String whereClause = '';         soql = '';         whereClause = '';             System.debug('loginId:'+loginId );          System.debug('ticketingstatus::'+ticketingstatus );             if(loginId!=null && loginId!='' && ticketingstatus!=null && ticketingstatus!=''){           System.debug('first if entering...');             soql += 'Select Id,PNR__C, Invoice_Number__c, Invoice_Date__c, CaseNumber,Ticket_Status__c, Ticket_Number__c, Airline__c, Additional_Fee__c, Service_Fee__c, Total__c, Status, Trippro_User_ID__c ';         soql += 'From Case ';         whereClause = 'Ticket_Status__c=:ticketingstatus and Trippro_User_ID__c=:loginId';         if(whereClause != ''){             whereClause = ' where ' + whereClause;             soql += whereClause;             if(searchCondition!=null && searchCondition!=''){                 soql += searchCondition;             }         }         system.debug('SOQL@@@@:'+soql);         soql += ' order by ' + soqlSortExp;         string totrecSql = soql+' limit 49975';         list<Case> totalRec = Database.query(totrecSql);         System.debug('totalRec@@'+totalRec);         if(totalRec!=null && totalRec.size()>0){             if(Math.Mod(totalRec.size(),limitval) == 0)                  TotalPage = totalRec.size()/limitval;             else                  TotalPage = (totalRec.size()/limitval)+1;                              if(totalRec.size() > limitval)                  lastOff = true;             else                  lastOff = false;                              listSize = totalRec.size();         }else{             lastOff = false;             TotalPage = 0;             listSize = 0;         }         System.debug('offset==>'+ offsetval);         soql += ' limit '+limitval+' offset '+offsetval;                  System.debug('## soql : ' + soql);               CaseObjectList = Database.query(soql);       }               return null;     }     public void first(){         offsetval = 0;         firstOff = false;         lastOff = true;         pageNumber = 1;         doSearch();     }     public void last(){         // set page number of and offset         if(Math.Mod(listSize,limitval) == 0){             offsetval = listSize-limitval;             pageNumber = listSize/limitval;         }         else{             offsetval = (listSize/limitval)*limitval;             pageNumber = (listSize/limitval)+1;         }         if(offsetval>2000){             offsetval = 2000;         }         firstOff = true;         doSearch();         lastOff = false;     }     public void next(){         offsetval += limitval;         if(offsetval>2000){             offsetval = 2000;         }         firstOff = true;         pageNumber++;         doSearch();         if(offsetval+limitval >= listSize){             lastOff = false;         }     }     // navigate on previous page     public void previous(){         if(offsetval-limitval <= 0){             offsetval = 0;             firstOff = false;         }else{              offsetval -= limitval;         }         lastOff = true;         pageNumber--;         doSearch();     }     public pagereference AddAdditionalSearch(){                offsetval = 0;         TotalPage = 0;         listSize = 0;         firstOff = false;         pageNumber = 1;         PageReference pageRef = null;         SortOrderSearchResults = 'asc';         SortFieldSearchResults = 'Ticket_Status__c';                 System.debug('selOption@@:'+selOption);                 if(pnr!=null && pnr!=''){           searchCondition+=' and PNR__C=:pnr ';         }         if(invoiceNumber!=null && invoiceNumber!=''){           searchCondition+=' and Invoice_Number__c=:invoiceNumber ';         }         if(caseNumber!=null && caseNumber!=''){           searchCondition+=' and CaseNumber=:caseNumber ';         }         if(ticketNumber!=null && ticketNumber!=''){           searchCondition+=' and Ticket_Number__c=:ticketNumber ';         }         if(caseObj.Dispute_Date__c!=null && caseObj1.Dispute_Date__c!=null){           fromDate = caseObj.Dispute_Date__c;             toDate = caseObj1.Dispute_Date__c;           searchCondition += ' and Invoice_Date__c>=:fromDate and Invoice_Date__c<=:toDate';         }         if((pnr==null || pnr=='') && (invoiceNumber==null || invoiceNumber=='') && (caseNumber==null || caseNumber=='')            && (ticketNumber==null || ticketNumber=='') && caseObj.Dispute_Date__c==null && caseObj1.Dispute_Date__c==null){           searchCondition='';         }         pageRef = doSearch();         return pageRef;     }     public pagereference cancelSearch(){         String soql='';         offsetval = 0;         TotalPage = 0;         listSize = 0;         firstOff = false;         pageNumber = 1;         PageReference pageRef = null;         SortOrderSearchResults = 'asc';         SortFieldSearchResults = 'Ticket_Status__c';         invoiceNumber = '';         pnr ='';         caseNumber='';         ticketNumber='';         searchCondition='';         caseObj.Dispute_Date__c=null;         caseObj1.Dispute_Date__c=null;            pageRef = doSearch();         return pageRef;     }     public PageReference searchButtonClicked(){         doSearch();         return null;     }     public PageReference doSortSearchResults(){         PageReference pageRef = null;         if(PreviousSortField == SortFieldSearchResults){             if(SortOrderSearchResults == 'asc'){                 SortOrderSearchResults = 'desc';             }             else{                 SortOrderSearchResults = 'asc';             }         }         else{             PreviousSortField = SortFieldSearchResults;             SortOrderSearchResults = 'asc';         }           pageRef = doSearch();                  return pageRef;     }     public String soqlSortExp{         get{             String sRetVal = '';             if(SortFieldSearchResults == 'PNR__c'){                 sRetVal = 'PNR__c';             }else if(SortFieldSearchResults == 'Invoice_Number__c'){                 sRetVal = 'Invoice_Number__c';             }else if(SortFieldSearchResults == 'Invoice_Date__c'){                 sRetVal = 'Invoice_Date__c';             }else if(SortFieldSearchResults == 'CaseNumber'){                 sRetVal = 'CaseNumber';             }else if(SortFieldSearchResults == 'Ticket_Number__c'){                 sRetVal = 'Ticket_Number__c';             }else if(SortFieldSearchResults == 'Airline__c'){                 sRetVal = 'Airline__c';             }else if(SortFieldSearchResults == 'Additional_Fee__c'){                 sRetVal = 'Additional_Fee__c';             }else if(SortFieldSearchResults == 'Service_Fee__c'){                 sRetVal = 'Service_Fee__c';             }else if(SortFieldSearchResults == 'Total__c'){                 sRetVal = 'Total__c';             }else if(SortFieldSearchResults == 'Status'){                 sRetVal = 'Status';             }else if(SortFieldSearchResults == 'Ticket_Status__c'){                 sRetVal = 'Ticket_Status__c';             }             sRetVal += ' ' + SortOrderSearchResults;             return sRetVal;         }     }         }