Single instance in Query result

pixerp · Post by **pixerp** » Wed Jul 25, 2007 2:11 pm

Is there a way to avoid displaying a query result table when there is only one instance (record) ?

See sample Library app, in the left pane you have an HTML to do searches (runQuery.do?...). If I type 'john' in First Name, I'd like John's Member details form to open directly in the main pane instead of the query result table, showing only one record to select !

aware_support · Post by **aware_support** » Wed Jul 25, 2007 11:29 pm

If you use PICK FROM action there is an option to specify NO CONFIRMATION FOR ONE, which is what you want (check Rule Language document)

pixerp · Post by **pixerp** » Thu Jul 26, 2007 7:04 am

I know the PICK FROM action.

But it always starts by displaying a criterion entry form whereas I'd like to use the runQuery.do from a custom HTML pane exactly as in the Library left pane...

Thanks.

pbrad · Post by **pbrad** » Wed Aug 15, 2007 11:44 pm

Hi,

Was there any resolution to this? I need to do exactly the same thing.

Thanks,
Pete

aware_support · Post by **aware_support** » Fri Aug 17, 2007 5:13 am

If you are using hypelinks you can try specifying noConfirmationForOne=true parameter:

runQuery.do?actionMethod=displayForm...&noConfirmationForOne=true

pbrad · Post by **pbrad** » Fri Aug 17, 2007 11:53 am

Hi,

Sorry to report back that it didn't work using the following code:

<form class=search_form method="POST" target="main"
action="../runQuery.do?actionMethod=displayForm&paramsInRequest=true&name=Client&nameMeaning=0&noConfirmationForOne=true
">

Cheers,
Pete

aware_support · Post by **aware_support** » Mon Aug 20, 2007 11:45 pm

Could you please try noConfirmationForOne=on instead?

Sorry, this is just a suggestion - we haven't tested it ourselves yet. It may or may not work.

pbrad · Post by **pbrad** » Wed Aug 22, 2007 12:05 pm

Hi,

No luck on that one either I am afraid. This is not a critical issue, just a 'nice to have'.

cheers,
Pete