Home » Developer & Programmer » Forms » How to get distinct record values after query in form
icon1.gif  How to get distinct record values after query in form [message #680219] Wed, 29 April 2020 02:07 Go to next message
GHDSSS
Messages: 12
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
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
Littlefoot
Messages: 21592
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.
Previous Topic: Unable to resolve reference - checkbox issue
Next Topic: Radio Buttons
Goto Forum:
  


Current Time: Tue Sep 22 03:06:18 CDT 2020