Sign Up ›
  • Software Engine
  • NEWBIE
  • 0 Points
  • Member since 2007
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 19
    Questions
  • 13
    Replies
2 replies

join in soql

Can some one help us with the below query.
 
I need to fetch the data from Opportunity, Account and Contact tables.
 
We have two rows available in Oppertunity Table and have one corresponding row in Account and Contact table. When we fetch the data using OppertunityContacRole table we always getting only one row as a result.
So we used the query
select opportunity.CE_Lead_Ref__c,
opportunity.CloseDate,
opportunity.Order_Type__c,
opportunity.Order_Channel__c,
opportunity.Electric_Utility__c,
opportunity.Gas_Utility__c,
opportunity.QA_Done__c,
opportunity.Product_ID__c,
opportunity.oem_entered_date__c,
opportunity.Gas_Product_ID__C,
opportunity.Electric_Sales_Price__c,
opportunity.Gas_Sales_Price__c,
opportunity.Electric_Utility_Account_ID__c,
opportunity.Gas_Utility_Account__c,
opportunity.ORDER_CHNL_VENDOR_CD__c,
opportunity.PROMOTION_CD__c,
opportunity.Account.Name,
opportunity.Name,
opportunity.Service_Address_1__c,
opportunity.Service_Address_2__c,
opportunity.Account.Description,
Opportunity.Account.BillingStreet,
Opportunity.Account.BillingPostalCode,
Opportunity.Account.BillingCity,
Opportunity.Account.BillingState,
opportunity.Account.Other_Phone__c,
opportunity.Opportunity_Decatherms__c,
opportunity.Opportunity_kwh__c,
Opportunity.Electric_Voice_Log_Ref__c,
Opportunity.Gas_Voice_Log_Ref__c,
opportunity.SSN_TaxID__c,
Opportunity.Fed_Tax_ID__c,
opportunity.Service_City__c,
opportunity.Service_State__c,
opportunity.Bill_Due_Date__c,
opportunity.Aggregator_Location__c,
opportunity.Aggregator__c,
opportunity.Service_Zip__c,
opportunity.Account.Phone,
opportunity.owner.name,
opportunity.stagename,
opportunity.Language_Preference__c,
opportunity.Life_Support__c,
opportunity.Tax_Exempt__c,
opportunity.Tax_Exempt_ID__c,
opportunity.DOB__c,
(select contact.FirstName, contact.LastName, contact.Phone, contact.Email, Contact.Title from opportunitycontactroles),
opportunity.Owner.REPID__c,
opportunity.Customer_type__c,
opportunity.SSN_Tax_ID_Masked__c,
opportunity.Effective_Date__c,
opportunity.Campaign.Campaign_Code__c from Opportunity
 
Within VB.NET code we assign a variable to get opportunity values,
eg :

qr = m_Prodbinding.query(QueryStr)

Dim con As Prod_Sforce.Opportunity = qr.records(i - 1)

 

But we are not able to get the Contact table details which is part of inner select query. Pls advise.

Thanks,

Priya

2 replies

Data Missing

HI,
 
I have a custom field defined in Opportunity table and data also populated. But when i tried to pull the value programmatically using the API name of the field, nothing is coming.  Can any body suggest me how to solve this problem.
 
Thanks,
 
4 replies

Session Time

What is the maximum time we can give to a session for timeout?
 
Thanks,
1 replies

Help

Hi,
 
I'm developing a webservice which reads data from a database and exports to a excel sheet.  
I have to create an excelsheet using vb.net.  But on target system i should not install MS Office for rerencing the excel.exe.
 
Dim exlapp as New Microsoft.office.excel.application
exlbook=exlapp.NewBook()
 
If we create a excel sheet in the above scenario we need to install MS office on the target system(deployment system.)
Client is not accepting to install MS office for just creating an excel sheet.
 
So i should follow other method to creating excel sheet . In which scenario no need to install microsoft office in the deployment system.
So i am  creating  excel sheet like  by taking a new project from  VS 2005 ->New Project->Office ->Excel workbook.
Which creates a dll to launch the excelsheet. I have to pass the cell values dynamically to the sheet .
So i have written a method Fill( ) in the sheet1.vb class which can accept the values as arguments.
I created a client appliction and referencing the excel.dll and invoking the method to pass the values.
But its asking for to reference Microsoft.Office.Excel 8.0.0. version. Why so?
 
