FYI,
In MP13, 2 new concepts were introduced which can be very usefull when
developing functional code:
> Property field: this allows you to add related/indirect columns as fields to a tab, for example the bankAccount of a
businesspartner can be shown in the sales order window. Even more powerfull: also (grand-)parent columns can be shown in
a grid, this makes it possible to show child tables in the top of a new window, for example a grid with all sales
orderlines with columns from the sales order header in the same grid.
> Computed column: it is possible to add a computed column to a table definition in the Application Dictionary. The
computed column is computed at runtime using a sql expression (defined in the column application dictionary), the
computed column does not have a column in the database schema, it is always computed at realtime when retrieving a
record. Computed columns make it for example possible to have a new column in a parent tab showing aggregated child
information, for example in the sales order header show the total quantity of the child records.
For both concepts:
* fields are readonly
* sorting and filtering works in the same way as for the 'standard'
columns/fields
* automatically recomputed when inserting/saving a record or a child record
For more information visit the following howtos/wiki pages:
http://wiki.openbravo.com/wiki/How_to_create_a_Computed_Column
http://wiki.openbravo.com/wiki/How_to_use_property_fields
--
With Regards, Martin Taal
Openbravo
M: +31 6 288 48 943
@: martin.t...@openbravo.com
Skype: martintaal
Openbravo Headquarters:
P: +34 93 27 25 947
F: +34 93 27 25 905
Address: Edificio Slan, Planta 2a, Landaben, Calle J, 31012 Pamplona, Navarra,
Spain
Mailing address: PO Box 5117, 31010 Pamplona, Navarra, Spain
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Openbravo-development mailing list
Openbravo-development@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-development
