EditColumn
==========

Base class: :doc:`Column`

The column class for `EditTable`.

Parameters with the prefix `filter__` will be passed along downstream to the `Filter` instance if applicable. This can be used to tweak the filtering of a column.

Refinable members
-----------------


`after`       (:ref:`evaluated <evaluate>`)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Set the order of columns, see the `howto on ordering <https://docs.iommi.rocks/cookbook_tables.html#how-do-i-reorder-columns>`_ for an example.

Type: `int | str`

    See :ref:`after <after>`


Cookbook:
    :ref:`reorder-columns`


`assets`
^^^^^^^^

Type: `Namespace`

    See :ref:`assets <assets>`


`attr`       (:ref:`evaluated <evaluate>`)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

What attribute to use, defaults to same as name. Follows django conventions to access properties of properties, so `foo__bar` is equivalent to the python code `foo.bar`. This parameter is based on the name of the Column if you use the declarative style of creating tables.

Type: `str`

    See :ref:`attr <attr>`


Cookbook:
    :ref:`fk-related-data-access`

    :ref:`attr-name-diff`


`auto_rowspan`       (:ref:`evaluated <evaluate>`)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

enable automatic rowspan for this column. To join two cells with rowspan, just set this `auto_rowspan` to `True` and make those two cells output the same text and we'll handle the rest.

Type: `bool`

Default: `False`

Cookbook:
    :ref:`rowspan`


`bulk`
^^^^^^

Namespace to configure bulk actions. See `howto on bulk editing <https://docs.iommi.rocks/cookbook_tables.html#how-do-i-enable-bulk-editing>`_ for an example and more information.

Type: `Namespace`


Cookbook:
    :ref:`bulk-edit`


`cell`
^^^^^^

Customize the cell, see `howto on rendering <https://docs.iommi.rocks/cookbook_tables.html#how-do-i-customize-the-rendering-of-a-cell>`_ and `howto on links <https://docs.iommi.rocks/cookbook_tables.html#how-do-i-make-a-link-in-a-cell>`_

Type: `Namespace`


Cookbook:
    :ref:`customize-table-cell-render`

    :ref:`row-numbers`

    :ref:`column-computed-data`

    :ref:`nested-fk`

    :ref:`attr-name-diff`

    :ref:`cell-link`


`choices`       (:ref:`evaluated <evaluate>`)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Type: `Iterable`


Cookbook:
    :ref:`column-choices`


`config_from_model`
^^^^^^^^^^^^^^^^^^^

Type: `Namespace`


`data_retrieval_method`       (:ref:`evaluated <evaluate>`)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Default: `DataRetrievalMethods.attribute_access`

Cookbook:
    :ref:`data-retrieval-method`


`display_name`
^^^^^^^^^^^^^^

the text of the header for this column. By default this is based on the `_name` so normally you won't need to specify it.

    See :ref:`name <name>`


Cookbook:
    :ref:`header-title`


`endpoints`
^^^^^^^^^^^

Type: `Namespace`

    See :ref:`endpoints <endpoints>`


`extra`
^^^^^^^

Type: `dict[str, Any]`

    See :ref:`extra <extra>`


`extra_evaluated`
^^^^^^^^^^^^^^^^^

Type: `dict[str, Any]`

    See :ref:`extra <extra>`


Cookbook:
    :ref:`table-as-csv`


`extra_params`
^^^^^^^^^^^^^^

    See :ref:`extra_params <extra_params>`


`field`
^^^^^^^

Type: `Field | None`


Cookbook:
    :ref:`edit-table-one-to-one`


`filter`
^^^^^^^^

Type: `Namespace`


Cookbook:
    :ref:`filter-column`


`group`       (:ref:`evaluated <evaluate>`)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

string describing the group of the header. If this parameter is used the header of the table now has two rows. Consecutive identical groups on the first level of the header are joined in a nice way.

Type: `str | None`


Cookbook:
    :ref:`group-columns`


`header`       (:ref:`evaluated <evaluate>`)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Type: `Namespace`


Cookbook:
    :ref:`customize-header`


`include`       (:ref:`evaluated <evaluate>`)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

set this to `False` to hide the column

Type: `bool`

    See :ref:`include <include>`


Cookbook:
    :ref:`reverse-m2m`

    :ref:`show-columns`

    :ref:`reverse-fk-table`


`iommi_style`
^^^^^^^^^^^^^

