콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다
2 답글
7692 화면

Im trying some website-programmings and want to display a specific page name on the frontend. Therefore I have the following code:

class wsga(http.Controller):
    @http.route('/hello/', auth="public", type='http', website=True)
    def hello(self, **kw):
        imd = request.registry['ir.model.data']
        iuv = request.registry['ir.ui.view']
        
        cr = request.cr

        view_id = imd.get_object_reference(request.cr, request.uid, 'wsga', 'wsga_test')
        view = iuv.browse(request.cr, request.uid, [('id', '=', view_id), ], context=None)
        
        view_result = []
        for v in view:
            view_result.append({
                'name': v.name,
            })

        return view_result

But the problem is, that this ends up in an SQL-Error in the for-loop. Problem is this query:

SELECT ir_ui_view."create_uid",ir_ui_view."create_date",ir_ui_view."name",ir_ui_view."inherit_id",ir_ui_view."arch",ir_ui_view."write_uid",ir_ui_view."priority",ir_ui_view."application",ir_ui_view."website_meta_description",ir_ui_view."website_meta_title",ir_ui_view."mode",ir_ui_view."write_date",ir_ui_view."id",ir_ui_view."website_meta_keywords",ir_ui_view."model",ir_ui_view."model_data_id",ir_ui_view."type",ir_ui_view."page",ir_ui_view."field_parent" FROM "ir_ui_view"
                        WHERE ir_ui_view.id IN (('id', '=', ('ir.ui.view', 704))) AND (TRUE)
                        ORDER BY priority,name

Problem ist the (('id', '=', ('ir.ui.view', 704))) which I think should be like this (704).

Can anyone help me to understand what went wrong?

Thank you!

아바타
취소
베스트 답변

hi,

you have to change the following line.

 view = iuv.browse(request.cr, request.uid, [('id', '=', view_id), ], context=None)

with new line below.

 view = iuv.browse(request.cr, request.uid, [('id', '=', view_id[1]), ], context=None)

아바타
취소
작성자 베스트 답변

Thank you for helping. I tested this with return view_id[1] to see wat's the output. 
Sometimes you just can not get the simplest things.

Thank you very much!

아바타
취소

Always your welcome :)

관련 게시물 답글 화면 활동
1
10월 24
1423
1
6월 20
6057
5
7월 18
6408
0
3월 15
4408
1
12월 24
4408