Home » Developer & Programmer » Forms » How to get the RECORD GROUP query.
How to get the RECORD GROUP query. [message #87403] Wed, 29 December 2004 19:41 Go to next message
sriram
Messages: 58
Registered: September 2000
Member
requirement is
--------------
I want to add a condition to the existing record group query.

approach
--------
for :system.cursor_item get the LOV name. GET_ITEM_PROPERTY(LOV)
for the above LOV get the GROUP_NAME GET_LOV_PROPERTY(GROUP_NAME)

my question.
------------
Is there any function which return me the "SELECT QUERY" attached to the
record group.

if there is a function. Can we add any condition for the existing where clause.

After added the where condition i will populate the data by using
POPULATE_GROUP_WITH_QUERY('GROUP_XYZ',v_query);

Please reply soon
Re: How to get the RECORD GROUP query. [message #87407 is a reply to message #87403] Thu, 30 December 2004 01:04 Go to previous message
niranjan das
Messages: 14
Registered: October 2002
Junior Member
I Think u need to go for

create_group_from_query
(mention every time the fresh query u want for the record group) because u can not append any cond to the existing query or u can not get back the query associated with the record group.
Previous Topic: Why do i need a Execute_trigger
Next Topic: passing parameter
Goto Forum:
  


Current Time: Thu Sep 19 15:10:58 CDT 2024