Can I have the top row in query selected if only 1 match?

BLOMASKY

I have a query with filters. I would like, if the customers filters only found 1 match to have the row selected. But if more than one match, to NOT have it selected. Is this possible. (The reason why, is that this is on a VP with a few other related queries and it takes about 2 seconds for all of them to be populated. I do not want to have the original query delayed by the 2 seconds.

Bruce

johntalbott

Try this ...

Query Render Script

widget.bind("dataBound", function(e) {
    if (widget.items().length === 1) {
         widget.select("tr:eq(0)");
     })
}

BLOMASKY

The good news, it DOES select it (after I add a ")" to the end that was missing.

The bad news is that Aware doesn't know it so it does NOT trigger the default event when clicking on the row.

Bruce

PointsWell

The clunky way to do it is to have two different but almost identical queries and call them from a process.

If the find count is =1 then show the query that has the first row select, if the count>1 then show the query that does not have any rows selected.

Downside is that there are redundant queries that require additional maintenance.

johntalbott

Are you saying that even when you physically click the row it doesn't work?

johntalbott

This should do the trick ...

Query Render Script

widget.bind("dataBound", function (e) {
	if (widget.items().length === 1) {
		widget.select("tr:eq(0)")
		parser.onTableClick("tr:eq(0)", widget)
	}
})

With this approach, you might not need this line:

widget.select("tr:eq(0)")

BLOMASKY

This works just fine.

Thanks
Bruce