How to get the RECORD GROUP query. [message #87403] |
Wed, 29 December 2004 19:41 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
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.
|
|
|