Hi Forum, I wish to add a macro in my sql so that I can do something like this: dc1.DocumentID = {%DocumentID%} Basically meaning, where the DocumentID of dc1 is Equal to the current DocumentID. Any idea how I can achieve this?

Hi Forum, I wish to add a macro in my sql so that I can do something like this: dc1.DocumentID = {%DocumentID%} Basically meaning, where the DocumentID of dc1 is Equal to the current DocumentID. Any idea how I can achieve this?

Okay. I have placed a #WHERE## tag in the SQL section and in the Where text box, I am trying to do this: NodeParentNodeID = {% NodeID %} or NodeAliasPath LIKE ' {% NodeAliasPath + /Featured/%' %} I have the macro symbols jumbled up. How can I syntactically get the above ...

Thank you, got it! Doing some research about the macro for getting custom table data. In v7 there is no method implemented for this - I am sorry for the inconvenience but you will have to create a custom macro. In version 8 is this already ensured. Best regards, Jur...

Hi, Once you will set the new salt, in the UI there is a button "Update macro signatures" - so, this will re-sign all the macros, including existing macros with the new hash signature. Best regards, Juraj Ondrus

If I was to write a custom macro, for which the framework is now in place. From the custom maco how do I gain access to the SQL Data Source on the current page from the code. Still new to Kentico but it gets better every day.

It looks like it's not possible, at the moment the macros are resolved the context shows the page to be portaltemplate.aspx and doesn't contain the datasource control i'm looking for. I still need to access a datasource control from a macro if possible as the users do not h...

I ended up modifying my macro to simply use {% ClassName %} and it worked without an issue. So there must be permission issues with accessing the class name the other way. At any rate, I got it to work.

You can do this with a macro. You might want to check out the developers guide on macros.

Hi, Could you please use the macro debug to see if your macro in the SQL query is resolved correctly? Best regards, Juraj Ondrus