Filter table with a SQL query

[Jean203]

Hello everyone,

I was wondering : I was currently creating an objects menu, with different categories : weapons, potions, etc. So I have one database with all my objects, and different tables with SQL filters to filter by category.

But often, the table items doesn’t show up : there is only the background, but not the item :

Why ? Is adding a SQL query to a table makes it unstable ? Is that a bug ?
Here is the query associated to one of my tables :

SELECT * FROM data WHERE “Type”=“Consommables” LIMIT 0, -1

Should I do a “temporary” query with the actions rather than a “permanent” query in the database menu of the inspector ?

Thanks by advance

[Vladimir_PV]

Пустые поля в БД ?
Empty fields in the database?

[Jean203]

Yes, some fields were empty ! I tried, sometimes items still disappear but when i leave and come back, they reappear ! Thanks again Vladimir, you’re awesome !