Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SetCurrentRowWithKey breaks table sort order

Robert ŠajinaJun 27 2018 — edited Jun 27 2018

The problem occurs when a new task flow is opened and default activity is SetCurrentRowWithKeyValue. If the row is found within the N first rows (where N is range size of iterator) and the table is working with pagination then it works okay. But if the row is not found within the first N rows, then the row can be found on the second page (i.e. at N+1 position) and has been moved from its position after default sorting. The thing is that the record will always be placed in the N+1 position but never in its sorting position.

For instance if we show the table with two rows and if the key to search is "2", the row order would be alright: (note : underscore means next page)

Id   |    Name

______________

1    |    name_1

2    |    name_2

______________

3    |    name_3

4    |    name_4

______________

5    |    name_5

6    |    name_6

But if search for the key "5" then the table would look like this:

Id   |    Name

______________

1    |    name_1

2    |    name_2

______________

5    |    name_5

3    |    name_3

______________

4    |    name_4

6    |    name_6

it looks like the "problem" occurs when ADF is fetching data and appends the searched row after the initially fetch ones. This means (and we tested it) that if range size of iterator is set to -1, then all rows would be fetched and the searched row would be found in fetched rows not losing its position in the sorting order.

Our question is how to accomplish behavior like when the range size of iterator is set to -1 (i.e. setting current row without breaking sort order) but with normal value for range size (i.e. 10)

JDev 12.2.1.2.0

Thank you

Comments

Christian Pitet

What means BIP ?

User_TYVZT

Hi Christian Pitet

Oracle Business Intelligence Publisher (BI Publisher) (BIP)

Christian Pitet

I guess you are using an Interactive report. Do you have a Submit page process on that page ?

InoL

While generating report in BIP, that data is saved as sample data.
What do you mean by that? Generating a report via BI Publisher and saving sample data? I don't see the connection.
How are you using BIP? As the print server for Intercative Reports? Or a custom report template?

User_TYVZT

Hi InoL
So for creating report, I have xdm(data model) and xdo. In xdm, after providing the sql query, I can see the data when I click view data. There I can do "save as sample data". Then after link my data model with xdo which has template in it, I can view my report in various formats. There even though there is data I'm not able to see the data in xls and pdf format. Only CSV format report shows data.

InoL

I have xdm(data model) and xdo
I have no idea what that is, not APEX anyway. Is this something from BI Publisher? Maybe you can ask this in that forum then.

User_TYVZT

Hi InoL
Yes it is from BI Publisher(BIP). Could you share forum link?

Christian Pitet

Here is a forum link :
bi publisher (0 Bytes)Regards.

1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 25 2018
Added on Jun 27 2018
0 comments
213 views