Data from the wrong records being displayed

Wappler General Bugs
#1

I think I’ve come across a rather serious problem. I have a page which filters records with a single search field. If another search is made, one of the columns updates correctly, while another shows data from the previous search.

I could be doing something silly, but I wouldn’t have thought this should happen in any circumstances. I’ve made a demo showing the problem here.

Looking at the MySQL query log, the query which is executed when the search for ‘aaa’ shown in the demo is made is:

image
image.png841×72 3.25 KB

… which is what I would expect and which returns the correct results (but not the results which are displayed).

Data in repeat children reload bug
Problem when Server connection update
Bootstrap 4 table generator with NULL values in result-set
Productivity Tips & Tricks
Null values display previously retrieved values
Dynamic value == null output as 'null' and not *nothing* after form reset
Problem of mixing cell data of different rows after resetting filters
#2

Hello Tom,
Are your dates for the “aaa” records null?

#3

Yes

#4

That’s why you see the “old” values then.
Just add .default('') to your dates table fields values.

1 Like
Sortable table retaining old value where a NULL is being populated
#5

Great - thanks. I’ll do that, or set defaults in the database.

I’ve come across similar issues before with sorting, but didn’t realise it could affect displayed data. It would be a good idea if some warning was displayed or popped up, in query builder perhaps, to warn about this. I think you mentioned it was performance related, but it has rather serious potential consequences.

Sorting with blanks, copies values - bug?
#6

Maybe @patrick can check this and see if it can be somehow improved.

1 Like
#7

Hopefully it won’t affect performance but I think it would be a good idea to do something about. I don’t think I’ll have this problem again now, but inevitably others will.

#8