Type: `str | Style | None`

    See :ref:`iommi_style <iommi_style>`


`model`       (:ref:`evaluated <evaluate>`)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Type: `type[Model] | None`


Cookbook:
    :ref:`table-model-introspection`


`model_field`
^^^^^^^^^^^^^


Cookbook:
    :ref:`table-model-introspection`


`model_field_name`
^^^^^^^^^^^^^^^^^^


Cookbook:
    :ref:`table-model-introspection`


`render_column`       (:ref:`evaluated <evaluate>`)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

If set to `False` the column won't be rendered in the table, but still be available in `table.columns`. This can be useful if you want some other feature from a column like filtering.

Type: `bool`

Default: `True`

Cookbook:
    :ref:`show-columns`


`row_group`       (:ref:`evaluated <evaluate>`)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Type: `Namespace`


Cookbook:
    :ref:`group-rows`


`sort_default_desc`       (:ref:`evaluated <evaluate>`)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Set to `True` to make table sort link to sort descending first.

Type: `bool`

Default: `False`

Cookbook:
    :ref:`sort-direction`


`sort_key`
^^^^^^^^^^

string denoting what value to use as sort key when this column is selected for sorting. (Or callable when rendering a table from list.)


Cookbook:
    :ref:`custom-sort-key`


`sortable`       (:ref:`evaluated <evaluate>`)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

set this to `False` to disable sorting on this column

Type: `bool`

Default: `iommi.table.default_sortable`

Cookbook:
    :ref:`table-sorting`


`superheader`       (:ref:`evaluated <evaluate>`)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^


Cookbook:
    :ref:`superheader`


Shortcuts
---------

`EditColumn.boolean`
^^^^^^^^^^^^^^^^^^^^

Shortcut to render booleans as a check mark if true or blank if false.

.. code-block:: python

    table = Table(
        columns__name=Column(),
        columns__boolean=Column.boolean(),
        rows=[
            Struct(name='true!', boolean=True),
            Struct(name='false!', boolean=False),
        ]
    )

.. raw:: html

    <div class="iframe_collapse" onclick="toggle('a638c61d-75e5-4094-a316-4338be5679d9', this)">▼ Hide result</div>
    <iframe id="a638c61d-75e5-4094-a316-4338be5679d9" src="doc_includes/EditColumn/test_base.html" style="background: white; display: ; width: 100%; min-height: 100px; border: 1px solid gray;"></iframe>
    <div class="show_structure_toggler"><span onclick="toggle_iframe_structure_overlay()">Toggle structure</span></div>

Defaults
++++++++

* `filter__call_target__attribute`
    * `boolean`
* `filter__field__call_target__attribute`
    * `boolean_tristate`
* `bulk__call_target__attribute`
    * `boolean`
* `cell__format`
    * `lambda value, **_: mark_safe(f'<span title="{gettext_lazy("Yes")}">&#10004;</span>') if value else ''`

`EditColumn.boolean_tristate`
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

This shortcut sets up `boolean_tristate` for the filter.



Parent: EditColumn.boolean_

Defaults
++++++++

* `filter__call_target__attribute`
    * `boolean_tristate`

`EditColumn.choice`
^^^^^^^^^^^^^^^^^^^

This shortcut sets up `choices` for the filter and bulk form.



Defaults
++++++++

* `bulk__call_target__attribute`
    * `choice`
* `bulk__choices`
    * `iommi.table.get_choices_from_column`
* `filter__call_target__attribute`
    * `choice`
* `filter__choices`
    * `iommi.table.get_choices_from_column`

`EditColumn.choice_queryset`
^^^^^^^^^^^^^^^^^^^^^^^^^^^^

This shortcut sets up `choices` for the filter and bulk form for the choice queryset case.



Parent: EditColumn.choice_

Defaults
++++++++

* `bulk__call_target__attribute`
    * `choice_queryset`
* `filter__call_target__attribute`
    * `choice_queryset`

`EditColumn.date`
^^^^^^^^^^^^^^^^^

Defaults
++++++++

* `filter__call_target__attribute`
    * `date`
* `filter__query_operator_to_q_operator`
    * `lambda op: {'=': 'exact', ':': 'contains'}.get(op)`
* `bulk__call_target__attribute`
    * `date`

`EditColumn.datetime`
^^^^^^^^^^^^^^^^^^^^^

Defaults
++++++++

* `filter__call_target__attribute`
    * `datetime`
