Decimal field - Revision history

Drn@ecs.soton.ac.uk: /* Additional Properties */

2023-04-11T21:03:34Z

Additional Properties

← Older revision		Revision as of 21:03, 11 April 2023
Line 14:		Line 14:

	{\| border="1" cellpadding="3" cellspacing="0"		{\| border="1" cellpadding="3" cellspacing="0"
	\| ~~name~~ \|\| ~~default~~ \|~~\| description~~		! Name !! Default Value !! Required \|\| Description \|\| Notes
	\|-		\|-
	\| '''integer''' \|\| 16 \|\| ~~'''~~The maximum number of digits to store before the decimal point.~~'''~~		\| '''integer''' \|\| <tt>16</tt> \|\| NO \|\| The maximum number of digits to store before the decimal point. \|\|
	\|-		\|-
	\| '''fractional''' \|\| 2 \|\| ~~'''~~The number of digits to store after the decimal point.~~'''~~		\| '''fractional''' \|\| <tt>2</tt> \|\| NO \|\|The number of digits to store after the decimal point. \|\|
	\|-		\|-
	\|}		\|}

Drn@ecs.soton.ac.uk at 21:24, 10 April 2023

2023-04-10T21:24:08Z

← Older revision		Revision as of 21:24, 10 April 2023
Line 31:		Line 31:

	== API ==		== API ==
	See [[API:EPrints/MetaField/~~Float~~\|API page]].		See [[API:EPrints/MetaField/Decimal\|API page]].

	== Examples ==		== Examples ==

Drn@ecs.soton.ac.uk: Added decimal metadata field type

2023-04-10T21:17:51Z

Added decimal metadata field type

New page

{{fieldtypes}}

== Description ==
This field stores a decimal number. It could be used for prices or other numerical floating point numbers with a spefied amount of precision.

== Inheritance ==
* [[Metadata]]
** [[Float field]]
*** [[Decimal field]]

== Additional Properties ==
As for [[Float field#Additional_Properties|Float fields]] except for:

{| border="1" cellpadding="3" cellspacing="0"
| name || default || description
|-
| '''integer''' || 16 || '''The maximum number of digits to store before the decimal point.'''
|-
| '''fractional''' || 2 || '''The number of digits to store after the decimal point.'''
|-
|}

== Required Phrases ==
No additional phrases beyond those required for [[Float field#Required_Phrases|Float fields]].

== Database ==
Float fields are stored in the database as
fieldname DECIMAL(16,2)
The <tt>16</tt> and <tt>2</tt> will vary depending on what is set for <code>integer</code> and <code>fractional</code> respectively.

== API ==
See [[API:EPrints/MetaField/Float|API page]].

== Examples ==
Most basic example.
{
name => 'total',
type => 'decimal',
}
Set smaller number of digits before the decimal point
{
name => 'price',
type => 'decimal',
integer => 8,
}
Set larger number of digits after the decimal point.
{
name => 'latitude',
type => 'decimal',
fractional => 8,
}