You need to sign in to do that
Don't have an account?
Shane Quiring
SOQL Statement
Hi Experts,
I really need some help here, I have a SOQL statement the grads a specific list of records and child records, but I need to edit the statement to only include those child records that are currently active, I have a check mark box called "Active" on the child record.
Here is my statment:
<soql>select LDC_Account_Number__c, meter_number__c from meter__c where ldc_account__c in (select id from ldc_account__c where opportunity__c='{!ServiceContract.opportunity__r.id}') order by ldc_account_number__c</soql>
meter__c is the child record
name of the field is Active__c
This is only my 5th SOQL statement, still learning, any assistance would be greatly appreciated.
Thank-you
I really need some help here, I have a SOQL statement the grads a specific list of records and child records, but I need to edit the statement to only include those child records that are currently active, I have a check mark box called "Active" on the child record.
Here is my statment:
<soql>select LDC_Account_Number__c, meter_number__c from meter__c where ldc_account__c in (select id from ldc_account__c where opportunity__c='{!ServiceContract.opportunity__r.id}') order by ldc_account_number__c</soql>
meter__c is the child record
name of the field is Active__c
This is only my 5th SOQL statement, still learning, any assistance would be greatly appreciated.
Thank-you
select LDC_Account_Number__c, meter_number__c
from meter__c
where ldc_account__c in (select id from ldc_account__c where opportunity__c='{!ServiceContract.opportunity__r.id}')
and active__c = true
order by ldc_account_number__c
All Answers
select LDC_Account_Number__c, meter_number__c
from meter__c
where ldc_account__c in (select id from ldc_account__c where opportunity__c='{!ServiceContract.opportunity__r.id}')
and active__c = true
order by ldc_account_number__c
v/r
Shane