the list presents all the columns that are extracted from the table. You can change the display order, choose to hide a column or change how the data is displayed.
You can add new columns by working the extracted data through the template engine, but if you want to extract more data you will need to modify the extraction query
The title that the column will have does not affect the data or the names of the data extracted from the template engine
When you use the search field it will search all columns for who a search type has been chosen. LIKE means that it searches within the text while = will only search for columns that match the searched text.
Text: Print the contents of the field. It doesn't render the html.
Html: Print the column and it render the html
Date: Print the date without the time
DateTime: Print date with time
Image: Print the thumbs of the image
External link: makes a link clickable. Attributes: Link text: Show alternative text. You can use the [%data.field_name] variables to show the text of another field.
Detail Link: Makes the text clickable. Opens a popup with the details of the record. You can configure the details in the detailed view of the frontend.
Serialize: show a field with serialized data
Show checkbox values (Json label): Show the values of selected checkboxes.
Custom: Use shortcodes to display column content. Click "show shortcode variables" to view the list of variables.
User: show the username starting from the ID. You can also choose whether to create the user linkable to the author page by selecting the checkbox link to author page.
Post: show the title of a post starting from the ID. You can also choose whether to create the title linkable to the article by selecting the checkbox link to article page.
Lookup [PRO]: If the id of another table is saved in the field, you can show the data of the related table through this type of field. Choose the table, then select the fields you want to show. The show attribute allows you to show one or more fields of the linked table (hold down ctrl while clicking on the fields you want to show). Created a search field, save the settings. At this point, the selected columns will appear as new fields that you can configure to your liking.
The edit fields allow you to modify the value of the field directly from the list.
Order: Allows you to sort a field by transcending. To activate it, the query must be sorted in ascending order by the column you want to sort..
Input: Allows you to modify the value of the field directly from the list.
Checkbox: When the checkbox is selected, the database field is modified with the value entered in the Checkbox value field.
Select: Allows you to modify the field with the values entered in the Select values field.
Change the content value according to the entered csv
The csv values must be separated by commas. The first value is that of the column, the second is how it should be transformed
You can use the special scripts <x, >x, OR =x-y for a range, where x and y are numbers.
example:
0, NO
1, YES
>1, MAYBE
Adds a conditional class depending on the value of the csv inserted
You can use the special writes <x, >x, OR =x-y for a range, where x and y are numbers.
here is the list of classes already configured:
0, dbp-cell-red
=1-10, dbp-cell-green