Retool
Table Component Trap 1
Use a query as a table’s data source, and add table’s refresh in the success field of the query, unlimited cycle…
Table Component Trap 2
While setting columns one by one, there is a way to define how the data should be presented, with the label of Mapped value. However, if the selectedRow was used, it would give out the value mapped, not the original value. This can be tricky.
SQL Query Data Caching Problem
After triggering a SQL query to insert or modify a record in the database, even with await, trigger another SQL query to get the new record, it still returns the data before the query takes place. It seems like the key point is the getting Query, it always returns the old data. Still a problem to be solved.
Related Platforms
(Github Issues) / (Notion) / (Blog)
Advertisement
(A website to optimize your resume and to boost your career: Nonpareil.me)
Retool
Table组件小陷阱1
把一个JS Query设置成这个表格的数据源，然后在这个JS Query成功之后的调用里设置这个表格的refresh，结果就会得到……死循环……
Table组件小陷阱2
设置数据源之后，可以设置每一列的显示格式，其中在Mapped value处可以设置显示方式，增加一些函数或者计算功能。但是要注意的是，在使用表格的被选中行时，如果获取这列的值，就是经过计算之后的值，而不是原始值。这个有时很隐蔽。
SQL Query的数据缓存问题
使用SQL Query向数据库中提交数据后，再去立刻查询，得到的数据仍是之前的数据。即使有await修饰这两个Query的调用也不行。不过似乎这个问题在于查询部分，查询之后立刻取它的data总会是之前的值。还在解决中。
相关平台
(Github Issues) / (Notion) / (Blog)