View original (French)

Business Object: limit of 5,000 rows

Solved
M -  
 M -
Hello,

I am currently creating tables on Business Object and I have a problem.

In my Oracle database I have 6000 rows.

I made my join and when I ask BO to count my rows (count([id_fait])) it counts 5000.

However, BO clearly understands that I have 6000 rows since if I apply a filter in my query (only id_fait < 5000) it returns 4999 rows and if I ask for id_fait > 5000, it returns 999, so it knows all my rows but does not want to count/show more than 5000.

Does anyone have an idea?
Thank you in advance

Configuration: Android / SamsungBrowser 10.2

1 answer

  1.
    jordane45 Posted messages 30427 Registration date   Status Moderator Last intervention   4 832
     
    Hello,

    If by testing your query DIRECTLY in your DB you indeed get your 6000 rows, you need to check if there isn’t a setting in your BO:
    Do you have, in the parameters of your query or in the configuration of your BO, a max row query limit?

    --
    Best regards,
    Jordane
    0
    1. M
       
      Hello,

      Thank you for your reply, the problem wasn't with BO but with my universe creation where the software was checking the limitation for me.

      Have a great day :)
      0