Skip to main content

AdminForthResourceColumn

Extends​

Properties​

_underlineType?​

optional _underlineType?: string

Internal type which indicates original type of column in database.

Inherited from​

AdminForthResourceColumnCommon._underlineType

allowMinMaxQuery?​

optional allowMinMaxQuery?: boolean

Allow AdminForth to execute SELECT min(column) and SELECT max(column) queries to get min and max values for this column. This would improve UX of filters by adding sliders for numeric columns.

NOTE: By default is option is false to prevent performance issues on large tables. If you are going to set it to true, make sure you have a one-item index on this column (one index for each column which has it) or ensure your table will not have a large number of records.

Inherited from​

AdminForthResourceColumnInputCommon.allowMinMaxQuery

allowModifyWhenNotShowInCreate?​

optional allowModifyWhenNotShowInCreate?: boolean

Allows setting this column on Create requests even when showIn.create resolves to false.

Default is false.

This is useful for custom create components which update hidden/technical fields via update:recordFieldValue.

Inherited from​

AdminForthResourceColumnInputCommon.allowModifyWhenNotShowInCreate

allowModifyWhenNotShowInEdit?​

optional allowModifyWhenNotShowInEdit?: boolean

Allows updating this column on Edit requests even when showIn.edit resolves to false.

Default is false.

This is useful for custom edit components which update hidden/technical fields via update:recordFieldValue.

Inherited from​

AdminForthResourceColumnInputCommon.allowModifyWhenNotShowInEdit

backendOnly?​

optional backendOnly?: BackendOnlyInput

components?​

optional components?: AdminForthFieldComponents

Custom components which will be used to render this field in the admin panel.

Inherited from​

AdminForthResourceColumnInputCommon.components

editingNote?​

optional editingNote?: object

Whether AdminForth will show editing note near the field in edit/create form.

create?​

optional create?: string

edit?​

optional edit?: string

Inherited from​

AdminForthResourceColumnCommon.editingNote

editReadonly?​

optional editReadonly?: boolean

Whether AdminForth will allow to edit this field in editing mode.

Inherited from​

AdminForthResourceColumnInputCommon.editReadonly

enforceLowerCase?​

optional enforceLowerCase?: boolean

Will automatically convert any capital letters to lowercase in input during editing

Inherited from​

AdminForthResourceColumnInputCommon.enforceLowerCase

enum?​

optional enum?: AdminForthColumnEnumItem[]

Enum of possible values for this field.

Inherited from​

AdminForthResourceColumnInputCommon.enum

extra?​

optional extra?: object

An optional configuration object for extra settings.

jsonCollapsedLevel?​

optional jsonCollapsedLevel?: number

How many levels of JSON are open on the show page and in the popover of a list cell, deeper nodes start folded. 0 means - the root is folded into one line, a click opens it 1 means - the keys of the root are shown, their values are folded into one line each A node which fits in one line (up to 60 characters) is always shown whole.

Default is 1.

Inherited from​

AdminForthResourceColumnInputCommon.extra

fillOnCreate?​

optional fillOnCreate?: FillOnCreateFunction

Called on the backend when the record is saved to a database. Value returned by fillOnCreate will be saved to the database.

Inherited from​

AdminForthResourceColumnInputCommon.fillOnCreate

filterOptions?​

optional filterOptions?: object

debounceTimeMs?​

optional debounceTimeMs?: number

Decrease number of requests by adding debounce time to filter requests.

multiselect?​

optional multiselect?: boolean

Boolean value that determines what select input type to display on filter page.

substringSearch?​

optional substringSearch?: boolean

If false - will force EQ operator for filter instead of ILIKE.

Inherited from​

AdminForthResourceColumnInputCommon.filterOptions

foreignResource?​

optional foreignResource?: AdminForthForeignResource

Foreign resource which has pk column with values same that written in this column.

Overrides​

AdminForthResourceColumnInputCommon.foreignResource

inputPrefix?​

optional inputPrefix?: string

Prefix and suffix for input field on create and edit pages.

Inherited from​

AdminForthResourceColumnInputCommon.inputPrefix

inputSuffix?​

optional inputSuffix?: string

Inherited from​

AdminForthResourceColumnInputCommon.inputSuffix

isArray?​

optional isArray?: object

Defines whether column is array and what type of items it contains. AdminForth will use this information to render proper input fields in the admin panel with control buttons to add and remove items. If enabled, requires column type to be JSON. Cannot be used with masked columns, columns with foreignResource or primary key columns.

allowDuplicateItems?​

optional allowDuplicateItems?: boolean

If enabled, AdminForth will allow to add items with the same value.

enabled​

enabled: boolean

itemType​

itemType: AdminForthDataTypes

Type of items in array. Cannot be JSON or RICHTEXT.

Inherited from​

AdminForthResourceColumnInputCommon.isArray

isUnique?​

optional isUnique?: boolean

Whether AdminForth will request user to enter unique value during creating or editing record. This option causes AdminForth to make a request to database to check if value is unique. (Constraints are not used, so for large-tables performance make sure you have unique index in database if you set this option to true)

