Query builder and column recommended values

This forum allows users to post and respond to "How Do I Do ....." questions. The information contained in this forum has not been validated by K-Rise Systems and, as such, K-Rise Systems cannot guarantee the accuracy of the information.
Post Reply
btyrell
Posts: 29
Joined: September 8th, 2021, 2:59 pm
Contact:

Query builder and column recommended values

Unread post 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?
word count: 44

Tags:
SteveCap
Posts: 329
Joined: August 26th, 2021, 9:18 am
Contact:

Re: Query builder and column recommended values

Unread post by SteveCap »

EASYProcess needs access to the tables that have the definitions. This varies database type to database type.
word count: 17
btyrell
Posts: 29
Joined: September 8th, 2021, 2:59 pm
Contact:

Re: Query builder and column recommended values

Unread post by btyrell »

Do you know what is needed for a JDE instance sitting on an MSSQL database?
word count: 15
JustinVanRegenmorter
Posts: 574
Joined: August 26th, 2021, 9:56 am
Contact:

Re: Query builder and column recommended values

Unread post by JustinVanRegenmorter »

For MSSQL tables EASYProcess reads from {DBName}.sys.Tables and for columns the GetSchemaTable function is used to populate.
word count: 19
Post Reply