OraFAQ Forum: Forms » How to get distinct record values after query in form

Home » Developer & Programmer » Forms » How to get distinct record values after query in form

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to get distinct record values after query in form [message #680219]

Wed, 29 April 2020 02:07

GHDSSS
Messages: 13
Registered: April 2020

Junior Member

Hello All
I have three Data block for passing Parameters, the result of the query Block, bottom to show some information about records that displayed in result block, now my client is asking for the distinct value of Order_number, based on the result after hitting query in form, please can anyone help on this

Report message to a moderator

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

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	Unable to resolve reference - checkbox issue
Next Topic:	Radio Buttons

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 00:36:55 CST 2025