You need to sign in to do that
Don't have an account?
Data Warehouse Reports
Query combining columns in output
I have this query below where in the output Account.Corportate_Code__c and Account.Industry column values are being concatenated as "AccountSNHUEducation" .
Account.Corportate_Code__c has value = SNHU
Account.Industry = Education
SELECT id,Account.Corportate_Code__c, StartDate, EndDate,Number_of_Backup_days_in_contract__c,Account.Industry, CreatedDate, LastModifiedDate, (SELECT id FROM Opportunities) FROM Contract WHERE Status = 'Activated' AND RecordTypeId = '01270000000Hp9oAAC'
I am running this query in Python and my code is:
query = (
"SELECT Account.Corportate_Code__c, id, Account.Industry, (SELECT id FROM Opportunities) FROM Contract WHERE Status = 'Activated' AND RecordTypeId = '01270000000Hp9oAAC'")
records = svc.query(query)
for rec in records[sf.records:]:
#out.write(rec)
print str(rec[1]) + " : " + str(rec[2]) + " : " + str(rec[3]) + " : " + str(rec[4])
Account.Corportate_Code__c has value = SNHU
Account.Industry = Education
SELECT id,Account.Corportate_Code__c, StartDate, EndDate,Number_of_Backup_days_in_contract__c,Account.Industry, CreatedDate, LastModifiedDate, (SELECT id FROM Opportunities) FROM Contract WHERE Status = 'Activated' AND RecordTypeId = '01270000000Hp9oAAC'
I am running this query in Python and my code is:
query = (
"SELECT Account.Corportate_Code__c, id, Account.Industry, (SELECT id FROM Opportunities) FROM Contract WHERE Status = 'Activated' AND RecordTypeId = '01270000000Hp9oAAC'")
records = svc.query(query)
for rec in records[sf.records:]:
#out.write(rec)
print str(rec[1]) + " : " + str(rec[2]) + " : " + str(rec[3]) + " : " + str(rec[4])
Can u please let us know, under which field are u getting " AccountSNHUEducation" value? Did u try to print ur values using system.debug statements? That would help you debug better.