0033304: Table reference for Resource Category Tree is not automatically filled

Openbravo Issue Tracking System - Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0033304

Modules

Resource and Reservation Management

public

2016-06-17 13:22

2016-06-17 13:23

Reporter

aferraz

Assigned To

Triage Omni OMS

Priority

normal

Severity

minor

Reproducibility

always

Status

new

Resolution

open

Platform

OS Version

Professional Appliance

Product Version

Target Version

Fixed in Version

Merge Request Status

Regression date

Regression introduced by commit

Regression level

Review Assigned To

Support ticket

OBNetwork customer

Regression introduced in release

Summary

0033304: Table reference for Resource Category Tree is not automatically filled

Description

In case Reservation Management module is installed when client is already created, ad_table_id reference will not be filled for Resource Category tree of this client.
In that case, tree view in Resource Category window will not work until table reference is added to Resource Category tree of this client.

In case client is created after installing Reservation Management module, table reference will be automatically filled.

Steps To Reproduce

As System Admin:
- Install Resource and Reservation Management module.
- Enable Tree and Node Image menu entry.

As F&B Admin:
- Open Resource Category window in tree view.
Realize view is not loaded and exception is thrown.
- Go to Tree and Node Image window and add OBRE_Resource_Category table to F&B International Group Resource Category tree.
- Open Resource Category window in tree view.
Realize view is loaded and no exception is thrown.

Proposed Solution

Run manually following query or add it in a modulescript inside Resource and Reservation Management module:

UPDATE ad_tree
SET ad_table_id = 'B47E504D23D549A5A9CD9A9A426D20AF'
WHERE treetype = 'OBRE_RC'

Additional Information