PACX ⁓ Create columns: Boolean

Welcome to the 3rd article of the series where we show how to leverage PACX commands to create Dataverse columns.

Creating a Boolean column is quite straightforward:

pacx column create –type Boolean –table my_table –name “Is Open?”
pacx colum…


This content originally appeared on DEV Community and was authored by Riccardo Gregori

Welcome to the 3rd article of the series where we show how to leverage PACX commands to create Dataverse columns.

Creating a Boolean column is quite straightforward:

pacx column create --type Boolean --table my_table --name "Is Open?"
pacx column create -at Boolean -t my_table -n "Is Open?"

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
  • Label for truevalue is "True"
  • Label for false value is "False"

You can override the default labels for Trueand False values via:

pacx column create --type Boolean --table my_table --name "Is Open?" --trueLabel Yes --falseLabel No
pacx column create -at Boolean -t my_table -n "Is Open?" -tl Yes -fl No

Of course you can also override all the other conventions as described in the previous articles of this series.


This content originally appeared on DEV Community and was authored by Riccardo Gregori


Print Share Comment Cite Upload Translate Updates
APA

Riccardo Gregori | Sciencx (2024-06-17T07:00:00+00:00) PACX ⁓ Create columns: Boolean. Retrieved from https://www.scien.cx/2024/06/17/pacx-%e2%81%93-create-columns-boolean/

MLA
" » PACX ⁓ Create columns: Boolean." Riccardo Gregori | Sciencx - Monday June 17, 2024, https://www.scien.cx/2024/06/17/pacx-%e2%81%93-create-columns-boolean/
HARVARD
Riccardo Gregori | Sciencx Monday June 17, 2024 » PACX ⁓ Create columns: Boolean., viewed ,<https://www.scien.cx/2024/06/17/pacx-%e2%81%93-create-columns-boolean/>
VANCOUVER
Riccardo Gregori | Sciencx - » PACX ⁓ Create columns: Boolean. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2024/06/17/pacx-%e2%81%93-create-columns-boolean/
CHICAGO
" » PACX ⁓ Create columns: Boolean." Riccardo Gregori | Sciencx - Accessed . https://www.scien.cx/2024/06/17/pacx-%e2%81%93-create-columns-boolean/
IEEE
" » PACX ⁓ Create columns: Boolean." Riccardo Gregori | Sciencx [Online]. Available: https://www.scien.cx/2024/06/17/pacx-%e2%81%93-create-columns-boolean/. [Accessed: ]
rf:citation
» PACX ⁓ Create columns: Boolean | Riccardo Gregori | Sciencx | https://www.scien.cx/2024/06/17/pacx-%e2%81%93-create-columns-boolean/ |

Please log in to upload a file.




There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.