تخطي للذهاب إلى المحتوى
القائمة
لقد تم الإبلاغ عن هذا السؤال
2 الردود
7683 أدوات العرض

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

الصورة الرمزية
إهمال

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

أفضل إجابة

HI, you can follow following tutorial for this:

https://youtu.be/kwkddYoFQCE

Hope it helps,

Thanks

الصورة الرمزية
إهمال
أفضل إجابة

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

الصورة الرمزية
إهمال
المنشورات ذات الصلة الردود أدوات العرض النشاط
1
مايو 19
6087
3
أكتوبر 18
18933
4
ديسمبر 23
13108
1
نوفمبر 18
5964
5
أغسطس 24
45668