https://antibiotiqueaugmentin.com/surdosage-augmentin-bebe/
× Welcome to the ToolsJX forum!


MSSQL Views Not Showing

  • cbrock
  • cbrock's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 4 months ago #3496

Hello!

I'm using ToolsJX to display views in a MySQL database and everything works as expected, but I am unable to see any views in the Table name in database dropdown when I am using a Microsoft SQL server. The MSSQL tables show up, but the views do not. I don't believe it is a permissions issue because the same behavior happens regardless of which user account I authenticate with (even sa does not show the views).

Also, the table dropdown is not in alphabetical order when using MSSQL.

Has anyone else run into this MSSQL views issue and has any input?

BTW- I love this tool. My company will gladly pay for any enhancements and new features you release!

Thanks!
Chris

Please Log in or Create an account to join the conversation.

More
5 years 3 months ago #3497

Hi,

Thanks for reporting. We will take a look.

Cheers

The following user(s) said Thank You: cbrock

Please Log in or Create an account to join the conversation.

  • cbrock
  • cbrock's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 3 months ago #3499

Hi Tomaz!

Thank you for checking into it. I'll keep my eye on this thread for any possible updates.

Chris

Please Log in or Create an account to join the conversation.

More
5 years 3 months ago #3500

Hello Tomaz ,

Me also the same issue .
Looking forward for the solution .
Thanks

Please Log in or Create an account to join the conversation.

More
5 years 3 months ago #3501

Hello everyone ,

Any update ? :)

Please Log in or Create an account to join the conversation.

More
5 years 3 months ago #3502

Hi,

for now you can replace line 155 in administrator/components/com_grid/models/grid.php

$this->_tbList=$db->getTableList();

with
$query = "SELECT TABLE_NAME FROM information_schema.tables";
$db->setQuery( $query );
$this->_tbList=$db->loadColumn();

This should do. We will include the fix in the next release.

Last edit: 5 years 3 months ago by tomaz.
The following user(s) said Thank You: cbrock, arieluko

Please Log in or Create an account to join the conversation.

Moderators: tomaz
Time to create page: 0.285 seconds

Contact Us

Contact us on Facebook