How to pass user-entered (Parameter) values in to JReview ImportSQL?

‘&prompt’ with quotes would return error if you have a succeeding and-clause

How to pass user-enterd (Parameter) values in to JReview ImportSQL?

1) Add &PromptText (for number) or ‘&PromptText’  (for Char and Date)

 Select Study, Site, Patient, SubjInit, Sex, Race from DM  Where Sex = ‘&EnterSex’

Bug:  You cannot add succeeding “another Where clause” or “space” or “Enter key” after the ‘&prompt’.

Where sex = ‘&EnterSex’ and Age > 18

But it would work for Numerical Prompt. Where age > &EnterMinAge and Sex = ‘M’

2) Add <prompt=>

Instead of using &prompt, you can use <prompt=>.