You need to sign in to do that
Don't have an account?
Jeff Susich
Need help with a SOQL on custom objects
I have an object called “Invoice Tracking”. It is the parent to “Invoice and Quote Line Items”. So one “Invoice Tracking” record, and many “Invoice and Quote Line Items” records.
I want to display certain "Invoice and Quote Line Items" records in a related list of an App that uses SOQL queries to build a list. I want ONLY records in which the “Activity Date” date field on an "Invoice and Quote Line Item" record is before a “Last Date Invoiced” date field on the Invoice Tracking object. I am using the following SOQL query:
Select Name FROM Invoice_Tracking__c WHERE Invoice_Sent__c < Invoice_Quote_Line_Items__c.r.Activity_Date__c
It's not working. Any help appreciated.
I want to display certain "Invoice and Quote Line Items" records in a related list of an App that uses SOQL queries to build a list. I want ONLY records in which the “Activity Date” date field on an "Invoice and Quote Line Item" record is before a “Last Date Invoiced” date field on the Invoice Tracking object. I am using the following SOQL query:
Select Name FROM Invoice_Tracking__c WHERE Invoice_Sent__c < Invoice_Quote_Line_Items__c.r.Activity_Date__c
It's not working. Any help appreciated.
One possible solution could be below.