Queries with User Input.

Angarato · Post by **Angarato** » Sun Mar 04, 2007 9:50 pm

Hello Everybody!

Just a quick question. What if I have a standard query which requires
user criteria to be defined at the run time and don't want query to run
and return all records in case user doesn't provide any input value(s)
or parameter(s)? Is it possible to configure the query parameter input
form the way it wouldn't allow user to leave the input field(s) blank or
if user leaves input fields blank then not to return any records instead of
returning the whole list of corresponding BOs?

Thank you!
Angarato.

aware_support · Post by **aware_support** » Mon Mar 05, 2007 10:05 am

No, currently it will always return all records (rather, the first 20 or however many the query is configured to return)

greg · Post by **greg** » Thu Mar 08, 2007 6:46 am

I think you can do it but not in a simple query form. You need to create a non persistent BO, then set up a process with the first rule to ENTER NEW ThatBO and after that put a rule If BO.Attribute1 AND all the others UNDEFINED Then REPORT ERROR '...' or DISPLAY MESSAGE '...' Else proceed to your re-written query.