Welcome to the 2nd article of the series where we show how to leverage PACX commands to create Dataverse columns.
Numeric columns
Dataverse supports 4 numeric column types:
Integer
BigInt
Decimal
Float (Double)
The first one does not accepts decimal values at all. The second can accept decimal values, with a predetermined precision (up to 10 decimal points). The third can accept decimal numbers with up to 5 points of precision.
Decimal numbers are stored in the database exactly as specified. Floating point numbers store an extremely close approximation of the value. Why choose extremely close approximation when you can have the exact value? The answer is that you get different system performance.
From Using the right type of number
There is also another numeric column type (Money), but we’ll discuss about it in a dedicated post.
At the moment of writing, only Integer and Decimal columns types are supported by PACX (PACX is an open source community tool, feel free to drop a pull request to add the missing column types if you like!).
Integer columns
To create an Integer column you can type:
pacx column create -at Integer -t my_table -n “People Count”
Those are the only 3 arguments required to create an **Integer **column
PACX assumes the following conventions:
SchemaName and LogicalName are built by
taking the publisher prefix of the current default solution ({prefix})
taking only letters, numbers or underscores from the specified –name ({name})
RequiredLevel is set to None
Description is left empty
IsAuditEnabled field is set to true
MinValue is set to .NET Int32.MinValue
MaxValue is set to .NET Int32.MaxValue
For integer columns, you can also specify one of the following formats, that drive the way the field is shown in Model Driven Apps:
None (default): A basic integer field.
Duration: Specifies to display the integer as a drop down list of durations.
TimeZone: Specifies to display the integer as a drop down list of time zones.
Language: Specifies the display the integer as a drop down list of installed languages.
Locale: Specifies a locale.
You can specify the format to apply using:
pacx column create -at Integer -t my_table -n Duration -if Duration
You can also override default min and max values using:
pacx column create -at Integer -t my_table -n Percent -min 0 -max 100
Double columns
To create a Double column you can type:
pacx column create -at Double -t my_table -n Ratio
The same conventions specified for Integer fields apply, with a few minor differences:
SchemaName and LogicalName are built by
taking the publisher prefix of the current default solution ({prefix})
taking only letters, numbers or underscores from the specified –name ({name})
RequiredLevel is set to None
Description is left empty
IsAuditEnabled field is set to true
MinValue is set to .NET Int64.MinValue (converted to .NET Decimal)
MaxValue is set to .NET Int64.MaxValue (converted to .NET Decimal)
Precision is set to 2
To specify a different precision you can type:
pacx column create -at Integer -t my_table -n Ratio -p 5
To override min and max value, you can use:
pacx column create -at Integer -t my_table -n Ratio -min 10.35 -max 100.99
As usual, all those arguments can be mixed in a single command execution to build the field as you need. Just type
To get the list, and a quick help, on all available arguments.