Page 1 of 1

Query builder and column recommended values

Posted: May 24th, 2022, 10:37 am
by btyrell
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?

Re: Query builder and column recommended values

Posted: May 24th, 2022, 12:34 pm
by SteveCap
EASYProcess needs access to the tables that have the definitions. This varies database type to database type.

Re: Query builder and column recommended values

Posted: May 25th, 2022, 10:06 am
by btyrell
Do you know what is needed for a JDE instance sitting on an MSSQL database?

Re: Query builder and column recommended values

Posted: July 25th, 2023, 12:15 pm
by JustinVanRegenmorter
For MSSQL tables EASYProcess reads from {DBName}.sys.Tables and for columns the GetSchemaTable function is used to populate.