{"id":3876,"date":"2023-09-21T13:08:25","date_gmt":"2023-09-21T12:08:25","guid":{"rendered":"https:\/\/help.expertsender.com\/?post_type=es&p=3876"},"modified":"2025-07-09T16:55:53","modified_gmt":"2025-07-09T15:55:53","slug":"deleterow","status":"publish","type":"es","link":"https:\/\/help.expertsender.com\/pl\/emp\/dynamic-content\/data-tables\/deleterow\/","title":{"rendered":"DeleteRow"},"content":{"rendered":"\n

DeleteRow<\/code> method can be used to delete a single row from custom data table. This is an equivalent of SQL DELETE<\/code> query.<\/p>\n\n\n\n

It is best to be very careful with this method to avoid losing your data by accident. Deleting multiple rows is disabled, to avoid deleting whole tables by mistake.<\/p>\n\n\n\n

This method can be useful if it is necessary to delete records from your custom data when an email is sent. E.g. this may be a list of customers who did not received any offer or a list of unique offers that cannot be sent twice, etc.<\/p>\n\n\n\n

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

<\/path><\/path><\/svg><\/span>
DeleteRow<\/span>(table<\/span>,<\/span> filters<\/span>,<\/span> filterOperator)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Parameter definition:<\/p>\n\n\n\n
Name<\/th>Type<\/th>Description<\/th><\/tr><\/thead>
Table<\/td>string<\/td>Required. Table name.<\/td><\/tr>
Filters<\/td>array of Filter objects<\/td>Optional. Array of objects defining elements of WHERE<\/code> phrase of DELETE<\/code> query. Use this parameter, to restrict deleting row only if it matches your criteria. If null, no criteria will be applied. If several filters are defined, by default, deleted row will match all of them (equivalent to logical AND<\/code>).  
Default behavior can be overridden using filterOperator<\/code> parameter.<\/td><\/tr>
filterOperator<\/td>enumeration<\/td>Optional. Logical operator used for filters. Can be one of the following:AND (filter1 AND filter2 AND filter3…) – this is the default valueOR (filter1 OR filter2 OR filter3…)ANDNOT (NOT filter1 AND NOT filter2 AND NOT filter3…)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
Filter<\/code> object parameter definition:<\/p>\n\n\n\n
Name<\/th>Type<\/th>Description<\/th><\/tr><\/thead>
Name<\/td>string<\/td>Column name<\/td><\/tr>
Modifier<\/td>enumeration<\/td>Operation modifier. Can be one of the following:
EQ (equals, “=”)GT (greater than, “>”)LT (lower than, “<“)LIKE (SQL LIKE<\/code> operator)<\/td><\/tr>
Value<\/td>object<\/td>Column value. Value type depends on column type, e.g. when filtering by number column, integer value should be supplied, string for text columns etc. Simple type conversion is also supported, e.g. string “123” representing correct integer value 123 will be accepted. This also works for dates, floating point numbers etc.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
Note: Filters work the same way as in GetRows<\/code> method. See GetRows documentation<\/a> for more details and examples.<\/p>\n\n\n\n
2. Usage and examples<\/strong><\/p>\n\n\n\n
You can call DeleteRow<\/code> method using curly braces syntax. You may put in anywhere in the email template code since its output is empty string.<\/p>\n\n\n\n
Example 1 – the most simple call<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
$<\/span>{<\/span>DeleteRow<\/span>(<\/span>'<\/span>MyTable<\/span>'<\/span>)<\/span>}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Equivalent SQL query:<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
DELETE <\/span>TOP<\/span>(<\/span>1<\/span>) FROM MyTable<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
This however has limited use, since in most cases, you will want to delete a specific row (and not first found). Following examples show how to use filters to achieve this.<\/p>\n\n\n\n
Example 2 – deleting a row matching specified criteria<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
$<\/span>{<\/span>DeleteRow<\/span>(<\/span>'<\/span>MyTable<\/span>'<\/span>,<\/span> <\/span>new<\/span> [] <\/span>{<\/span>new Filter<\/span>(<\/span>'<\/span>CustomerId<\/span>'<\/span>,<\/span> <\/span>EQ<\/span>,<\/span> 123<\/span>)}<\/span>)<\/span>}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Equivalent SQL query:<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
DELETE <\/span>TOP<\/span>(<\/span>1<\/span>) FROM MyTable WHERE CustomerId <\/span>=<\/span> <\/span>123<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
Example 3 – using multiple filters<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
$<\/span>{<\/span>DeleteRow<\/span>(<\/span>'<\/span>MyTable<\/span>'<\/span>,<\/span> <\/span>new<\/span> [] <\/span>{<\/span>new Filter<\/span>(<\/span>'<\/span>CustomerId<\/span>'<\/span>,<\/span> <\/span>EQ<\/span>,<\/span> 123<\/span>),<\/span> new Filter<\/span>(<\/span>'<\/span>MyColumn<\/span>'<\/span>,<\/span> <\/span>EQ<\/span>,<\/span> 456<\/span>)}<\/span>)<\/span>}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Equivalent SQL query:<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
DELETE <\/span>TOP<\/span>(<\/span>1<\/span>) FROM MyTable WHERE CustomerId <\/span>=<\/span> <\/span>123<\/span> AND MyColumn <\/span>=<\/span> <\/span>456<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
It is also possible (and in most cases necessary) to match deleted rows with subscriber properties, email etc.<\/p>\n\n\n\n
See GetRows method examples<\/a> for more information.<\/p>\n\n\n\n
<\/p>\n\n\n\n
Example 4 – real-life scenario, sending emails with single-use coupons<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
<!--<\/span> get coupon for customer and store <\/span>in<\/span> a variable <\/span>--><\/span><\/span>\n<<\/span>var<\/span> <\/span>rows<\/span>=<\/span>"<\/span>GetRows('Coupons', 1, null, new [] {new Filter('CustomerId', EQ, SubscriberProperty('customer_id'))})<\/span>"<\/span>\/><\/span><\/span>\n<!--<\/span> display coupon code <\/span>in<\/span> email <\/span>--><\/span><\/span>\n<<\/span>p<\/span>><\/span>Hello! Here's your coupon: $<\/span>{<\/span>rows[<\/span>0<\/span>][<\/span>'<\/span>CouponCode<\/span>'<\/span>]<\/span>}<\/<\/span>p<\/span>><\/span><\/span>\n<!--<\/span> <\/span>delete<\/span> the coupon so it cannot be used again <\/span>--><\/span><\/span>\n$<\/span>{<\/span>DeleteRow<\/span>(<\/span>'<\/span>Coupons<\/span>'<\/span>,<\/span> <\/span>new<\/span> [] <\/span>{<\/span>new Filter<\/span>(<\/span>'<\/span>CouponId<\/span>'<\/span>,<\/span> <\/span>EQ<\/span>,<\/span> <\/span>rows<\/span>[<\/span>0<\/span>][<\/span>'<\/span>CouponId<\/span>'<\/span>])}<\/span>)<\/span>}<\/span><\/span><\/code><\/pre><\/div>\n","protected":false},"author":6,"featured_media":0,"parent":3874,"menu_order":211,"template":"","format":"standard","emp-category":[],"class_list":["post-3876","es","type-es","status-publish","format-standard","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3876","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":3,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3876\/revisions"}],"predecessor-version":[{"id":14978,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3876\/revisions\/14978"}],"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=3876"}],"wp:term":[{"taxonomy":"emp-category","embeddable":true,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/emp-category?post=3876"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}