Queries to Index Fields

Package Version 1.56 and later
Query 1
select id from smagicinteract__smsMagic__c where (smagicinteract__Unformatted_Phone_Number__c in :phoneValues or smagicinteract__PhoneNumber__c in :phoneValues) and smagicinteract__senderid__c = :inboundNumber limit 1
Query 2
select id from smagicinteract__Conversation__c  where smagicinteract__Sender__r.smagicinteract__senderId__c in :senderIDSet and smagicinteract__Mobile_Number__c  = :mobileSet and smagicinteract__State__c = \’Open\’ and ownerID = :userID order by createddate desc
Fields
•smagicinteract__Unformatted_Phone_Number__c•smagicinteract__PhoneNumber__c of smagicinteract__smsMagic__c•smagicinteract__Mobile_Number__c of smagicinteract__Conversation__c
select id from smagicinteract__smsMagic__c where smagicinteract__Direction__c = :directionValue and (smagicinteract__Lead__c = null OR smagicinteract__lead__r.isconverted = false) and (smagicinteract__Unformatted_Phone_Number__c in :phoneValues or smagicinteract__PhoneNumber__c in :phoneValues)  and smagicinteract__senderid__c in :outgoingSenderIds order by smagicinteract__CreatedOn__c desc NULLS LAST limit 1

Package Version 1.52 -55
Query
select id from smagicinteract__smsMagic__c where (smagicinteract__Unformatted_Phone_Number__c in :phoneValues or smagicinteract__PhoneNumber__c in :phoneValues) and smagicinteract__senderid__c = :inboundNumber limit 1
Fields
•smagicinteract__Unformatted_Phone_Number__c•smagicinteract__PhoneNumber__c of smagicinteract__smsMagic__c
select smagicinteract__account__r.sms_us_homephone__c,smagicinteract__account__r.sms_us_phone__c,smagicinteract__contact__r.sms_us_phone__c,smagicinteract__lead__r.sms_us_phone__c,smagicinteract__opportunity__r.account.home_phone__c,smagicinteract__opportunity__r.account.phone,smagicinteract__opportunity__r.account.sms_us_homephone__c,smagicinteract__opportunity__r.account.sms_us_phone__c,zinvoice__r.sms_phone__c,smagicinteract__account__c,smagicinteract__contact__c,smagicinteract__lead__c,smagicinteract__opportunity__c,zinvoice__c,Id,smagicinteract__lead__r.isconverted,smagicinteract__senderid__c,smagicinteract__phonenumber__c,smagicinteract__unformatted_phone_number__c,smagicinteract__Converse_App__c,smagicinteract__Converse_App_Action__c,smagicinteract__Converse_App_Task__c,smagicinteract__Conversation__c,smagicinteract__ObjectType__c from smagicinteract__smsMagic__c where smagicinteract__Direction__c = :directionValue and (smagicinteract__Lead__c = null OR smagicinteract__lead__r.isconverted = false) and (smagicinteract__Unformatted_Phone_Number__c in :phoneValues or smagicinteract__PhoneNumber__c in :phoneValues)  and smagicinteract__senderid__c in :outgoingSenderIds order by smagicinteract__CreatedOn__c desc NULLS LAST limit 1

Package Version 1.51
Query
select id from smagicinteract__smsMagic__c where (smagicinteract__Unformatted_Phone_Number__c in :phoneValues or smagicinteract__PhoneNumber__c in :phoneValues) and smagicinteract__senderid__c = :inboundNumber limit 1
Fields to Index
•smagicinteract__Unformatted_Phone_Number__c•smagicinteract__PhoneNumber__c of smagicinteract__smsMagic__c

Package Version 1.50
Query
select id from smagicinteract__smsMagic__c where (smagicinteract__Unformatted_Phone_Number__c in :phoneValues or smagicinteract__PhoneNumber__c in :phoneValues) and smagicinteract__senderid__c = :inboundNumber limit 1select id from smagicinteract__Conversation__c  where smagicinteract__Sender__r.smagicinteract__senderId__c in :senderIDSet and smagicinteract__Mobile_Number__c  = :mobileSet and smagicinteract__State__c = \’Open\’ and ownerID = :userID order by createddate desc
Fields to Index
•smagicinteract__Unformatted_Phone_Number__c•smagicinteract__PhoneNumber__c of smagicinteract__smsMagic__c•smagicinteract__Mobile_Number__c of smagicinteract__Conversation__c

Package Version 1.48 or earlier
Query
select id from smagicinteract__smsMagic__c wheresmagicinteract__PhoneNumber__c in :MobNum1 order by createdDate desc limit 1
Fields to Index
smagicinteract__PhoneNumber__c of smagicinteract__smsMagic__c

Was This Article Helpful?

ATTENTION!!!! - Urgent Action Required

There have been new changes by the TCR that require companies sending application-to-person (A2P) SMS or Text messages within the United States to register their Brand and 10-digit long code (10DLC) numbers they are using.

The goal is to build trust within the system while delivering high customer engagement. SMS Text Messages will start failing if you don't comply with these regulations.

SMS Magic team wants to help you complete this process so you can continue serving your customers.

Please click on the below link to complete the form, and our team will start the registration process.