Missing records on a list

[jo-ka]

Hello.

I have a list with 1917 records, which was working till some days ago.

Today I've tried to add 2 more records. I've added it, they are stored on the database, but their not displayed on the list, it looks like it's missing something.

What can be happening here?

 

[cheesegrits]

Got any kind of filtering on the list?

Did you add the records through a Fabrik form? If not, do you have caching enabled on the list?

-- hugh

 

[jo-ka]

Got any kind of filtering on the list?

Do you mean prefilters or element filter. I have element filters, yes.

About the cache I don't know. How can I check?

 

[jo-ka]

OK, found and disbled cache.

But the results are the same... I Can't understand this...

 

[troester]

Did you order by id?
Do you have a creation date you can look at and order by?
Did you try to add &clearfilters=1 to your URL?
Do you have a list or menu prefilter?
"...I have a list with 1917 records..." obviously Fabrik sees only 1806

 

[jo-ka]

Yes troester, the list is ordered by id and all the filters are cleared

This is very strange...

I've tried to create a new record, and it worked...



But still there's those 2 records that aren't displayed...



I really can't understand.
I'll delete this records manually and try to recreate them...

 

[jo-ka]

OK, I found it...

For some reason the list is not displaying all those records where this value is set to 8.



I have no filters, but I have a joined list where this record comes from.

It's probably something related with this.

 

[jo-ka]

OK, that was the problem. I have an INNER JOIN on this list with another table, and the id number 8 was missing on that table.

So, case solved. Thanks guys.

 

[cheesegrits]

Yup, be careful with inner joins. As you discovered, the "inner" bit means only records which exist on both sides of the join will show up.

I've never actually found a use for the inner join option in Fabrik. So unless you have a very specific reason for needing it, don't use it.

-- hugh