Project: 	
  | View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0041480 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| defect | [Openbravo ERP] 00. Application dictionary | minor | always | 2019-07-30 10:29 | 2022-02-01 07:24 | |||||||
| Reporter | vmromanos | View Status | public | |||||||||
| Assigned To | Triage Platform Base | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Merge Request Status | ||||||||||||
| Review Assigned To | ||||||||||||
| OBNetwork customer | No | |||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Support ticket | ||||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 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 (viewer) 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 | OBNetwork customer | => No | 
| 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 | 
| Copyright © 2000 - 2009 MantisBT Group |