web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :

How to filter by SQL code in D365FO

BillurSamdancioglu Profile Picture BillurSamdancioglu 18,190 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