Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0041480Openbravo ERP00. Application dictionarypublic2019-07-30 10:292022-02-01 07:24
vmromanos 
Triage Platform Base 
normalminoralways
newopen 
5
 
 
Core
No
0041480: Unable to link an Organization or Client/Organization table to "Client Definition" dataset (for sampledata)
The Client Definition dataset, which is used to export sampledata, doesn't allow you to enter tables defined at Organizatin or Client/Organization level.

This seems to be a regression because there are many tables defined at any of those levels already included into the dataset
As System Admin
Go to Dataset window and search for "Client Definition" record.
Go to Table and search for C_Invoice table (example of Organization data access level). Verify it's included (OK).
Open the record in form view. Verify it shows "**C_Invoice", which means this record is not allowed to be there according to the validation rule associated to the field.
Create a new record in Table tab, try to search for any Organization or Client/Organization access level table, like for example C_Invoice. Verify it's not found although it should.
No tags attached.
Issue History
2019-07-30 10:29vmromanosNew Issue
2019-07-30 10:29vmromanosAssigned To => platform
2019-07-30 10:29vmromanosModules => Core
2019-07-30 10:29vmromanosTriggers an Emergency Pack => No
2019-07-30 10:33vmromanosNote Added: 0113700
2022-02-01 07:24alostaleAssigned Toplatform => Triage Platform Base

Notes
(0113700)
vmromanos   
2019-07-30 10:33   
The validation rule "AD_DataSet_Table access level" is filtering out the client/org (3) and org (1) tables where the dataset access level is System only (4):

(ad_table.accesslevel in ('4','6','7') and exists(select 1 from ad_dataset
where ad_dataset_id = @AD_DATASET_ID@
and ad_dataset.accesslevel = '4'))