{"id":3882,"date":"2023-09-21T14:01:48","date_gmt":"2023-09-21T13:01:48","guid":{"rendered":"https:\/\/help.expertsender.com\/?post_type=es&p=3882"},"modified":"2024-03-19T13:25:09","modified_gmt":"2024-03-19T12:25:09","slug":"getrowsbytemplate","status":"publish","type":"es","link":"https:\/\/help.expertsender.com\/pl\/emp\/dynamic-content\/data-tables\/getrowsbytemplate\/","title":{"rendered":"GetRowsByTemplate"},"content":{"rendered":"\n

GetRowsByTemplate<\/code> method retrieves a number of rows returned by SQL query template. To use a template, it needs to be defined in ExpertSender web panel first. Template can be any valid SQL query that returns rows (SELECT<\/code> query). It is possible to create templates with parameters.<\/p>\n\n\n\n

1. Method signature<\/strong><\/p>\n\n\n\n

<\/path><\/path><\/svg><\/span>
rows <\/span>=<\/span> <\/span>GetRowsByTemplate<\/span>(template<\/span>,<\/span> parameters)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Parameter definition<\/p>\n\n\n\n
Name<\/th>Type<\/th>Description<\/th><\/tr><\/thead>
template<\/td>string<\/td>Required. Template name.<\/td><\/tr>
parameters<\/td>array of Param objects<\/td>Optional. Array of objects defining template parameters. Can be omitted if template has no parameters.<\/td><\/tr>
rows<\/td>array of rows<\/td>Return value. Array of rows. Every row itself is an array of key-value pairs (column name => column value). Column name is string. Column value type depends on actual type in the database. Array is empty if no data was found.
Rows table can be enumerated upon, e.g. to display in form of HTML table. See examples for more information.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
Param<\/code> object parameter definition<\/p>\n\n\n\n
Name<\/th>Type<\/th>Description<\/th><\/tr><\/thead>
Name<\/td>string<\/td>Parameter name.<\/td><\/tr>
Value<\/td>object<\/td>Parameter value. Value type depends on defined parameter type.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
NOTE: typically, Param<\/code> objects are created using constructor, which is more convenient. See examples for more information.<\/p>\n\n\n\n
2. Using GetRowsByTemplate method<\/strong><\/p>\n\n\n\n
Example – simple request using template with two parameters:<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
GetRowsByTemplate<\/span>(<\/span>'<\/span>MyTemplate<\/span>'<\/span>,<\/span> <\/span>new<\/span> [] <\/span>{<\/span>new <\/span>Param<\/span>(<\/span>'<\/span>numberParam<\/span>'<\/span>,<\/span> 123<\/span>),<\/span> new <\/span>Param<\/span>(<\/span>'<\/span>textParam<\/span>'<\/span>,<\/span> <\/span>'<\/span>abc<\/span>'<\/span>)}<\/span>)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Returned output is the same as with regular GetRows method. You may enumerate rows, access rows and columns by indexes etc. Please see GetRows documentation<\/a> for more details.<\/p>\n","protected":false},"author":6,"featured_media":0,"parent":3874,"menu_order":214,"template":"","format":"standard","emp-category":[],"class_list":["post-3882","es","type-es","status-publish","format-standard","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3882","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es"}],"about":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/types\/es"}],"author":[{"embeddable":true,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/users\/6"}],"version-history":[{"count":2,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3882\/revisions"}],"predecessor-version":[{"id":8867,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3882\/revisions\/8867"}],"up":[{"embeddable":true,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3874"}],"wp:attachment":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/media?parent=3882"}],"wp:term":[{"taxonomy":"emp-category","embeddable":true,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/emp-category?post=3882"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}