message template issue...!

[vidhya]

Hi,
Is it not possible to pass fields which are on rows in mdx query to message template of action sequence..?

But,If its a sql query, am able to pass all fields in that query to message template...

Someone pls help....

thanks....

[malyvelky]

I don't really know, maybe there is some difference between the result sets produced by those 2 queries, maybe it's another issues. Perhaps you could try to put in between those 2 components a javascript rule and transform it into a form that the message template can consume or at least dump it into log for debugging.

[vidhya]

Hi,

I tried to insert javascript in between and do some manipulations...I need to know the current looping index..Which function of javascript can be used to get the current looping index?
Or do you suggest some other method to make it into an acceptable form in message template through javascript..?

thanks in advance...