Filter using Entity schema query

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

 

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