search

qissue-bot / QGIS

QGIS is a free, open source, cross platform (lin/win/mac) geographical information system (GIS)
http://qgis.org
GNU General Public License v2.0
0 stars 0 forks source link

query builder missing for PostGIS #238

Closed qissue-bot closed 5 years ago

qissue-bot commented 5 years ago

Author Name: venturato-faunalia-it - (venturato-faunalia-it -) Original Redmine Issue: 252, https://issues.qgis.org/issues/252

Original Assignee: Marco Hugentobler

The (very useful) query builder for [[PostGIS]] layers does no longer show operators and examples. Only textual SQL queries are now possible. r5742

qissue-bot commented 5 years ago

Original Redmine Comment Author Name: Gavin Macaulay - (Gavin Macaulay -) Original Date: 2006-08-31T19:26:35.000Z

It shows them for me. Can you attach a screenshot to illustrate?

qissue-bot commented 5 years ago

Original Redmine Comment Author Name: venturato-faunalia-it - (venturato-faunalia-it -) Original Date: 2006-08-31T21:48:36.000Z

Further testing: samples values are showed (correctly) when I choose the column name. Operators instead are not showed at all. I attached the screenshot.

qissue-bot commented 5 years ago

Original Redmine Comment Author Name: Gavin Macaulay - (Gavin Macaulay -) Original Date: 2006-09-01T00:36:00.000Z

What version of qt is your version of qgis compiled against?

qissue-bot commented 5 years ago

Original Redmine Comment Author Name: venturato-faunalia-it - (venturato-faunalia-it -) Original Date: 2006-09-01T01:58:17.000Z

On the box where QGIS was compiled:

lia@helo:~$ dpkg --list | grep qt | grep dev ii libqt4-dev 4.1.4-1 Qt 4 development files ii qt4-dev-tools 4.1.4-1 Qt 4 development tools

  1. On the box running QGIS: lia@helo:~$ ldd $(which qgis) | grep -i qt libQtCore.so.4 => /usr/lib/libQtCore.so.4 (0xa7d3b000) libQt3Support.so.4 => /usr/lib/libQt3Support.so.4 (0xa7a51000) libQtGui.so.4 => /usr/lib/libQtGui.so.4 (0xa752c000) libQtNetwork.so.4 => /usr/lib/libQtNetwork.so.4 (0xa74d5000) libQtXml.so.4 => /usr/lib/libQtXml.so.4 (0xa7490000) libQtSvg.so.4 => /usr/lib/libQtSvg.so.4 (0xa744e000) libQtTest.so.4 => /usr/lib/libQtTest.so.4 (0xa743e000) libQtDesigner.so.4 => /usr/lib/libQtDesigner.so.4 (0xa72ca000) libQtSql.so.4 => /usr/lib/libQtSql.so.4 (0xa66b0000)
qissue-bot commented 5 years ago

Original Redmine Comment Author Name: Gavin Macaulay - (Gavin Macaulay -) Original Date: 2006-09-01T02:06:39.000Z

Beats me. Is there anything you can do to the dialog box to make the operator appear? Could you try resizing the dialog box, etc?

qissue-bot commented 5 years ago

Original Redmine Comment Author Name: venturato-faunalia-it - (venturato-faunalia-it -) Original Date: 2006-09-01T02:17:23.000Z

I tried resizing, open/closing the dialog box but nothing appened. I'm sorry.

qissue-bot commented 5 years ago

Original Redmine Comment Author Name: Martin Dobias (Martin Dobias) Original Date: 2006-09-06T14:01:18.000Z

The same dialog is used also for creating queries when searching in attribute table. Please could you check whether also there are missing buttons for operators?

qissue-bot commented 5 years ago

Original Redmine Comment Author Name: venturato-faunalia-it - (venturato-faunalia-it -) Original Date: 2006-09-10T23:01:09.000Z

Yes, it's the same.

qissue-bot commented 5 years ago

Original Redmine Comment Author Name: Redmine Admin (Redmine Admin) Original Date: 2006-10-03T21:18:55.000Z

On the windows preview2 version it works as expected

qissue-bot commented 5 years ago

Original Redmine Comment Author Name: Gavin Macaulay - (Gavin Macaulay -) Original Date: 2006-10-12T23:33:08.000Z

Are they still missing when qgis is compiled against Qt 4.2.0?

qissue-bot commented 5 years ago

Original Redmine Comment Author Name: Redmine Admin (Redmine Admin) Original Date: 2006-10-12T23:48:59.000Z

Don't know. On Debian testing we still have 4.1.4-1.1

qissue-bot commented 5 years ago

Original Redmine Comment Author Name: Martin Dobias (Martin Dobias) Original Date: 2006-12-03T06:12:29.000Z

It seems that Debian has already Qt 4.2. Please could you retest?

Do you have a possibility to test on another computer to check whether it's a problem also somewhere else?

If you have still the same problem, could you try some older SVN revisions to help us find out where could be the problem?

Martin

qissue-bot commented 5 years ago

Original Redmine Comment Author Name: Martin Dobias (Martin Dobias) Original Date: 2006-12-03T11:18:14.000Z

I've prepared a small project for testing. Download attached tarball (test-ticket-252.tar.gz) and extract it. In that directory try to run:

qmake
make
./test-ticket-252

(Make sure that you're using Qt4 qmake and that you have Qt4 development files)

When you run that compiled binary (test-ticket-252) you should get the postgis builder dialog. Please report whether the buttons are missing or not. If they're missing, the problem will be probably in UI file. If they're shown OK, we'll have to search for other sources of the problem.

qissue-bot commented 5 years ago

Original Redmine Comment Author Name: Redmine Admin (Redmine Admin) Original Date: 2006-12-04T03:18:50.000Z

now it works (rev 6160)

qissue-bot commented 5 years ago

Original Redmine Comment Author Name: luca-casagrande-gmail-com - (luca-casagrande-gmail-com -) Original Date: 2007-01-12T08:35:38.000Z

This problem happen on both some gentoo machine and a debian one. I tried the test app,deleting 1 button and then recreate it and it's showed. This problem disappear if use qt4.2.1 (at least on my machine).

qissue-bot commented 5 years ago

Original Redmine Comment Author Name: anonymous - (anonymous -) Original Date: 2007-01-12T08:53:58.000Z

AFAIK wgis requirers 4.2?

qissue-bot commented 5 years ago

Original Redmine Comment Author Name: Martin Dobias (Martin Dobias) Original Date: 2007-02-01T13:31:15.000Z

Should be fixed in 6483 (0.8 branch) and 6484 (trunk).

qissue-bot commented 5 years ago

Original Redmine Comment Author Name: Anónimo (Anónimo) Original Date: 2009-08-21T22:46:00.000Z

Milestone Version 0.8 deleted