I have a client that added extra security to JDE, and they needed to whitelist every table used in the portal. After this, the query builder and column recommended values stopped working.
What needs to be whitelisted in JDE to get these to populate?
Query builder and column recommended values
-
- Posts: 29
- Joined: September 8th, 2021, 2:59 pm
- Contact:
-
- Posts: 329
- Joined: August 26th, 2021, 9:18 am
- Contact:
Re: Query builder and column recommended values
EASYProcess needs access to the tables that have the definitions. This varies database type to database type.
word count: 17
-
- Posts: 29
- Joined: September 8th, 2021, 2:59 pm
- Contact:
Re: Query builder and column recommended values
Do you know what is needed for a JDE instance sitting on an MSSQL database?
word count: 15
-
- Posts: 574
- Joined: August 26th, 2021, 9:56 am
- Contact:
Re: Query builder and column recommended values
For MSSQL tables EASYProcess reads from {DBName}.sys.Tables and for columns the GetSchemaTable function is used to populate.
word count: 19