Filter using Entity schema query
16:24 May 17, 2017
Hello ,
i want to filter the overdue invoices and for individual account invoices. I have written following code but it is not working.
var esqFirstFilter = select.createColumnFilterWithParameter(Terrasoft.ComparisonType.NOT_EQUAL, "Activity.PaymentStatus" , "Paid");
var esqSecondFilter = select.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUALS, "Account", this.get("Id"));
Thank you.
File attachments
Like
1 comments
12:23 May 18, 2017
Hi Samar,
For proper work of the code you need to get ID of the status that you need and compare with it.
You can find it in InvoicePaymentStatus in database table.
Best regards,
Diana
Show all comments