Add a calculated column to the XData result list

[wlandgraf (Wagner Landgraf)]

There are a few solutions. First is to add calculated fields to your entity. Just create a Total property, set a getter for it and calculate the total based on the getter. Then make such property available in JSON by adding XDataJsonProperty attribute to it. An example:

Hiding field type

Sorry. Did not read your first message. If FInvoiceDate is not a persisted field, than to have it serialized you must use [XDataProperty] attribute: [XDataProperty] // this is missing FinvoiceDate: Tdatetime; I guess what you're really looking for (and Wagner pointed out) is something like: private [XDataExcludeProperty] [FColumn('invoicedate')] FInvoiceDateStr: string; private function GetInvoiceDate: TDateTime; procedure SetInvoiceDate (const AValue: TDateTime); …

Another option is to create your own DTO class (TMyDTOEntity) and return it from a service operation. Then create and fill its properties manually from TMyEntity, and fill in the missing properties accordingly.