{"id":93,"date":"2011-02-17T15:53:14","date_gmt":"2011-02-17T20:53:14","guid":{"rendered":"http:\/\/cfdbplugin.com\/?page_id=93"},"modified":"2016-12-15T21:55:05","modified_gmt":"2016-12-16T02:55:05","slug":"cfdb-table","status":"publish","type":"page","link":"https:\/\/cfdbplugin.com\/?page_id=93","title":{"rendered":"[cfdb-table]"},"content":{"rendered":"

This documentation applies to version 2.6 and later<\/span><\/p>\n

Summary of Shortcode Options<\/strong><\/h1>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Option<\/strong><\/td>\nExample<\/strong><\/p>\n

 <\/td>\n

Description<\/strong><\/td>\n<\/tr>\n
form<\/strong><\/a><\/td>\n[cfdb-table form=\"myform\"<\/strong>]<\/code><\/td>\nRequired. Designates the form to display. All rows and columns are displayed by default<\/td>\n<\/tr>\n
role<\/strong><\/a><\/td>\n[cfdb-datatable form=\"myform\" role=\"Author\"<\/strong>]<\/code><\/td>\nMake short code only display output for user’s with minimum-required role. Choices are<\/p>\n
    \n
  • Administrator<\/li>\n
  • Editor<\/li>\n
  • Author<\/li>\n
  • Contributor<\/li>\n
  • Subscriber<\/li>\n
  • Anyone<\/li>\n<\/ul>\n

    WARNING<\/strong>: this setting is overridden by plugin setting in WP Admin page Contact -> Database Options -> Can See Submission when using shortcodes
    \n(since 2.4.1)<\/td>\n<\/tr>\n

show<\/strong><\/a><\/td>\n[cfdb-table form=\"myform\" show=\"col1,col2\"<\/strong>]<\/code><\/td>\nLimits columns to be shown to be those designated (comma-delimited list)<\/td>\n<\/tr>\n
hide<\/strong><\/a><\/td>\n[cfdb-table form=\"myform\" hide<\/span>=\"col1,col2\"<\/strong>]<\/code><\/td>\nDoes not show listed columns (comma-delimited list)<\/td>\n<\/tr>\n
header<\/strong><\/td>\n[cfdb-table form=\"myform\" header<\/span>=\"false\"<\/strong>]<\/code><\/td>\nShow or do not show the table header. Valid values are true<\/strong> (the default) and false<\/strong><\/td>\n<\/tr>\n
<\/a>headers<\/strong><\/td>\n[cfdb-table form=\"myform\" headers<\/span>=\"your-name=Name,ex_field1=Email\"<\/strong>]<\/code><\/td>\nAllows you to change the name displayed in the table header. Map a form field names to a more readable display names. (Since 2.5.1)<\/td>\n<\/tr>\n
limit<\/strong><\/a><\/td>\n[cfdb-table form=\"myform\"\u00a0limit=\"10\"<\/strong>]<\/code><\/td>\nOne number: limit=”10″ means show first 10 rows. Is the same as limit=”0,10″
\nTwo Numbers: limit=”100,10″ means show 10 rows starting at row #100)<\/td>\n<\/tr>\n
random<\/strong><\/a><\/td>\n[cfdb-table form=\"myform\"\u00a0random=\"2\"<\/strong>]<\/code><\/td>\nDisplay 2 random rows from those that the short code finds. (Since 2.4)<\/td>\n<\/tr>\n
orderby<\/strong><\/a><\/td>\n[cfdb-table form=\"myform\"\u00a0orderby=\"last-name,first-name\"<\/strong>]<\/code><\/td>\nSort rows by designated columns. Use “column-name desc” to sort in descending (reverse) order<\/td>\n<\/tr>\n
search<\/strong><\/a><\/td>\n[cfdb-table form=\"myform\"\u00a0search<\/span>=\"Simpson\"<\/strong>]<\/code><\/td>\nSelect rows to display that have any cell with the search text in it (case insensitive). Intended to mimic behavior of the “Search” field in the DataTable<\/td>\n<\/tr>\n
filter<\/strong><\/a><\/td>\n[cfdb-table form=\"myform\" filter<\/span>=\"col1=Simpson\"<\/strong>]<\/code><\/td>\nSelect which rows to display based on filter expression. More powerful than “search”, it can filter on multiple columns with boolean and regular expressions. If both “search” and “filter” are specified, “search” is ignored.<\/td>\n<\/tr>\n
Options specific to this shortcode<\/em><\/td>\n<\/tr>\n
id<\/strong><\/a><\/td>\n[cfdb-table form=\"myform\" id<\/span>=\"myid\"<\/strong>]<\/code><\/td>\nSets the id <\/strong>attribute on the table <\/strong>tag<\/td>\n<\/tr>\n
class<\/strong><\/a><\/td>\n[cfdb-table form=\"myform\" class<\/span>=\"myclass\"<\/strong>]<\/code><\/td>\nSets the class <\/strong>attribute on the table <\/strong>tag<\/td>\n<\/tr>\n
style<\/strong><\/a><\/td>\n[cfdb-table form=\"myform\" id=\"myid\" style<\/span>=\"#myid th > td { font-size: x-small; background-color: #E8E8E8;\u00a0 }\"<\/strong>]<\/code><\/td>\nInjects input CSS into a style tag. Use in conjunction with id <\/strong>or class <\/strong>to identify what you are styling.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

The [cfdb-table<\/code>]<\/code> short code has all the basic shortcode options. But of particular interest to this shortcode are options that help you style the resulting table.<\/p>\n

 <\/p>\n

<\/a><\/a> Apply your CSS to the table<\/strong>: set the table’s ‘class’ or ‘id’ attribute:<\/p>\n