Query builder and column recommended values

btyrell · Unread post by **btyrell** » May 24th, 2022, 10:37 am

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?

SteveCap · Unread post by **SteveCap** » May 24th, 2022, 12:34 pm

EASYProcess needs access to the tables that have the definitions. This varies database type to database type.

btyrell · Unread post by **btyrell** » May 25th, 2022, 10:06 am

Do you know what is needed for a JDE instance sitting on an MSSQL database?

JustinVanRegenmorter · July 25th, 2023, 12:15 pm

For MSSQL tables EASYProcess reads from {DBName}.sys.Tables and for columns the GetSchemaTable function is used to populate.

K-Rise Systems