Hi, could you please try to use following macro definition: switch (expression.ToLower()) { case "cmacro": match = true; result = "\'%teststring%\'"; break; } Macro returns '%teststring%' a...

Thanks for posting this gatsby. As you have realized, my solution using replace in the macro was wrong.... it appears that the Macro framework will always replace ' with ''.... in the course of sql injection removal. I'm just posting this so that anyone who sees my comment do...

Thank you Ondrej for your help with our problem. We had to abandon the custom macro approach for the web part's property due to our project time line. We opted for using a custom function within the transformation. It was not our preferred solution but we simply were unable to...

Hi, That article is pretty old :-) In newer version it is much easier to achieve your need. Just by using macro expressions. In the field's default value setting you will use macro like this: {%cmscontext.currentpageinfo.documentpagetitle|(user)michalv|(hash)46ff0f6...

Hello, you don't have to feel silly at all, because it's actually quite common question and such functionality would be definitely useful, regrettably the context macros don't support the OR and AND conjunctions. You would need to create a custom macro for this purpose whic...

I have the following in the Where Condition for a repeater webpart Year(ReleaseDate) >= {?year|(default)1900?} and Year(ReleaseDate) <= {?year|(default)2500?} The query string macro is not resolved, and so the repeater gives me an error. What's wrong with this? Accordi...

Hi, Thank you for the explanation. In this case, you can use e.g. a static text web part with custom macro and in the code of the macro yu will read the query string parameter and get the title of the document you want. Best regards, Juraj Ondrus

Ok, you completely mis-understand what I am trying to do. Year(ReleaseDate) is valid. Year() is a SQL function. So, it is grabbing the year part of the field ReleaseDate. The problem is that the query macro fails. I was able to work around this by cloning the webpart and ...

Hello, Yes, they can. However, in your case, it's about creating a custom macro to retrive a current date in code (as far as I'm aware there is no native context macro available for this). Please see more info here: Appendix A - Macros. Best regards Ondrej Vasil

Hi, you could create a custom macro for this with the following code inside. UserInfo ui = UserInfoProvider.GetUserInfo(CMSContext.CurrentUser.UserID); DataTable dt =CMS.SiteProvider.UserInfoProvider.GetUserRoles(ui); This way you are able to select roles in which th...