view-entity with DATEDIFF() function

[kentc]

Hi,

How to generate view-entity in xml format for DATEDIFF() function.


select
inv.INVOICE_ID,
inv.DUE_DATE,
inv.PARTY_ID,
b.QUANTITY,
b.AMOUNT ,
b.QUANTITY*b.AMOUNT as total
DATEDIFF(inv.due_date,CURDATE()) as days
from insb_erp.invoice inv inner join insb_erp.invoice_item b on inv.INVOICE_ID=b.INVOICE_ID