Hi All,
I have an issue with execute_query for a data block. It states Query caused no records to be retrieved.
Steps made for checking.
1. execute get_block_property('bk_repdata',last_query) after the execute_query procedure.
it shows the last query fired by the form. when i manually try to execute the query in sql developer it returns 21k records.
2. Check default where clause - No where clause where setup.
3. Initialized default where clause to ''/Null. Still no values where returned.
4. Tried to use the query source database name of the block to a different block. it works perfectly fine and return the expected values.
5. Compared the 2 datablocks used in step 4 both are the same and different only in names and default canvas for the items in the blocks.
6
Thank you in advance.