.. only:: html .. index:: Attribute table .. _layout_table_item: The Attribute Table Item ======================== .. only:: html .. contents:: :local: Any layer in the project can have its attributes shown in the print layout. You can use this to decorate and explain your map with information about underlying data. Use the |addTable| :guilabel:`Add Attribute Table` tool following :ref:`items creation instructions ` to add a new map item that you can later manipulate the same way as exposed in :ref:`interact_layout_item`. By default, a new attribute table item loads first rows of the first (alphabetically sorted) layer, with all the fields. You can however customize the table thanks to its :guilabel:`Item Properties` panel. Other than the :ref:`items common properties `, this feature has the following functionalities (see figure_layout_table_): .. _figure_layout_table: .. figure:: img/attribute_properties.png :align: center Attribute table Item Properties Panel Main properties --------------- The :guilabel:`Main properties` group of the attribute table provides the following functionalities (see figure_layout_table_ppt_): .. _figure_layout_table_ppt: .. figure:: img/attribute_mainproperties.png :align: center Attribute table Main properties Group * For :guilabel:`Source` you can by default only select **Layer features** allowing you to select a :guilabel:`Layer` from the vector layers loaded in the project. The |dataDefined| :sup:`data-defined override` button near the layer list allows you to dynamically change the layer which is used to populate the table, e.g. you could fill the attribute table with different layer attributes per atlas page. Note that the table structure used (:ref:`column settings `) is the one of the layer shown in the :guilabel:`Layer` drop-down list and it is left intact, meaning that setting a data defined table to a layer with different field(s) will result in empty column(s) in the table. In case you activate the |checkbox|:guilabel:`Generate an atlas` option in the :guilabel:`Atlas` panel (see :ref:`atlas_generation`), there are two additional :guilabel:`Source` possible: * **Current atlas feature** (see figure_layout_table_atlas_): you won't see any option to choose the layer, and the table item will only show a row with the attributes from the current feature of the atlas coverage layer. * and **Relation children** (see figure_layout_table_relation_): an option with the relation names will show up. This feature can only be used if you have defined a :ref:`relation ` using your atlas coverage layer as parent, and the table will show the children rows of the atlas coverage layer's current feature. * The button :guilabel:`Refresh Table Data` can be used to refresh the table when the actual contents of the table has changed. .. _figure_layout_table_atlas: .. figure:: img/attribute_mainatlas.png :align: center Attribute table Main properties for 'Current atlas feature' .. _figure_layout_table_relation: .. figure:: img/attribute_mainrelation.png :align: center Attribute table Main properties for 'Relation children' * The button :guilabel:`Attributes...` starts the :guilabel:`Select Attributes` dialog, (see figure_layout_table_select_) that can be used to change the visible contents of the table. The upper part of the window shows the list of the attributes to display and the lower part helps you sort the data. .. _figure_layout_table_select: .. figure:: img/attribute_select.png :align: center Attribute table Select attributes Dialog In the :guilabel:`Columns` section you can: * Move attributes up or down the list by selecting the rows and then using the |arrowUp| and |arrowDown| buttons to shift the rows. Multiple rows can be selected and moved at any one time. * Add an attribute with the |signPlus| button. This will add an empty row at the bottom of the table where you can select a field to be the attribute value or create an attribute via a regular expression. * Remove an attribute with the |signMinus| button. Multiple rows can be selected and removed at any one time. * Reset the attribute table back to its default state with the :guilabel:`Reset` button. * Clear the table using the :guilabel:`Clear` button. This is useful when you have a large table but only want to show a small number of attributes. Instead of manually removing each row, it may be quicker to clear the table and add the rows needed. * Cell headings can be altered by adding the custom text in the :guilabel:`Heading` column. * Cell alignment can be managed with the :guilabel:`Alignment` column which will dictate the texts position within the table cell. * Cell width can be manually managed by adding custom values to the :guilabel:`width` column. In the :guilabel:`Sorting` section you can: * Add an attribute to sort the table with. Select an attribute and set the sorting order to **Ascending** or **Descending** and press the |signPlus| button. A new line is added to the sort order list. * select a row in the list and use the |arrowUp| and |arrowDown| buttons to change the sort priority on attribute level. Selecting a cell in the :guilabel:`Sort Order` column helps you change the sorting order of the attribute field. * use the |signMinus| button to remove an attribute from the sort order list. Feature filtering ----------------- The :guilabel:`Feature filtering` group of the attribute table provides the following functionalities (see figure_layout_table_filter_): .. _figure_layout_table_filter: .. figure:: img/attribute_filter.png :align: center Attribute table Feature filtering Group You can: * Define the :guilabel:`Maximum rows` to be displayed. * Activate |checkbox| :guilabel:`Remove duplicate rows from table` to show unique records only. * Activate |checkbox| :guilabel:`Show only visible features within a map` and select the corresponding :guilabel:`Linked map` whose visible features attributes will be displayed. * Activate |checkbox| :guilabel:`Show only features intersecting Atlas feature` is only available when |checkbox| :guilabel:`Generate an atlas` is activated. When activated it will show a table with only the features which intersect the current atlas feature. * Activate |checkbox| :guilabel:`Filter with` and provide a filter by typing in the input line or insert a regular expression using the given |expression| expression button. A few examples of filtering statements you can use when you have loaded the airports layer from the Sample dataset: * ``ELEV > 500`` * ``NAME = 'ANIAK'`` * ``NAME NOT LIKE 'AN%'`` * ``regexp_match( attribute( $currentfeature, 'USE' ) , '[i]')`` The last regular expression will include only the airports that have a letter 'i' in the attribute field 'USE'. Appearance ---------- The :guilabel:`Appearance` group of the attribute table provides the following functionalities (see figure_layout_table_appearance_): .. _figure_layout_table_appearance: .. figure:: img/attribute_appearance.png :align: center Attribute table appearance Group * Click |checkbox| :guilabel:`Show empty rows` to fill the attribute table with empty cells. This option can also be used to provide additional empty cells when you have a result to show! * With :guilabel:`Cell margins` you can define the margin around text in each cell of the table. * With :guilabel:`Display header` you can select from a list one of 'On first frame', 'On all frames' default option, or 'No header'. * The option :guilabel:`Empty table` controls what will be displayed when the result selection is empty. * **Draw headers only**, will only draw the header except if you have chosen 'No header' for :guilabel:`Display header`. * **Hide entire table**, will only draw the background of the table. You can activate |checkbox| :guilabel:`Don't draw background if frame is empty` in :guilabel:`Frames` to completely hide the table. * **Show set message**, will draw the header and adds a cell spanning all columns and display a message like 'No result' that can be provided in the option :guilabel:`Message to display` * The option :guilabel:`Message to display` is only activated when you have selected **Show set message** for :guilabel:`Empty table`. The message provided will be shown in the table in the first row, when the result is an empty table. * With :guilabel:`Background color` you can set the background color of the table using the :ref:`color selector ` widget. The :guilabel:`Advanced customization` option helps you define different background colors for each cell (see figure_layout_table_background_) .. _figure_layout_table_background: .. figure:: img/attribute_background.png :align: center Attribute table Advanced Background Dialog * With the :guilabel:`Wrap text on` option, you can define a character on which the cell content will be wraped each time it is met * With :guilabel:`Oversized text` you define the behavior when the width set for a column is smaller than its content's length. It can be **Wrap text** or **Truncate text**. Show grid --------- The :guilabel:`Show grid` group of the attribute table provides the following functionalities (see figure_layout_table_grid_): .. _figure_layout_table_grid: .. figure:: img/attribute_grid.png :align: center Attribute table Show grid Group * Activate |checkbox| :guilabel:`Show grid` when you want to display the grid, the outlines of the table cells. You can also select to either :guilabel:`Draw horizontal lines` or :guilabel:`Draw vertical lines` or both. * With :guilabel:`Line width` you can set the thickness of the lines used in the grid. * The :guilabel:`Color` of the grid can be set using the color selection widget. Fonts and text styling ---------------------- The :guilabel:`Fonts and text styling` group of the attribute table provides the following functionalities (see figure_layout_table_fonts_): .. _figure_layout_table_fonts: .. figure:: img/attribute_fonts.png :align: center Attribute table Fonts and text styling Group * You can define :guilabel:`Font` and :guilabel:`Color` for :guilabel:`Table heading` and :guilabel:`Table contents`, using font and color selector widgets. * For :guilabel:`Table heading` you can additionally set the :guilabel:`Alignment` to ``Follow column alignment`` or override this setting by choosing ``Left``, ``Center`` or ``Right``. The column alignment is set using the :guilabel:`Select Attributes` dialog (see figure_layout_table_select_ ). Frames ------- The :guilabel:`Frames` group of the attribute table properties provides the following functionalities (see figure_layout_table_frames_): .. _figure_layout_table_frames: .. figure:: img/attribute_frame.png :align: center Attribute table Frames Group * With :guilabel:`Resize mode` you can select how to render the attribute table contents: * ``Use existing frames`` displays the result in the first frame and added frames only. * ``Extend to next page`` will create as many frames (and corresponding pages) as necessary to display the full selection of attribute table. Each frame can be moved around on the layout. If you resize a frame, the resulting table will be divided up between the other frames. The last frame will be trimmed to fit the table. * ``Repeat until finished`` will also create as many frames as the `Extend to next page` option, except all frames will have the same size. * Use the :guilabel:`Add Frame` button to add another frame with the same size as selected frame. The result of the table that will not fit in the first frame will continue in the next frame when you use the Resize mode ``Use existing frames``. * Activate |checkbox| :guilabel:`Don't export page if frame is empty` prevents the page to be exported when the table frame has no contents. This means all other layout items, maps, scalebars, legends etc. will not be visible in the result. * Activate |checkbox| :guilabel:`Don't draw background if frame is empty` prevents the background to be drawn when the table frame has no contents. .. Substitutions definitions - AVOID EDITING PAST THIS LINE This will be automatically updated by the find_set_subst.py script. If you need to create a new substitution manually, please add it also to the substitutions.txt file in the source folder. .. |addTable| image:: /static/common/mActionAddTable.png :width: 1.5em .. |arrowDown| image:: /static/common/mActionArrowDown.png :width: 1.5em .. |arrowUp| image:: /static/common/mActionArrowUp.png :width: 1.5em .. |checkbox| image:: /static/common/checkbox.png :width: 1.3em .. |dataDefined| image:: /static/common/mIconDataDefine.png :width: 1.5em .. |expression| image:: /static/common/mIconExpression.png :width: 1.5em .. |signMinus| image:: /static/common/symbologyRemove.png :width: 1.5em .. |signPlus| image:: /static/common/symbologyAdd.png :width: 1.5em