jrCore_list random order values

blindmime
@blindmime
7 years ago
772 posts
Does a random list have a limit to how many values in the data it can be possible? I have a list with a limit of 1 (I'm displaying a random quote), but it doesn't seem to ever display values past a certain spot in the database.
updated by @blindmime: 01/17/18 11:15:05PM
michael
@michael
7 years ago
7,715 posts
It will have a default limit of 10 or 12 if no limit is set. If you set a limit it will limit to what you set.
paul
@paul
7 years ago
4,326 posts
Can you paste the code that you are using?
What is the point that it doesn't appear to return a value after? Is it a point in time or something else?
Are you sure that the data past that point is valid? For instance, maybe all the owner profiles of the items past that point are private or in the wrong quota.


--
Paul Asher - JR Developer and System Import Specialist

updated by @paul: 10/18/17 02:54:06AM
blindmime
@blindmime
7 years ago
772 posts
I'm not exactly sure where it's cutting off. I currently have 79 quotes and I'm guess it's displaying only the first couple dozen of that total, perhaps. I haven't yet logged that. I'm just noticing that the more recent entries aren't appearing. I have the code in 4 places on my home page. The site is only a couple weeks old and it's a blog so there are no other users.

The jrCore_list:
{jrCore_list module="bbQuotes" order_by="_item_id random" quota_id=1 limit="1" template="index_list_quotes.tpl"}

The bbQuotes module is a very basic Aparna-generated module. Nothing custom in the module itself. I've added one field via the form designer.

index_list_quotes.tpl:
{if isset($_items)}
  {foreach from=$_items item="row"}
<h2 class="italic" style="color:#4b95e0;">{$row.quotes_quote} </h2>--<h3>{$row.quotes_title}</h3>
 {/foreach}
{/if}

I've tried other order_by parameters like _created but the results don't seem to change. I've done full integrity checks and cache resets. I've also re-indexed search FWIW.
blindmime
@blindmime
7 years ago
772 posts
If I take the limit out, it displays 10 random values (as Michael noted), but that's not the point. Just to be clear, I would expect to see all values appearing at some point if I keep refreshing, but I only seem to be seeing a smaller subset of values up to some _item_id which I think is around 23.

But this only happens when the jrCore_list limit is "1". If it's some other number I do seem to be seeing all possible values.
updated by @blindmime: 10/18/17 04:59:35AM
paul
@paul
7 years ago
4,326 posts
Can you point me to where this is happening?


--
Paul Asher - JR Developer and System Import Specialist

Tags