search

AtomGraph / LinkedDataHub

The low-code Knowledge Graph application platform. Apache license.
https://atomgraph.github.io/LinkedDataHub/
Apache License 2.0
485 stars 122 forks source link

b.getTimezoneOffset is not a function #139

Closed FNakano closed 1 year ago

FNakano commented 1 year ago

I believe you can help me with this... It is more of a Date/Time encoding issue - not a LinkedDataHub issue.

http://50.62.81.50:8890/sparql is a SPARQL endpoint. The database has some data in it.

In LinkedDataHub I created a service, to access it and run the query: 

prefix sosa: <http://www.w3.org/ns/sosa/>

select * where {
  ?s ?p sosa:Observation .
  ?s sosa:hasSimpleResult ?o1 .
  ?s sosa:resultTime ?o2 .
} LIMIT 100

... got a b.getTimezoneOffset is not a function error message:

Captura de tela de 2022-10-29 15-37-48

Directly querying it results in rows contanining data like:

s p o1 o2
http://each.usp.br/Observation/1639690208#press http://www.w3.org/1999/02/22-rdf-syntax-ns#type "92683.500000 hPa"^^http://w3id.org/lindt/custom_datatypes#pressure 2021-12-16T21:30:08.077998Z

Is the DateTime format in the data source, wrong?

Thanks in advance.

namedgraph commented 1 year ago

Hi again. No the data looks correct. I think the problem is that the conversion from the SPARQL results JSON to DataTable treats date(time)s as string.

namedgraph commented 1 year ago

@FNakano it's now fixed in f83fd5c560b1be72b7b321dd936a2932e358fadc. Merged to develop.

FNakano commented 1 year ago

@namedgraph, thank you!

FNakano commented 1 year ago

... just to show a working result...

Captura de tela de 2022-11-02 17-03-14

namedgraph commented 1 year ago

Beautiful :) Glad it helped.

namedgraph commented 1 year ago

@FNakano what features are you using mostly?

FNakano commented 1 year ago

@namedgraph , I intend to use LinkedDataHub to design/deploy sensor data analysis and decision-making based on (web) semantics.

namedgraph commented 1 year ago

Thanks :) What I meant is what features in LDH are you using/planning to use: storing queries, creating/editing documents, creating structured content etc. That would be helpful to know.

FNakano commented 1 year ago

Oh! I missed the abstraction level... sorry...