Hi all
This is my 1st attempt at a macro in FM - I'm trying to create a prompt with a default value. I want the default value to be filtered by a session parameter.
I have tried a number of things that all lead to 1 error or another. This is what I currently have, which seems to make sense in the macro editor, but errors when testing. Any help is appreciated.
#prompt( 'pBldg ', 'integer' , ' where LOGIN_ID = ' + sq($account.personalInfo.userName) )#
PS - this reades the UserName parameter correct, but throws a syntax error when testing