Skip to main content

Notifications

Announcements

No record found.

How to filter by SQL code in D365FO

BillurSamdancioglu Profile Picture BillurSamdancioglu 14,836 Most Valuable Professional

You are able to write a SQL code for filtering!

As an example, if you would like to filter the customers whose customer id and invoice id s are different, you may use the code below.


(CustTable.AccountNum != CustTable.InvoiceAccount)

In this case you can select one of the fields

On the example below, I've selected customer account fields to fill with a basic SQL code.




In the link below, you may find other filtering options as well.



Comments