Dear all, I'm trying to figure out how to use the Where macro method (or alternatively the Filter macro method) in the context of the Orders macro object and I haven't had any luck. Any sample code to look at? I have had a lot of trouble finding anything on this. Thanks, Da...

I've created a widget based off the static text web part. It has 3 properties: Text, Month, and Year. In the Text property I have set the default Value to "This item appeared in the " %insert macro expression to get the value of the month property% of %insert macro expression ...

Hi, I have an email template using some macros. The email macro is in the code in the ObjectrEvents.cs using Tuple.Create. The html text uses string.format and I have to format it into html talbes, with tags. The problem is, when I add this macro like this to the email te...

I have an email template with macro. I need to display *DataTable*. Inside macro I have loop and only *print* methods inside loop. I'm pretty sure that that table contains correct data. But as a result, sometimes I receive correct email message and sometimes not. If it is inco...

Hello Kentico Team, Recently we are trying to upgrade our multi site Kentico application and database from version 9 to version 12. Within the process of upgrade we are experiencing some issues Before start with issues required information about the project:- 1. Current Ken...

How can I execute some of the predefined queries in the Custom table within a macro expression? Example: CMSContext.Current.Queries.FieldsAsObjects.ClassID["customtable.IncomeTreats"].Queries.Select_response_JSON Which is basically this in SQL: SELECT V.UserName, V.UserEmail...

Hi, We will try to improve the documentation related to this in the next version. But the usage is simple, you need to return the value which is awaited for the field directly from the macro. In this case you need to use macro which is returning true or false, for example {...

Hi, This will work in version 6.0, where macros will be slightly modified again. In current version, you can use nested macro to compare it with the result - the macro resolver is called again to resolve the macros in result. In the above example you are comparing th...

Hi, Order payment result is stored in database in table COM_Order in column OrderPaymentResult. You can use custom macro for this purpose in your e-mail template: http://devnet.kentico.com/docs/devguide/appendix_a___macro_expressions.htm In code of your custom macr...

Hi, Thank you for your message. For this you will need to create a Custom macro method. You can call this macro with giving it a parameter (some ID in your case) and in the code behind you will get the data out of your custom table and return the desired output. For ...