CODEWITHSUNDEEP
databus
user2521952
user2521952

Reputation: 13

Unable to view uploaded timeseries data in UI chart

Running the Databus server from the command line I have successfully uploaded timeseries data via curl, and am able to query the same data with the api. I'm unable to view any of the data in the table in the UI. After selecting "My Databus" -> Tables is says "You do not belong to any groups that have tables yet. Add some groups, then tables!!!". Navigating to the Database and selecting the table -> chart no data comes back there either.

I have noticed that the query it issues is from a recent time range, while the data I loaded is for an earlier time period. Is there a default way to show the most recent data available in a table?

Upvotes: 1

Views: 77

Answers (1)

Dean Hiller
Dean Hiller

Reputation: 20200

Is your table type relational or stream? If relational, what is the primary key?

If time series, this url will give you the last 10 values because of the parameter 10 and reverse=true.

http://[yourhost]/api/firstvaluesV1/10/rawdataV1/[yourtablename]?reverse=true

If relational table, you can retreive all values like so

http://[yourhost]/api/getdataV1/select+c+from+[yourtablename]+as+c

replace either urls [yourhost] and [yourtablename] values.

We do not use the tables page much. It is better to click in the specific database as in My Databus -> Databases and then click on the database that has your table. We are about to add a view data link in there showing most recent 1000 values or something like that. There is already a view chart which shows most recent 2 hours(again, we want to change that to most recent 1000 data points instead as well).

Upvotes: 0

Related Questions