* `filter__query_operator_to_q_operator`
    * `lambda op: {'=': 'exact', ':': 'contains'}.get(op)`
* `bulk__call_target__attribute`
    * `datetime`

`EditColumn.decimal`
^^^^^^^^^^^^^^^^^^^^

Defaults
++++++++

* `bulk__call_target__attribute`
    * `decimal`
* `filter__call_target__attribute`
    * `decimal`

`EditColumn.delete`
^^^^^^^^^^^^^^^^^^^

Defaults
++++++++

* `header__template`
    * `iommi/table/header.html`
* `sortable`
    * `False`
* `filter__is_valid_filter`
    * `lambda **_: (True, '')`
* `filter__field__include`
    * `False`
* `attr`
    * `None`
* `display_name`
    * `Delete`
* `cell__attrs__class__delete`
    * `True`
* `cell__attrs__data-iommi-edit-table-delete-row-cell`
    * `True`

`EditColumn.download`
^^^^^^^^^^^^^^^^^^^^^

Shortcut for creating a clickable download icon. The URL defaults to `your_object.get_absolute_url() + 'download/'`. Specify the option cell__url to override.

.. code-block:: python

    table = Table(
        auto__model=Album,
        columns__download=Column.download(),
    )

.. raw:: html

    <div class="iframe_collapse" onclick="toggle('6bbdcf16-c63b-48c1-aba0-c784c82a75e7', this)">▼ Hide result</div>
    <iframe id="6bbdcf16-c63b-48c1-aba0-c784c82a75e7" src="doc_includes/EditColumn/test_base1.html" style="background: white; display: ; width: 100%; min-height: 100px; border: 1px solid gray;"></iframe>
    <div class="show_structure_toggler"><span onclick="toggle_iframe_structure_overlay()">Toggle structure</span></div>

Parent: EditColumn.icon_

Defaults
++++++++

* `cell__url`
    * `lambda row, **_: row.get_absolute_url() + 'download/'`
* `cell__value`
    * `lambda row, **_: getattr(row, 'pk', False)`
* `display_name`
    * `Download`

`EditColumn.duration`
^^^^^^^^^^^^^^^^^^^^^

Parent: EditColumn.text_

Defaults
++++++++

* `bulk__call_target__attribute`
    * `duration`
* `filter__call_target__attribute`
    * `duration`

`EditColumn.edit`
^^^^^^^^^^^^^^^^^

Shortcut for creating a clickable edit icon. The URL defaults to `your_object.get_absolute_url() + 'edit/'`. Specify the option cell__url to override.

.. code-block:: python

    table = Table(
        auto__model=Album,
        columns__edit=Column.edit(after=0),
    )

.. raw:: html

    <div class="iframe_collapse" onclick="toggle('934b8321-f8ce-42e3-94ff-21181491aaf7', this)">▼ Hide result</div>
    <iframe id="934b8321-f8ce-42e3-94ff-21181491aaf7" src="doc_includes/EditColumn/test_base2.html" style="background: white; display: ; width: 100%; min-height: 100px; border: 1px solid gray;"></iframe>
    <div class="show_structure_toggler"><span onclick="toggle_iframe_structure_overlay()">Toggle structure</span></div>

Parent: EditColumn.icon_

Defaults
++++++++

* `cell__url`
    * `lambda row, **_: row.get_absolute_url() + 'edit/'`
* `display_name`
    * `Edit`

`EditColumn.email`
^^^^^^^^^^^^^^^^^^

Defaults
++++++++

* `filter__call_target__attribute`
    * `email`
* `bulk__call_target__attribute`
    * `email`

`EditColumn.file`
^^^^^^^^^^^^^^^^^

Defaults
++++++++

* `bulk__call_target__attribute`
    * `file`
* `filter__call_target__attribute`
    * `file`
* `cell__format`
    * `lambda value, **_: str(value)`

`EditColumn.float`
^^^^^^^^^^^^^^^^^^

Parent: EditColumn.number_

Defaults
++++++++

* `filter__call_target__attribute`
    * `float`
* `bulk__call_target__attribute`
    * `float`

`EditColumn.foreign_key`
^^^^^^^^^^^^^^^^^^^^^^^^

`EditColumn.foreign_key_reverse`
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Defaults
++++++++

* `bulk__call_target__attribute`
    * `foreign_key_reverse`
* `filter__call_target__attribute`
    * `foreign_key_reverse`
