I have SQL query here, can you help to transfer to SOQL?
Select o.OpportunityId from OpportunityLineItem o inner join PricebookEntry PE on o.PricebookEntryID=PE.ID inner join Product2 P on PE.product2ID=P.Id where P.Id in (select Product2.Id from Product2 where Product2.Family not LIKE 'Service%')
we have customized object "Quote configuration" on Opportunity Page. There is SFDC quote ID (exp SF-11111) generated after one Quote is created, which only get general information about the quote, similar like billing address, customer information, etc. there is one custom link on this quote page to link our external application for real product detail quote configuration. After this real product detail quote is generated, there is corresponding quote ID called EZ-12345 created. there is also "Save" button on our external application which can update the SFDC database. SFDC quote ID SF-11111 and EZ-12345 were insert to quote table in SFDC and opportunity table in SFDC, the issue is the "last modified by" field in Quote table and opportunity table is always using system administrator's name not individual sfdc user name.
we have customized object "Quote configuration" on Opportunity Page. There is SFDC quote ID (exp SF-11111) generated after one Quote is created, which only get general information about the quote, similar like billing address, customer information, etc. there is one custom link on this quote page to link our external application for real product detail quote configuration. After this real product detail quote is generated, there is corresponding quote ID called EZ-12345 created. there is also "Save" button on our external application which can update the SFDC database. SFDC quote ID SF-11111 and EZ-12345 were insert to quote table in SFDC and opportunity table in SFDC, the issue is the "last modified by" field in Quote table and opportunity table is always using system administrator's name not individual sfdc user name.
