|
Re: How to get distinct record values after query in form [message #680252 is a reply to message #680219] |
Thu, 30 April 2020 16:27 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21813 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
After executing query, you could (in POST-QUERY trigger) run GET_BLOCK_PROPERTY with its LAST_QUERY property. It will retrieve the last query executed - the one that fetched result user is looking at. Use it as a subquery for selecting distinct order_number values. Something like
select count(distinct order_number)
from (query returned by GET_BLOCK_PROPERTY)
Then display that value somewhere on the screen.
|
|
|