0041480: Unable to link an Organization or Client/Organization table to "Client Definition" dataset (for sampledata)

Description

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

Steps To Reproduce

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.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0113700) vmromanos (manager) 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'))

Issue History
Date Modified	Username	Field	Change
2019-07-30 10:29	vmromanos	New Issue
2019-07-30 10:29	vmromanos	Assigned To	=> platform
2019-07-30 10:29	vmromanos	Modules	=> Core
2019-07-30 10:29	vmromanos	Triggers an Emergency Pack	=> No
2019-07-30 10:33	vmromanos	Note Added: 0113700
2022-02-01 07:24	alostale	Assigned To	platform => Triage Platform Base