{"id":16954207,"date":"2023-08-07T20:12:07","date_gmt":"2023-08-07T20:12:07","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/dropdown-select-using-db-data\/"},"modified":"2023-08-07T20:12:07","modified_gmt":"2023-08-07T20:12:07","slug":"dropdown-select-using-db-data","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/dropdown-select-using-db-data\/","title":{"rendered":"Dropdown Select using DB data"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">I just don&#8217;t get it. The &#8220;test data source&#8221; returns correct results. No errors in console or debug but will not show up using this:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[select vehicleyears][cf7-recordset id=&#8221;cf7-recordset-284&#8243; type=&#8221;database&#8221; query=&#8221;SELECT DISTINCT year FROM car_db&#8221;][cf7-link-field recordset=&#8221;cf7-recordset-284&#8243; field=&#8221;vehicleyears&#8221; value=&#8221;&#8221;]<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Any help would be appreciated, testing this on local currently and have the CF7 Smart Grid extension in use.<\/p>\n","protected":false},"template":"","class_list":["post-16954207","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/16954207","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/16954207\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=16954207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}