Inherited from​

AdminForthResourceColumnInputCommon.isUnique

label?​

optional label?: string

How column can be labled in the admin panel. Use it for renaming columns. Defaulted to column name with Uppercased first letter.

Inherited from​

AdminForthResourceColumnInputCommon.label

listCssClass?​

optional listCssClass?: string

Custom CSS class applied to the column in list view header and cells.

Inherited from​

AdminForthResourceColumnInputCommon.listCssClass

listSticky?​

optional listSticky?: boolean

Sticky position for column

Inherited from​

AdminForthResourceColumnInputCommon.listSticky

masked?​

optional masked?: boolean

Masked fields will be displayed as ***** on Edit and Create pages.

Inherited from​

AdminForthResourceColumnInputCommon.masked

max?​

optional max?: number

Maximum value stored in this field.

Inherited from​

AdminForthResourceColumnCommon.max

maxLength?​

optional maxLength?: number

Maximum length of string that can be entered in this field.

Inherited from​

AdminForthResourceColumnInputCommon.maxLength

maxValue?​

optional maxValue?: number

Maximum value that can be entered in this field.

Inherited from​

AdminForthResourceColumnInputCommon.maxValue

min?​

optional min?: number

Minimal value stored in this field.

Inherited from​

AdminForthResourceColumnCommon.min

minLength?​

optional minLength?: number

Minimum length of string that can be entered in this field.

Inherited from​

AdminForthResourceColumnInputCommon.minLength

minValue?​

optional minValue?: number

Minimum value that can be entered in this field.

Inherited from​

AdminForthResourceColumnInputCommon.minValue

name​

name: string

Column name in database.

Inherited from​

AdminForthResourceColumnInputCommon.name

normalize?​

optional normalize?: (value) => any

Normalizes a column value before AdminForth CRUD create and update operations and, when this column is configured as auth.usernameField, before the password-login lookup.

Does not normalize filter values or existing stored records.

Parameters​

ParameterType
valueany

Returns​

any

Example​

normalize: (value: string) => value.trim().toLowerCase(),

Inherited from​

AdminForthResourceColumnInputCommon.normalize

primaryKey?​

optional primaryKey?: boolean

Whether to use this column as record identifier. Only one column can be primary key. AdminForth tries to guess primary key automatically first.

Inherited from​

AdminForthResourceColumnInputCommon.primaryKey

required?​

optional required?: object

Whether AdminForth will require this field to be filled in create and edit forms. Can be set to boolean or object with create and edit properties. If boolean, it will be used for both create and edit forms.

create?​

optional create?: boolean

edit?​

optional edit?: boolean

Inherited from​

AdminForthResourceColumnCommon.required

showIf?​

optional showIf?: Predicate

Show field only if certain conditions are met.

Inherited from​

AdminForthResourceColumnInputCommon.showIf

showIn?​

optional showIn?: ShowIn

sortable?​

optional sortable?: boolean

Whether to allow this column to be sortable in list view. If true, AdminForth will add sorting buttons to the column header in list view and clicking on it will change sorting state of the column.

Inherited from​

AdminForthResourceColumnInputCommon.sortable

suggestOnCreate?​

optional suggestOnCreate?: string | number | boolean | object | suggestOnCreateFunction

Single value that will be substituted in create form. User can change it before saving the record.

Inherited from​

AdminForthResourceColumnInputCommon.suggestOnCreate

type?​

optional type?: AdminForthDataTypes

Type of data in column. AdminForth will use this information to render proper input fields in the admin panel. AdminForth tries to guess type of data from database column type automatically for typed databases like SQL-based. However you can explicitly set it to any value. E.g. set AdminForthDataTypes.DATETIME for your string column in SQLite, which stores ISO date strings.

Inherited from​

AdminForthResourceColumnInputCommon.type

validation?​

optional validation?: ValidationObject[]

Runtime validation Regexp rules for this field.

Inherited from​

AdminForthResourceColumnInputCommon.validation

virtual?​

optional virtual?: boolean

Allows to make the field which does not exist in database table. Examples: add custom show field with user country flag:

{
 label: 'Country Flag',
 type: AdminForthDataTypes.STRING,
 virtual: true,
 showIn: {
   [AdminForthResourcePages.edit]: false,
   [AdminForthResourcePages.create]: false,
   [AdminForthResourcePages.filter]: false,
 },
 components: {
   show: '@@/CountryFlag.vue',
   list: '@@/CountryFlag.vue',
  },
}

This field will be displayed in show and list views with custom component CountryFlag.vue. CountryFlag.vue should be placed in custom folder and can be next:

<template>
 {{ getFlagEmojiFromIso(record.ipCountry) }}
</template>

<script setup>
const props = defineProps(['record']);

function getFlagEmojiFromIso(iso) {
   return iso.toUpperCase().replace(/./g, (char) => String.fromCodePoint(char.charCodeAt(0) + 127397));
}
</script>

Inherited from​

AdminForthResourceColumnInputCommon.virtual