'Things Boards Question About Database How to query historical data in Time interval

I new to the things board and i currently helping my company to do the IOT platform project using Things Board. Do somebody has the knowledge to the below question? Hopefully I can get suitable resources that can help me to complete the project given by the company.

The question as followed:

-I only know the RAW data store at table ts_kv, ts_kv_latest, but actually I don't understand how the things board store inside the data if like that any way or link that can see/know the data inserted, do I able to query historical data from Pgadmin

-There has time interval at the dashboard and that can set by the customer, but it not functioning, is that any setting can if I want to change and let the customer query the data?

-Anyway to capture dashboard data or from rule chain and save as historical data in DB ? I saw it have a download option (Json) but not sure how it can save into database instead?

-Beside Things board web site, any recommended learning platform for Things Board ?

The following is the screenshot of the things board pgadmin database with name ts_kv_latest

Database picture- ts_kv_latest



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source