[\/et_pb_text][et_pb_text admin_label=”Text” _builder_version=”4.19.2″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]<\/p>\n
Shortcode wpdadiehard<\/strong> must be enabled: [\/et_pb_text][et_pb_text admin_label=”Text” _builder_version=”4.19.2″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][et_pb_text admin_label=”Text” _builder_version=”4.19.2″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]<\/p>\n Shortcode wpdadiehard<\/strong> can be used to add a Data Projects page to a web page. Supported shortcode parameters are:<\/p>\n [\/et_pb_text][et_pb_text admin_label=”Text” _builder_version=”4.19.2″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][et_pb_text admin_label=”Text” _builder_version=”4.19.2″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][et_pb_text admin_label=”Text” _builder_version=”4.19.2″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]There’s no need to type the shortcode. The shortcode can be copied from your Data Projects page to your clipboard and pasted into your page or post.[\/et_pb_text][et_pb_text admin_label=”Text” _builder_version=”4.19.2″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][et_pb_text admin_label=”Text” _builder_version=”4.19.2″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][et_pb_dmb_code_snippet code=”W3dwZGFkaWVoYXJkIHByb2plY3RfaWQ9IjciIHBhZ2VfaWQ9IjExIl0=” _builder_version=”4.19.2″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_dmb_code_snippet][et_pb_text _builder_version=”4.19.3″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.19.2″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.19.2″ _module_preset=”default” global_colors_info=”{}”]Use parameters filter_field_name<\/strong> and filter_field_value<\/strong> to set a filter. For example:[\/et_pb_text][et_pb_dmb_code_snippet code=”W3dwZGFkaWVoYXJkIHByb2plY3RfaWQ9IjEiIHBhZ2VfaWQ9IjEiIGZpbHRlcl9maWVsZF9uYW1lPSJsYXN0X25hbWUiIGZpbHRlcl9maWVsZF92YWx1ZT0iSm9uZXMiXQ==” _builder_version=”4.19.2″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_dmb_code_snippet][et_pb_text _builder_version=”4.19.1″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n This will show only customers with last_name = “Jones”.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.19.1″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n Adding a filter on multiple columns:<\/p>\n [\/et_pb_text][et_pb_dmb_code_snippet code=”W3dwZGFkaWVoYXJkIHByb2plY3RfaWQ9IjEiIHBhZ2VfaWQ9IjEiIGZpbHRlcl9maWVsZF9uYW1lPSJmaXJzdF9uYW1lLGxhc3RfbmFtZSIgZmlsdGVyX2ZpZWxkX3ZhbHVlPSJHcmFjZSxKb25lcyJd” _builder_version=”4.19.2″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_dmb_code_snippet][et_pb_text _builder_version=”4.19.1″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n This will show only customers with first_name = “Grace” and last_name = “Jones”.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.19.2″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.19.1″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n Please use the WHERE clause of your project page to add more complex filters (see image below)<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/wpdataaccess.com\/wp-content\/uploads\/2020\/08\/data-projects-default-where.png” title_text=”wpdadiehard” _builder_version=”4.19.1″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.19.1″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][et_pb_video src=”https:\/\/www.youtube.com\/embed\/nw5MJ6_-5SU” _builder_version=”4.19.1″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_video][et_pb_text _builder_version=”4.19.2″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.19.3″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.19.2″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.19.2″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.19.2″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Use shortcode wpdadiehard to enable data administration for a specific database table or Data Projects page on a web page.Shortcode wpdadiehard must be enabled:Plugin Settings > Plugin > Shortcode [ wpdadiehard ]Data Projects shortcodesShortcode wpdadiehard can be used to add a Data Projects page to a web page. Supported shortcode parameters are: project_id (Data Projects […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"\n Use shortcode wpdadiehard<\/strong> to add data administration for a specific table or Data Projects page to a web page.<\/p>\n\n\n\n Shortcode wpdadiehard<\/strong> must be enabled: Shortcode wpdadiehard<\/strong> can be used to add a Data Projects page to a web page. Supported shortcode parameters:<\/p>\n\n\n\n There's no need to type in the shortcode. The shortcode can be copied from Data Projects to your clipboard and pasted into your page or post.<\/p>\n\n\n\n > Click here for a live example<\/a><\/p>\n\n\n\n User defined shortcodes are still supported for backward compatibility, but no longer adviced. Please update your user defined shortcodes to Data Projects shortcodes, which are safer, easier to maintain and support more features.<\/p>\n\n\n\n Use parameters filter_field_name<\/strong> and filter_field_value<\/strong> to set a filter. For example:<\/p>\n\n\n\n This will show only customers with last_name = \"Jones\".<\/p>\n\n\n\n Adding a filter on multiple columns:<\/p>\n\n\n\n This will show only customers with first_name = \"Grace\" and last_name = \"Jones\".<\/p>\n\n\n\n Please use the WHERE clause of your project page to add more complex filters (see image below - click to enlarge)<\/p>\n\n\n\n
Plugin Settings > Plugin > Shortcode [ wpdadiehard ]<\/p>\nData Projects shortcodes<\/h2>\n
\n
Copy\/paste shortcode from a Data Project<\/h3>\n
\n
Example<\/h2>\n
\n
Adding filters<\/h2>\n
More complex filters<\/h2>\n
Video tutorial<\/h2>\n
Styling<\/h2>\n
\n
Know limitations<\/h2>\n
\n
Notes<\/h2>\n
\n
Settings > WP Data Access > Plugin > Shortcode [ wpdadiehard ]<\/p>\n\n\n\nData Projects shortcodes<\/h2>\n\n\n\n
Copy\/paste shortcode from a Data Project<\/h3>\n\n\n\n
Example<\/h4>\n\n\n\n
[wpdadiehard project_id=\"7\" page_id=\"11\"]<\/code><\/pre>\n\n\n\nUser defined shortcodes<\/h2>\n\n\n\n
Adding filters<\/h2>\n\n\n\n
[wpdadiehard project_id=\"1\" page_id=\"1\" filter_field_name=\"last_name\" filter_field_value=\"Jones\"]<\/code><\/pre>\n\n\n\n[wpdadiehard project_id=\"1\" page_id=\"1\" filter_field_name=\"first_name,last_name\" filter_field_value=\"Grace,Jones\"]<\/code><\/pre>\n\n\n\nMore complex filters<\/h2>\n\n\n\n
![\"\"](\"\/\/wpdataaccess.com\/wp-content\/uploads\/2020\/08\/data-projects-default-where.png\" "\\"WP")
<\/a><\/figure>\n\n\n\nVideo tutorial<\/h2>\n\n\n\n