Table row Count (footer) correct, but table not displaying all rows..

DaveDave ๐Ÿ’Ž
edited June 25, 2020 in Questions
HI,

First time encountering this weird issue

Using a PostgreSQL Data Source, i have this table that for some reason shows the correct Table row Count (footer) , but table not displaying all rows..

See Screenshot below. Says there's 165 records but only 5 displaying on table. Table has a setting to show all rows

If I try to search a row in the table's search box info from a row that is not displaying, it works and the funny thing once I clear out the search box all rows appear... but if I refresh the page, again only the same 5 records appear

Any ideas?


Thx
image


Comments

  • Rob HatchRob Hatch ๐Ÿ› ๏ธ ๏ปฟ
    edited June 3, 2020
    By chance do you have the Unique ID field for the table included in your model?ย  ย I think skuid is getting confused and thinking you have a massive set of duplicate rows.ย  ย Once you get the Unique ID into the model - I think you'll see better.ย 
  • DaveDave ๐Ÿ’Ž
    edited June 25, 2020
    Hey I do already have Unique ID Field on model.ย 

    Here's fieldย 


  • Pat VachonPat Vachon ๐Ÿ’Ž๐Ÿ’Ž๐Ÿ’Ž
    edited June 3, 2020
    Does the table have context or an XML only condition?
  • DaveDave ๐Ÿ’Ž
    edited June 3, 2020
    The table itself has no context condition or any display logic or any xml condition
  • Pat VachonPat Vachon ๐Ÿ’Ž๐Ÿ’Ž๐Ÿ’Ž
    edited June 3, 2020
    Can you record a video of it? Poke around the data in the console and such. Show us the page model, component setup, etc.
  • DaveDave ๐Ÿ’Ž
    edited June 3, 2020
    I'll try, i just cloned my page and left only that model and related table so hopefully simpler to isolate the issue

    But not an expert on console, anything specific i should include? or query on console?

    Or we can do q quick screen share if you think it helps

    Thank you!

  • Rob HatchRob Hatch ๐Ÿ› ๏ธ ๏ปฟ
    edited June 3, 2020
    Dave - I'm gonna reach out by email.ย  ย Is the email in your community profile still right?ย 
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!