* `cell__format`
    * `lambda value, **_: ', '.join(['%s' % x for x in value.all()])`
* `data_retrieval_method`
    * `DataRetrievalMethods.prefetch`
* `sortable`
    * `False`
* `extra__django_related_field`
    * `True`
* `display_name`
    * `lambda column, **_: capitalize(column.model_field.remote_field.model._meta.verbose_name_plural)`

`EditColumn.icon`
^^^^^^^^^^^^^^^^^

Shortcut to create font awesome-style icons.



Parameters
++++++++++

* `extra__icon`
    * `the name of the icon`

Defaults
++++++++

* `display_name`
    * `""`
* `cell__value`
    * `lambda table, **_: True`
* `cell__format`
    * `iommi.table.default_icon__cell__format`
* `attr`
    * `None`

`EditColumn.integer`
^^^^^^^^^^^^^^^^^^^^

Parent: EditColumn.number_

Defaults
++++++++

* `filter__call_target__attribute`
    * `integer`
* `bulk__call_target__attribute`
    * `integer`

`EditColumn.link`
^^^^^^^^^^^^^^^^^

Shortcut for creating a cell that is a link. The URL is the result of calling `get_absolute_url()` on the object.




Cookbook:
    :ref:`custom-actions`

`EditColumn.many_to_many`
^^^^^^^^^^^^^^^^^^^^^^^^^

Parent: EditColumn.related_multiple_

`EditColumn.many_to_many_reverse`
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Defaults
++++++++

* `bulk__call_target__attribute`
    * `many_to_many_reverse`
* `filter__call_target__attribute`
    * `many_to_many_reverse`

`EditColumn.multi_choice`
^^^^^^^^^^^^^^^^^^^^^^^^^

This shortcut sets up `choices` for the filter and bulk form for the multi choice case.



Parent: EditColumn.choice_

Defaults
++++++++

* `bulk__call_target__attribute`
    * `multi_choice`
* `filter__call_target__attribute`
    * `multi_choice`

`EditColumn.multi_choice_queryset`
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

This shortcut sets up `choices` for the filter and bulk form for the multi choice queryset case.



Parent: EditColumn.choice_queryset_

Defaults
++++++++

* `bulk__call_target__attribute`
    * `multi_choice_queryset`
* `filter__call_target__attribute`
    * `multi_choice_queryset`

`EditColumn.number`
^^^^^^^^^^^^^^^^^^^

`EditColumn.related`
^^^^^^^^^^^^^^^^^^^^

Defaults
++++++++

* `bulk__call_target__attribute`
    * `related`
* `filter__call_target__attribute`
    * `related`
* `data_retrieval_method`
    * `DataRetrievalMethods.select`
* `sort_key`
    * `iommi.table.foreign_key__sort_key`
* `choices`
    * `iommi.table.related__choices`

`EditColumn.related_multiple`
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Parent: EditColumn.multi_choice_queryset_

Defaults
++++++++

* `bulk__call_target__attribute`
    * `many_to_many`
* `filter__call_target__attribute`
    * `many_to_many`
* `cell__format`
    * `lambda value, **_: ', '.join(['%s' % x for x in value.all()])`
* `data_retrieval_method`
    * `DataRetrievalMethods.prefetch`
* `sortable`
    * `False`
* `extra__django_related_field`
    * `True`
* `display_name`
    * `lambda column, **_: capitalize(column.model_field.remote_field.model._meta.verbose_name_plural)`
* `choices`
    * `iommi.table.related__choices`

`EditColumn.reorder_handle`
^^^^^^^^^^^^^^^^^^^^^^^^^^^

Defaults
++++++++

* `sortable`
    * `False`
* `field__call_target__attribute`
    * `hidden`
* `field__parse`
    * `iommi.form.int_parse`
* `field__include`
    * `True`
* `field__input__attrs__data-reordering-value`
    * `True`
* `cell__attrs__title`
    * `Drag and drop to reorder`
* `cell__attrs__class__reordering-handle-cell`
    * `True`
* `cell__attrs__data-iommi-reordering-handle`
    * `True`
* `after`
    * `<object object at 0x7de47dcf5350>`

`EditColumn.run`
^^^^^^^^^^^^^^^^

Shortcut for creating a clickable run icon. The URL defaults to `your_object.get_absolute_url() + 'run/'`. Specify the option cell__url to override.

.. code-block:: python

    table = Table(
        auto__model=Album,
        columns__run=Column.run(),
    )