Can any body help me.
 
Thanks in advance,
2 replies

How to create a excel file without installing Microsoft Office in Deployed server

Hi,

I'm developing a webservice which reads data from a database and exports to a excel sheet. This application works if i have MS Office installed in my system . Since i'm unable to install MS Office in the server is there any alternate way to program this.

Thanks in advance,

 

 

5 replies

Changing the Binding URL

Hi,
 
I have an application which should be test both in Production and QA Environment.
 
Can we change the binding URL to sand box  URL to production URL
 and production URL  to sandbox URL.
 
 
// Create service object
    SforceService sfdc = new SforceService(); 

    LoginResult lr = sfdc.login("username","password"); 

    sfdc.Url = lr.serverUrl; 
   
   sfdc.Url=SandBox URL. // Can we change like this.
 
Would it really point to the specified URL?
 
 
 
Thanks,
 
 
 
 
 
 
0 replies

ExcelSheet column type definition in VB.net

 
Hi
 
I am developing an appliction which queries the salesforce databse and exporting to excelsheet.
After exporting to excelsheet all the column values are in default type. It does not have any specific data type to a particular column.
 
How to define column type like integer, string, date programatically in VB.Net
 
Even In salesforce after generating the report, They used to export in excelsheet format.
But by default column values are formatted to  text by contanetating the Single Quote ( ' ).
In front of some column values single quote( ' ) is concatanated to mention it as string.
 
How do define a single quote to a particular column  programmatically in VB.Net. Can any body tell me the solution.
 
Sample code
-------------------
Private excelApp As Excel.Application

Private excelBook As Excel.Workbook

Private excelsheet As Excel.Worksheet

excelsheet.AutoFormat( ) will workout?

Thanks & Regards,

Arjun.

 

3 replies

Problem with DateTime in Query

Hi,
 
I have a custom field which type is datetime.  But i should query only on  date part.
Is it possible?  If not possible i am giving a try to query with full datetime.
 
By default datetime value stores as in the Greenwich Mean Time (GMT) or Coordinated Universal Time (UTC) time zone. We have to covert the datetime  field value to  local time format when we querying.
 
What is the salesforce time format. Is it following GMT or UTC. Basing on the time format following by salesforce how much time do i need to add or subtract  from the stored field value.
 
 
Ex: Actually my custom field date time stored as 5/21/2007 9:30 AM
 
Query:  select EnteredDate__c from opportunity where EnteredDate__c = 2007-05-21T14:30// giving error
 
Thanks,
1 replies

How to get contact name of contactroles from Opportunity

HI,

 I have to get the contact name of contactroles from opportunity. Could you please write a query. How did u solve that problem. Your help would be highly appreciate.

Thanks & Regards,
Arjun.
0 replies

How to get contactrole details of Opportunity object - Urgent Help

Hi,
 
    I need to fetch the contact name, AccountName which is associated to opportunity.
Your help would be appreciated very much.
 
 
 
Thanks,
 
0 replies

Can we change binding URL dynamically?

Hi,
 
   I have implemented application. I have to test both in Prodcution and SandBox.
   so i need to change the URL.
 
     String SandBoxURL= "https://test.salesforce.com/services/Soap/c/9.0"
     String ProductionURL="https://www.salesforce.com/services/Soap/c/9.0" 
 
        binding = New Sforce.SforceService
        binding.Timeout = 60000
        loginRes = binding.login(UID, PWD)
        binding.Url = SandBoxURL / ProductionURL
        binding.SessionHeaderValue = New Sforce.SessionHeader
        binding.SessionHeaderValue.sessionId = loginRes.sessionId
 
       Would this work. Will it really points to the assigned URL.
 
    Thanks.
5 replies

Need help in writing Query - Urgent

Hi,
 
Account is the parent table for Opportunity and contacts.
 
My Driving object should be Opportunity.  How to get the contact details of FirstName,Lastname from Oppoortunity Object.
 
Select o.account.contact.firstname from opportunity o    // its giving error.
 
Thanks,
 
3 replies

How to combine a single query

 
 
HI  Simon,
 
How to write  a single query from  below three queries.
 
select a.Name,(select FirstName from contact),(Select CloseDate from Opportunity) from Account a
select RepID from user
select CampaignCode from Campaign.
 
 
Table Name          Field
----------------          -----------
Account                 Name
Contact                  FirstName
Campaign              CampaignCode
Opportunity            CloseDate
User                         RepID
 
 
Please help me.
 
 
 
 
 
 
 
 
 
 
 
 
0 replies

Need help in writing a typical query

 
 
HI ,
 
Can you help me in writing a  single query from Five tables by following the parent,child relationships.
 
Table Name          Column
----------------          -----------
Account                 AccountName
Contact                  FirstName
Campaign              CampaignCode
Opportunity            CloseDate
User                         RepID
 
 
I am done upto three ables
 
    select a.AccountName,(select FirstName from Contact),(Select CampaignCode from Campaign) from Account a.
 
 
 
 
 
Thanks,
 
 
 
4 replies

How to query Standard Field

Hi,
 
How to Query the Standard Field
--------------------------------------------
I have to query  standard fields and  custom fields from different tables.
But when i query a standard field with the FieldName the result is failing.
Ex: "select Name from accounts"  the result is failing. why?
 
And i am unable to query the custom fields with the FieldName, so i am querying with API Name of the custom field
 
Ex: "Select ProductID__C from opportunities" . the result is succeeding.
 
Generally how can we query the salesforce database? Is it with the FieldName or API name.
Because there is no API Name for standard fields.
 
I will be greatful to you if any one can suggest me as soon as possible
 
 
How to get the APIName by Dynamically for specific field:
--------------------------------------------------------------------------
 
    I would like to query the table for a specific fields. So i will pass only the FieldName, but i want the API Name of the field. Bcaz i am unable to query with FieldName.
 
    I need  APIName of the Field dynamically by accepting the FieldName?
 
 
   Ex:   Field field = fields[i];
           API Name=field.GetAPIName(field.FieldName)
 
 
Thanks.
 
 
 
0 replies

URGENT Help required.

 
     I have developed a windows based application with an enterprise WSDL in VB.Net. My organization keeps on changing the fields and datatypes. Hence they have to download the new WSDL for the updated one and copy to the executable file path.

I hope all the VB.Net developers knows about the problem with the VB keywords "case", "Event". First time when we download the new WSDL file we should edit the code with the "[Case]", "[Event"].
 
     System.Xml.Serialization.XmlIncludeAttribute(GetType([Event])), _
     System.Xml.Serialization.XmlIncludeAttribute(GetType([Case])), _
 
My question is would the new WSDL creates any problem after we deployed the application. If it creates any problem, is there any work around to solve the problem.
 
Can we avoid the problem with PARTNER wsdl?
 
Thanks,
1 replies

A small doubt.

Hi,
 
 
I hope all the VB.Net developers known about the problem with the VB keywords "case", "Event". First time when we download the WSDL file we should edit the code with the brackets.
 
     System.Xml.Serialization.XmlIncludeAttribute(GetType([Event])), _
     System.Xml.Serialization.XmlIncludeAttribute(GetType([Case])), _
 
   I have developed a windows based application with an enterprise WSDL in VB.Net. My organization keeps on changing the fields and datatypes. Hence they have to download the new WSDL for the updated one and copy to the executable file path.
 
My question is would the new WSDL creates any problem after we deployed the application. If it creates any problem, is there any work around to solve the problem.
 
Can we avoid the problem with PARTNER wsdl?
 
Thanks,
 
 
1 replies

How to connect to Sandbox of the database

Hi All,?XML:NAMESPACE PREFIX = O >

 I am new to the Apex code. I am developing an application to connect the apex webservice and displaying a report of the customers. But while developing the application i dont want to connect to actual webservice, bcaz it may lock me out of production and may destroy the original database.

 I have  access to connect the sand box ( Duplicate ) of the customer database. But when i used the API calls  login() and query()  in my application, its connecting to the original database and not to the sand box database.

 How to specify the sand box path in the WSDL file.

Thanks,

Mallik.

1 replies

How to specify the sand box address in the WSDL file.

Hi All,
 
I am new to the Apex code. I am developing an application to connect the apex webservice and displaying a report of the customers. But while developing the application i dont want to connect to actual webservice, bcaz it may lock me out of production and may destroy the original database.
 
I have  access to connect the sand box ( Duplicate ) of the customer database. But when i used the API calls  login() and query()  in my application, its connecting to the original database and not to the sand box database.
 
How to specify the sand box path in the WSDL file.
 
 
 
 
 
2 replies

Data Missing

HI,
 
I have a custom field defined in Opportunity table and data also populated. But when i tried to pull the value programmatically using the API name of the field, nothing is coming.  Can any body suggest me how to solve this problem.
 
Thanks,
 
4 replies

Session Time

What is the maximum time we can give to a session for timeout?
 
Thanks,
2 replies

How to create a excel file without installing Microsoft Office in Deployed server

Hi,

I'm developing a webservice which reads data from a database and exports to a excel sheet. This application works if i have MS Office installed in my system . Since i'm unable to install MS Office in the server is there any alternate way to program this.

Thanks in advance,

 

 

5 replies

Changing the Binding URL

Hi,
 
I have an application which should be test both in Production and QA Environment.
 
Can we change the binding URL to sand box  URL to production URL
 and production URL  to sandbox URL.
 
 
// Create service object
    SforceService sfdc = new SforceService(); 

    LoginResult lr = sfdc.login("username","password"); 

    sfdc.Url = lr.serverUrl; 
   
   sfdc.Url=SandBox URL. // Can we change like this.
 
Would it really point to the specified URL?
 
 
 
Thanks,
 
 
 
 
 
 
3 replies

Problem with DateTime in Query

Hi,
 
I have a custom field which type is datetime.  But i should query only on  date part.
Is it possible?  If not possible i am giving a try to query with full datetime.
 
By default datetime value stores as in the Greenwich Mean Time (GMT) or Coordinated Universal Time (UTC) time zone. We have to covert the datetime  field value to  local time format when we querying.
 
What is the salesforce time format. Is it following GMT or UTC. Basing on the time format following by salesforce how much time do i need to add or subtract  from the stored field value.
 
 
Ex: Actually my custom field date time stored as 5/21/2007 9:30 AM
 
Query:  select EnteredDate__c from opportunity where EnteredDate__c = 2007-05-21T14:30// giving error
 
Thanks,
5 replies

Need help in writing Query - Urgent

Hi,
 
Account is the parent table for Opportunity and contacts.
 
My Driving object should be Opportunity.  How to get the contact details of FirstName,Lastname from Oppoortunity Object.
 
Select o.account.contact.firstname from opportunity o    // its giving error.
 
Thanks,
 
3 replies

How to combine a single query

 
 
HI  Simon,
 
How to write  a single query from  below three queries.
 
select a.Name,(select FirstName from contact),(Select CloseDate from Opportunity) from Account a
select RepID from user
select CampaignCode from Campaign.
 
 
Table Name          Field
----------------          -----------
Account                 Name
Contact                  FirstName
Campaign              CampaignCode
Opportunity            CloseDate
User                         RepID
 
 
Please help me.
 
 
 
 
 
 
 
 
 
 
 
 
2 replies

Combining Parent-Child Relationship Query with Child-Parent Relationship Query

I have two different relationship queries, one is parent-child and the other child-parent:
 
SELECT a.Id, cc.LastName FROM Case a, a.Contact cc
SELECT Id, (SELECT Field, NewValue FROM Histories) FROM Case
 
How do I combine it into one query?
 
4 replies

How to query Standard Field

Hi,
 
How to Query the Standard Field
--------------------------------------------
I have to query  standard fields and  custom fields from different tables.
But when i query a standard field with the FieldName the result is failing.
Ex: "select Name from accounts"  the result is failing. why?
 
And i am unable to query the custom fields with the FieldName, so i am querying with API Name of the custom field
 
Ex: "Select ProductID__C from opportunities" . the result is succeeding.
 
Generally how can we query the salesforce database? Is it with the FieldName or API name.
Because there is no API Name for standard fields.
 
I will be greatful to you if any one can suggest me as soon as possible
 
 
How to get the APIName by Dynamically for specific field:
--------------------------------------------------------------------------
 
    I would like to query the table for a specific fields. So i will pass only the FieldName, but i want the API Name of the field. Bcaz i am unable to query with FieldName.
 
    I need  APIName of the Field dynamically by accepting the FieldName?
 
 
   Ex:   Field field = fields[i];
           API Name=field.GetAPIName(field.FieldName)
 
 
Thanks.
 
 
 
2 replies

Filtaring opportunity using Contact details

Hi, Is it possible to queary for opportunity based on Contact information like name and address? From what i can see using Apex Explorer, other than using Account, there seems to be no way to associate Opportunity with Contact.
Regards,
DM