0006135: Clean up selectors associated infor from AD and DB

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0006135

Openbravo ERP

00. Application dictionary

public

2008-11-20 19:49

2018-04-15 15:12

Reporter

rafaroda

Assigned To

shuehner

Priority

low

Severity

minor

Reproducibility

always

Status

scheduled

Resolution

open

Platform

OS Version

Ubuntu 7.10

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0006135: Clean up selectors associated infor from AD and DB

Description

Now in trunk selectors have only one file instead of selector_F1.html, selector_F2.html....

There are 3 issues:
A) Some of these deleted files still remain referenced in ad_model_object_mapping table.
B) Locator Search selector do not have a Selector Class associated. Should it be removed?
C) AD_REFERENCE_TRG2 trigger still creates the selector_F1.html, selector_F2.html... structure if you create a new selector.

Steps To Reproduce

A) 1) Go to Application Dictionary || Reference
2) Filter by Validation Type = Search Validation
3) For each of the selectors, go to Selector Class tab then to Selector Mapping tab and check that files there correspond to files inside /src/org/openbravo/erpCommon/info/ https://dev.openbravo.com/websvn/openbravo/trunk/src/org/openbravo/erpCommon/info/ [^]

B) 1) In the same place that A), look for Locator Search reference and see that Selector Class tab is empty.

C) 1) Create a new reference with Validation Type = Search Validation
2) Go to Selector Class tab and see that org.openbravo.erpCommon.info.newselector has been created.
3) Go to Selector Mapping tab and notice that selector_F1.html, selector_F2.html.... structure has been created when it is not used anymore (see attached image)

Proposed Solution

A) and B) Make Application Dictionary data clean-up.
C) Review AD_REFERENCE_TRG2 trigger and remove lines 62 to 78 (in the XML): https://dev.openbravo.com/websvn/openbravo/trunk/src-db/database/model/triggers/AD_REFERENCE_TRG2.xml [^]

Additional Information

Tags

No tags attached.

Relationships

related to	defect	0006006	closed	rafaroda	Incorrect name of selector "Sales order line"
has duplicate	defect	0006233	closed	rafaroda	Search reference Trigger
blocks	design defect	0032688	acknowledged	Triage Platform Base	remove unused resources