.. raw:: html

    <div class="iframe_collapse" onclick="toggle('48a0da67-d345-4a24-9653-e823c786323c', this)">▼ Hide result</div>
    <iframe id="48a0da67-d345-4a24-9653-e823c786323c" src="doc_includes/EditColumn/test_base3.html" style="background: white; display: ; width: 100%; min-height: 100px; border: 1px solid gray;"></iframe>
    <div class="show_structure_toggler"><span onclick="toggle_iframe_structure_overlay()">Toggle structure</span></div>

Parent: EditColumn.icon_

Defaults
++++++++

* `cell__url`
    * `lambda row, **_: row.get_absolute_url() + 'run/'`
* `display_name`
    * `Run`

`EditColumn.select`
^^^^^^^^^^^^^^^^^^^

Shortcut for a column of checkboxes to select rows. This is useful for implementing bulk operations.

By default tables have a column named `select` that is used for this purpose. It is shown
automatically when bulk editing or a bulk action is enabled, and is otherwise hidden. You can
force it on (or off) by setting `columns__select__include`. See the example below.

To implement a custom post handler that operates on the selected rows, do

.. code-block:: python

    def my_handler(table):
        rows = table.selection()
        # rows will either be a queryset, or a list of elements
        # matching the type of rows of the table
        ...

    table = Table(
        auto__model=Album,
        bulk__actions__submit=Action.submit(post_handler=my_handler)
    )

.. raw:: html

    <div class="iframe_collapse" onclick="toggle('77833b5f-4c66-4934-bfcc-78d1b761587a', this)">▼ Hide result</div>
    <iframe id="77833b5f-4c66-4934-bfcc-78d1b761587a" src="doc_includes/EditColumn/test_base4.html" style="background: white; display: ; width: 100%; min-height: 100px; border: 1px solid gray;"></iframe>
    <div class="show_structure_toggler"><span onclick="toggle_iframe_structure_overlay()">Toggle structure</span></div>

Parameters
++++++++++

* `extra__checkbox_name`
    * `the name of the checkbox. Default is `"pk"`, resulting in checkboxes like `"pk_1234"`.`
* `extra__checked`
    * `callable to specify if the checkbox should be checked initially. Defaults to `False`.`

Defaults
++++++++

* `header__template`
    * `iommi/table/select_column_header.html`
* `sortable`
    * `False`
* `filter__include`
    * `False`
* `filter__is_valid_filter`
    * `lambda **_: (True, '')`
* `filter__field__include`
    * `False`
* `bulk__include`
    * `False`
* `attr`
    * `None`
* `cell__value`
    * `lambda table, cells, row, **_: (       row.pk       if isinstance(table.rows, QuerySet)       # row_index is the visible row number       # See selection() for the code that does the lookup       else cells.row_index     )`
* `cell__format`
    * `lambda column, row, value, **kwargs: format_html(       # language=HTML       '<input type="checkbox" class="checkbox" name="{checkbox_name}_{row_id}" {checked_str} />',       checkbox_name=column.extra.checkbox_name,       row_id=value,       checked_str=(         'checked'         if evaluate_strict(column.extra.checked, column=column, row=row, value=value, **kwargs)         else ''       ),     )`
* `extra__checkbox_name`
    * `pk`
* `extra__checked`
    * `lambda **_: False`
* `extra__icon`
    * `fa fa-check-square-o`

`EditColumn.substring`
^^^^^^^^^^^^^^^^^^^^^^

Defaults
++++++++

* `filter__query_operator_for_field`
    * `:`

`EditColumn.text`
^^^^^^^^^^^^^^^^^

This is an explicit synonym for `Column()`.



Defaults
++++++++

* `bulk__call_target__attribute`
    * `text`
* `filter__call_target__attribute`
    * `text`

`EditColumn.textarea`
^^^^^^^^^^^^^^^^^^^^^

Parent: EditColumn.text_

`EditColumn.time`
^^^^^^^^^^^^^^^^^

Defaults
++++++++

* `filter__call_target__attribute`
    * `time`
* `filter__query_operator_to_q_operator`
    * `lambda op: {'=': 'exact', ':': 'contains'}.get(op)`
* `bulk__call_target__attribute`
    * `time`

Methods
-------

`on_bind`
^^^^^^^^^

`on_refine_done`
^^^^^^^^^^^^^^^^

Class methods
-------------

`hardcoded`
^^^^^^^^^^^