Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
2 Trả lời
8111 Lượt xem

I am creating a table in the database using the below query:

CREATE TABLE location (
  data jsonb
);


Now I don't want to create a model. but want to make a view which shows the record from the location table.

The records in the table are like:
data

{"angle": -84.34, "speed": 93.2, "status": "intransit", "trip_id": 80, "latitude": -1.236294, "longitude": 36.748787, "location_stamp": "2019-07-04  07:43:10"}
{"angle": -84.34, "speed": 93.2, "status": "intransit", "trip_id": 80, "latitude": -1.236294, "longitude": 36.748787, "location_stamp": "2019-07-04  07:43:10"}

How can I do this? Please suggest me any way to do this.
Thank you

Ảnh đại diện
Huỷ bỏ

Hello,You can do it in two way:Creating a model like sale.report to just view without saving. Or you can extend interface

Câu trả lời hay nhất

HI, you can follow following tutorial for this:

https://youtu.be/kwkddYoFQCE

Hope it helps,

Thanks

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

Hello Rohit,

Try if following way if it's work for you.

There is method called default_get(), this method call when any record open in form view or created. So what you have to do is you have to do all coding in default_get and fill form values from database table's dictionary values.

Hope it will helpful for you.

Thanks and regards

Haresh Kansara

Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
1
thg 5 19
6393
3
thg 10 18
19561
4
thg 12 23
13434
1
thg 11 18
6504
5
thg 8 24
46762