You are viewing limited content. For full access, please sign in.

Discussion

Discussion

Quickfields - Lookup does not list all tables in a database

Quick Fields
Updated January 15, 2020
posted on January 14, 2020

I have a table called oe_hdr in the database. But it doesn't show up in the the table drop down using the Lookup object. What would filter some tables out?

If I open studio and login with the same user, I can query the table to verify it exists.

Then when I type it into the Quickfields lookup field, it does not show in the list.

 

0 0
replied on January 15, 2020

If you go into the configuration of the ODBC Data Source that you are using, can you change the default database from 'master' to whatever database that table is in? That has worked for me in the past when the Quick Fields list doesn't show the specific table I'm looking for.

0 0
replied on January 15, 2020

Oh we are using an SQL connection. The tables listed here are in our database, it is just filtering out some tables.

0 0
replied on January 15, 2020

Are the tables in the user's schema? Quick Fields, unlike Workflow, only retrieves objects from the user's schema. This is a known  issue. #219537

0 0
replied on January 15, 2020

They are all in the dbo schema, which is the group that I am in since I am using the built in sa user. Is there any way to list them in alphabetical order, I am wondering if there is an issue with typing the name of the table.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...