Data block query [message #614250] |
Mon, 19 May 2014 23:02 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/19734cb67f27f646b870e14acd1791f9?s=64&d=mm&r=g) |
nilanjanpal
Messages: 8 Registered: May 2014 Location: Kolkata
|
Junior Member |
|
|
I have a data block and I have checked in the properties page of the data block, the query source name is a view. So by that I am able to determine that it is querying a view but in the where clause there is nothing mentioned.
I also checked in the forms, if the where clause in the forms is being set dynamically using set_block_property, that also is not happening. Is there any other way by which the where clause can be built or any other place where it can be mentioned.
Also I would like to mention that there are database items under that block, so if there are no where clause will it automatically filter the data after querying the view based on the value available in the database items under the block.
Thanks for your help in advance.
|
|
|
Re: Data block query [message #614252 is a reply to message #614250] |
Tue, 20 May 2014 00:08 ![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: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
As far as I can tell:
Quote:
Is there any other way by which the where clause can be built or any other place where it can be mentioned
Not exactly the WHERE clause, but close enough: PRE-QUERY trigger could contain something likeThis trigger fires before querying data, sets block's DEPTNO item to 10, and returns only those employees that work in department number 10. It works as if you entered query mode, manually put 10 into the DEPTNO item, executed query.
The answer to your second question would be "Yes" (keep in mind PRE-QUERY trigger I mentioned above).
|
|
|