topic Re: JMP Query Builder not showing tables which are visible in Database/Open Table in Discussions

JMP Query Builder not showing tables which are visible in Database/Open Table

BrendanM — Sat, 10 Jun 2023 23:25:48 GMT

Hi Folks, I'm troubleshooting an issue with some JMP queries and I've discovered I can see and access the required Oracle tables within a schema when I open the tables using the Database/Open Table option. These same tables are not visible when I use the Build Query option using the same ODBC driver and user account.

I am using JMP 15 Pro.

Is there something (probably very simple) I am missing here that is limiting my view?

Thanks for any help!

Brendan.

Re: JMP Query Builder not showing tables which are visible in Database/Open Table

Georg — Fri, 05 Feb 2021 18:46:35 GMT

As far as I see, there are the same tables on my Oracle Databases for boths ways. I did not experience so far.

But if you know the correct scheme and table name, you could do the following:

You can put the table name and scheme name in a script like below, then you should find your table in the visual mode of Query Builder.

This script you can save from query builder via red triangle button ("Save Modify Query Script"). Maybe you need to open just another table, to get that script, and than put in the right table name into the script to get your table into the visual Query Builder.

New SQL Query(
	Connection(
		"MY_DSN"
	),
	QueryName( "QUERY_NAME" ),
	Select,
	From( Table( "DATABASE_TABLE_NAME", Schema( "SCHEMA" ), Alias( "t1" ) ) )
) << Modify;

Re: JMP Query Builder not showing tables which are visible in Database/Open Table

BrendanM — Mon, 08 Feb 2021 09:17:52 GMT

Hi Georg,

Thanks for the suggestion.

I've tried connecting to many tables in the schema using both a scripted connection and the query builder but have not been successful.

I can see all tables with "Open Table" and they do open, however none are visible with Query Builder and all fail when scripted stating the tables do not exist.

I'm suspecting a permissions change (as I had no problems with the same queries until recently) but IT support are not aware of any changes on the server side.

Brendan

Re: JMP Query Builder not showing tables which are visible in Database/Open Table

ninadgorey — Wed, 22 Sep 2021 21:34:14 GMT

Hi Brendan, I have also seen something similar while using MySQL. Which ODBC connector version are you using?

Thanks,

Ninad

Re: JMP Query Builder not showing tables which are visible in Database/Open Table

albertlesire — Thu, 11 Aug 2022 07:50:40 GMT

Hi Brendan,

Had a similar issue. Table were not showing up in the query builder.
When I closed JMP and opened it again the issue was resolved. Feels like it is a bug.

Kind regards,

Albert