Attribute, Table Direct and date field support


this patch improve attributes with new type
1. Table Direct
2. Date

users will able to refer from attributes to tables and define custom date.




Deepak Pansheriya
October 24, 2020, 2:16 PM

Thanks for reporting. Will fix same.

Deepak Pansheriya
October 25, 2020, 9:38 AM

looks this issue is not related to this ticket. We tested following with ad_column and able to reproduce same.

Following are steps

Login with System role
Table and Column: C_Order - Create new column
- Element = Notification_Client_ID
- Name = Notification Client
- Reference = Search
- Length = 10
- Reference Key = AD_Client All Clients
- Updatable = TRUE
- Empty value set in these field => Default Logic, Read Only Logic, Mandatory Logic
- Save and Synchronize column

Window, Tab and Field:
- Search: Sales order
- Open Tab: Order
- Add new field
> Name = Notification Client
> Column = Notification_Client_ID
> Save

Do Change Role
Client: GardenWorld
Role: GardenWorld Admin Not Advanced

Open Sales Order Window
Navigate to Notification Client field
Click on search more button
The user can search for all the clients in the system


Deepak Pansheriya
October 25, 2020, 9:39 AM

I suggest to create new bug

Carlos Ruiz
October 26, 2020, 11:24 AM

, in your test case it says:

> Login with System role

Creating such things with System role, or with an Advanced Role is OK. Advanced Roles have basically the keys of the server (same as System).

Which is unacceptable on security terms is allowing a non-advanced role (an end user) to be able to configure that thing.

This possibility was opened because of this ticket.


Carlos Ruiz

Deepak Pansheriya
October 26, 2020, 11:56 AM

@Cruiz understood. I reviewed and approved your PR yesterday. Do merging required manually or it needs Hengsin approval?


Deepak Pansheriya


Norbert Bede


Tested By