Skip to Content
0
Former Member
Mar 28, 2010 at 09:43 AM

column/condition selection in "where" clause using prompt

26 Views

Hello everyone,

I want to write a query like

select name from LibraryBookLIst

where slno > 5

is it possible to use prompt function instead of using ">". I need a way to use the prompt in universe level. So that user can select any operands without modifying the report.

I also need to allow user to select column like slno, bookno etc....

Right now i am using BOXI3.1

Thanks in advance.