QgsPgQueryBuilderBase Query builder for PostgreSQL layers (using PostGIS) Gary Sherman QgsPgQueryBuilderBase 0 0 525 461 7 7 0 0 PostgreSQL Query Builder image0 unnamed layout5 unnamed spacer2_2 Horizontal Fixed 30 21 btnClear Clear false btnTest Test false btnOk Ok true Cancel Cancel spacer2 Horizontal Fixed 30 21 groupBox2 7 7 0 0 Values unnamed btnGetAllValues All lstValues btnSampleValues Sample groupBox1 Fields unnamed lstFields lblDataUri Datasource: groupBox4 Operators unnamed btnEqual 74 32767 = btnIn 74 32767 IN btnNotIn 74 32767 NOT IN btnLessThan 74 32767 < btnGreaterThan 74 32767 > btnPct 74 32767 % btnLessEqual 74 32767 <= btnGreaterEqual 74 32767 >= btnNotEqual 74 32767 != btnLike 74 32767 LIKE btnAnd 74 32767 AND btnILike 74 32767 ILIKE btnOr 74 32767 OR btnNot 74 32767 NOT groupBox3 32767 116 SQL where clause unnamed txtSQL 789cb598d95263471286effd141dce3bc74459fb1213730108c426812416c1c45c642d470b6295044813f3ee533af967b5edc6dd6077879ae8f85495957b2dfaf5974fc3d3cea75f7efd69bee0c5c47d72637efaf48b5fdedeaefefd9f7ffdf7a79f2b8d4f9b7fd5faa7d2cffff8e9e7dee293fbd4bdbf0b1b7083085428940a85c286f9105c11a622b8216caa6007867c59e509acf2a760955f82557e265c81bc698155be0056f93518f2fc2c5c55f911b80af9137013e30f600f5e08d78ae03918f2e61eacf21958e56f84eb90e74bb0eadf01633ef5726e68bc5d155c2934366cc760f84bb3c4f97898809db0af0b6bbc7d06867cb800637e6684359ee15c58e3c55330ece503618d47b8076b3cda609d2ff96d683c2cfc6b40de3f6eb858507fb80156fbbcb0d6931d24167f1fc090777d30e40dd6d3fa312bb0fa7b279cea6507acf99c0aabbfd4154efe88fd8d72a128f36be08a303358ebb509d67adf4f2cf69e0957e01f2fc06aff5859d67715b0d6c3ab7015f2740dd6fcf4c19a9f8bc4a2df0a6bfddb1158f305fb623d4b7edc864b295ffc229ceaaf25acfe983b30fc0f4789653c086bfdd98ab0eab735e106fca11be12638e4fb55a959ae9484cfc00d89973d5296716a819db0b915ae148a62cf23b822ec6b60cde7aeb28cbb5c5fb918d76fe6fa26c295823095c0e86fb30586fe2cefd7f267fbee85d51e7a00c31e1e2a63fd0e18f6849572b998eb7b124ef5feac2cf2a60eae221e4eb85644fc9ac2f5aa30ed6db812fd93f5ed0a5c29e7eb65018c78986db083bdb7ca984fc2d52aec7d057bf1c736849b45f4ff2e18f54ba29f2b3140393f821bb23edd2963fc3531e7f91b83910f3f51167bc828437e37712eefc53eae36657e3850c67cf19f63fd8a3f75e1e44f9ebf6aa982fc672365b1df1c80618f7911d6fcd19532ec192857f3c3de1f83915fea2b633e29cb7ca7dc443d7b65b1879bca323fa83dc8977b52463c54bf9778848a70ad28ec0c18f97779fd5739da27f5b59b38b7378cc11adfb532fcdd499ccf37a7608f78559445deaf12e7f3ed5259d6a3e3c4327e265c2bc2bf4b30ece31b613d2fdc1618f131d0df684a3ff973e126facbe6f6d64aaa9ff7138b3f245c2ba25fcf95c51ebf5446fc9e128bbc57c6fa26b1d89fd6abc9f81118f9b17bcac8dfae32eaa70646bd189d8f7cd96962d1b703467efcab701dfeb99e7003f1711330e2e9f3fb458dd51f3a0257e1cf5c59fc09fb89251e13b0da375416f9305516797a492cf20c463d995ee27c9c96ca629fbd4f2ce3cfcab2be1f2796f50f85eb5a6f2365c4ff3cb1f8eb95918f83c4b2df6d0b3710df909f3ff5b2da1fcacae8ef81b2d8e7ae138bfd43e1b4be579671f70046fd505959f4715d19f171cac857078c7a0ab7c20dadf7fc7e56b75a3f6121acf1e16d30f2675f134b7e9f95ebe5dcbe00d6fd619458fabfac2cfe7aa38cfc417fa32af6ba5c3e5e07b53eb7124bfc3230fc0fedc4f978c6caa8876330f66773a28cf3aea98c7a3853467c4d6259af0bc67eed8f94e1ff9370b388fedc56867f6b612e62ff9f0a5bc6fd58d64bf1e0a02ceb675659e21ffa609ca7e4138b7f87600f1e29a3df16c24dd407b795e14f5319fe77c0a8cf40cae8876a6289e7a932ce03d8d36c62bf2a82b51ef3f75bbc8e693d74c1daff0365c9afed0b3775ff7b56c67d650facf6726259df81112f77a78c7eb85246bdde83bde42b0c95e1bf492cfa551efb83877d8cfa600bc67eed033860bfcecfbfa68be79ff05438d5d30bb85ab7f97a4f60d4836b81917f16fb9dea771d65c4a7a98cfdbd04aee27ef9a20c799daff9be5346ff3c8059f263af94615f59d8d6701fcffde74a1df13517c2293f2760f49f6d09b39eb70b30e3fe3256c6fdad0f0eb0e724b1c4a72c6c4b90bf54c6fa36b1f4f721b806fb5ec1f037e4fdc84edffb5ef4c57ce07ee984359efc0ac67ee02e94b1fe3e18f6869270b2ef32b1cc3f54c6f9b703aee1be7a07d6f533b0d61ff43bc4c3ef81753cd76f2bfafb862f0aebfb37cc85b57efc0d18fef92b30f2c15bc2ea0f4fc0c867582ba3bf96e080fb604f19f22eb1c4b726ec4ab85f9695518ff0c7d5b09f34128bfea532e2b50233fc93f5bcbe5ffca9b0bebf7c419861afb914b6d0172c58f37f0c56ffe6cab017ebab3f7ea88cfcb6c1b0dfdd2aa3df6bcae8df1618fed04419ef29d8ef507f3628e3fc990a7bb5e75219f1cbf3e1aa4df44368096bbf855d30e3fcb9168efe88ff6b65c4ff118cfdc35c29e3be7f9d58d66f80b13e559571ff3d06a3bef94419f5504f2cfea7f9e8bf9bc4621f58e3614919f63c28239f05700df5f2a28c7ae0c4327ea00cfbe689a55fb7c05a9f797fb8581fe8cf1b65f4e32d98f1fe7e56c67e48cae8af0c8c7899a132ec017be42fd495b17f5a30fcf3ac8c7c9f2796fb5b5119f19a81d5bfb532f25f4a2cfd5f05a39fbc4f2cf91e28633fba4e2cf2529f9b6199df53c6ef99b789c59e3958f395dbebab1adfd053c6f81d18f6b94b61ad9fb0a70cfb1ec0881f5965c4bf0dd6fdd681b13e3594919fae32f64bd8abfeb99058f6870365d4f39532fa41c7611f97124bfc2a60c483fbcab0b79d58e2b30f46be427e9ef9a0f10aa7c21a0f5b04633d8bf9ea3f3f2616fd2b61f59738b1f8fba48c7a1883b53f6d62e99f7d30fc730b65d8739d58e677c19a9f796219cf8433d817f2fd29d492bf5bc2a91ed78945be00c6fec22365e83b536e56f2f12e18f686a7c4e2cf9132eaa79858e2d301ebf9759b58f4ef09ab3fb69358e27da18cf5b712cbfaf02753ff39b1d4c7a332f693fc3d1652bea80d66bc6f65bda0faa8a68cf7ec0558f5cd128bbdfbca90af27167b8b60c493f2fd2d8bf6e13dbb0dd6785e27cee57b8b1ffbf9de3a0c19feb13a8c35cef81fa7c304939991197f39f27d749889999a9ba863666e7f840e7397af7f63eecd43d4f1f8bd7598a79881fb7cfdb959441d4bf3fc7d759817f36a56661dd75ee49f8d1f5bdf3f5666dbec40c34647cbecfe5d1d86cd5efc9bc8fff8ae8d388de2a765f6ff8e8eb8f281393447e6d8744cd79c9853d38bdff56336e651c3da0c623696e6ecafea88769f9b0b736986e6ca5c9b82299a52fc2b9b4a9eef45f4a06a6aa66e1aa649e6afe8d8d84b444c961c790a94d188c634a1296d6a36cf35cde896eee89e1ee88beafdb68e4dfce989e6a6440b5ad233bdd02bad684d5bb44d3b792ed6a64a2dda3593de82f63ebe5fe53eb4699f0ee8908ee8f8f30875a8bb89139dd029f5a8bfd1f0f6e7eb3a0cd380cee89c2ee8928674f5db31ba966c53818a54a2f297f6bf4f0755a84a35aa53839afc875cc6dd29db78c1c4cc961d7fb1dfbe47879970e08c473ce609fbdfdbc95364bb4545bee119dff2dd9f45ebab3a7a7ccf0f51c7233ff1fc771a16bcdce4829f4d955ff89557bce62ddefea80ec3bcc32ddee5bd68659b7fd3bf668f0f629ce67462967cc8477ccc1deef2099fbe9d93afe898984e8c408ffb3ce0333eff8d17177c9977de3ac669c8577ccd052e7289ef68fd613fca34dffc7216af3e75b3f7f9fbfc34926c37b8698d25cb5ca0b9b5d67d4cc7e6770a9b450bab5cfe6d36ed287a113b8f0a766c27a667a7f686f7ecccdeda3b7bff413f7a96622e6236ecc3e738c75abbc40e35b08fb48a3a9fec3cd64597c77661971fcd877d8e9285a8e3c5be260d07d8676754b4ab8d7f51c7da6ed96dbb635bf68dd3e3abb1dab36d5ed97d7b600f4547dc55aee5dce6e7a8e1482218e71ddb4e8c56d79ed8d30ffbd18b753fe207db975cc67eb9ccbd5898991d501fb69cd9f3a8e122eab8b4c30fea607b65af6dc1166dc99673aed8aaadd9ba6dd8a6337a5773e4789337679d736fee275fed8f13179f54dc77991bd1da8dddc44d69ea6edcccb1bb75772eaf22f7104bb7cb5df718671d7f4c47947e72f368dfc22dddb37b897faf6ee5d66ecb6dbb1d373343d77231c76ecfb5a38e95db77071fedf34dfcdda13bb24577ec3aaeeb4edca9ebb9be1bb83377ee2edca51bba2bdeb6bdd87d59f4b8edaedfde15bfb1b797ed33b12bc408155dc9955d850f5d958c615773f518c5866bf220766a9fcbde787a7b956f9c51131a7bf6d6bb783cf8f8a2cedc805aa6b719cb779a52d4d0a5b92bf9911fcbf71fd5d15bf8899ffa1b3ff3b7fecedffb07ff48771879f23146b162bb34f50b7afeabe7e026277ee99ffd8bb3b1578efdab5fa90e3af4eba8a1e3b7fcb61dfa9d3f5fe3dbf712dfa2aedff57bbeedf7fd813ff447fed8777cd79ff853df736ddf8f760cbeb6c23bee258b4d6ffb337fee2ffc015ffb4b3ff457feda177cd1977cd9577cf5eb567efd3cf7b5b873e0aee9ebbee19b213e970271db1f050e36b8b0f9e92293f96114c69fcf99f7e8887d6ef3b78bdc986761e289ae781ea66ce898e77c1acfbf8e2d869b30dbf445b8a549ec97f3f7eb087741de2da3786a3f6ccebc58b3bfb3d19d8787f068393c857988bb6f58f2c05d8577bf71c24b7835339f9901533c294eccc86761f5c5ac75d80adb761676422bec863d3f0cedf081b7413808ab70e8ceec241c6d5e16741abed8ef422774693f6c73379c84d3d00bfd30f8583ed24a67e19c9fc345b87c636c18aea81eae432114432994ff78977caf8e98fd46bc992f43e54d0baaa116eaa1119a5c0fd3b7e5dff7fec88ccfb23fd9f1dc6ec69975fead8a7abf8ede2273594cfab7e7fd1d1d514b968d7eb48ebff3f9f97ffffce9ff7614c3bf btnAnd clicked() QgsPgQueryBuilderBase insAnd() btnEqual clicked() QgsPgQueryBuilderBase insEqual() btnGetAllValues clicked() QgsPgQueryBuilderBase getAllValues() btnGreaterEqual clicked() QgsPgQueryBuilderBase insGreaterThanEqual() btnGreaterThan clicked() QgsPgQueryBuilderBase insGt() btnIn clicked() QgsPgQueryBuilderBase insIn() btnLessEqual clicked() QgsPgQueryBuilderBase insLessThanEqual() btnLessThan clicked() QgsPgQueryBuilderBase insLt() btnLike clicked() QgsPgQueryBuilderBase insLike() btnNot clicked() QgsPgQueryBuilderBase insNot() btnNotEqual clicked() QgsPgQueryBuilderBase insNotEqual() btnNotIn clicked() QgsPgQueryBuilderBase insNotIn() btnOk clicked() QgsPgQueryBuilderBase accept() btnOr clicked() QgsPgQueryBuilderBase insOr() btnPct clicked() QgsPgQueryBuilderBase insPct() btnSampleValues clicked() QgsPgQueryBuilderBase getSampleValues() btnTest clicked() QgsPgQueryBuilderBase testSql() Cancel clicked() QgsPgQueryBuilderBase reject() lstFields doubleClicked(QListBoxItem*) QgsPgQueryBuilderBase fieldDoubleClick(QListBoxItem*) lstValues doubleClicked(QListBoxItem*) QgsPgQueryBuilderBase valueDoubleClick(QListBoxItem*) btnClear clicked() QgsPgQueryBuilderBase clearSQL() btnILike clicked() QgsPgQueryBuilderBase insIlike() qgspgquerybuilderbase.ui.h insEqual() insLt() insGt() insPct() insIn() insNotIn() insLike() sql() setSql( QString sqlStatement ) testSql() getAllValues() getSampleValues() fieldDoubleClick( QListBoxItem * item ) valueDoubleClick( QListBoxItem * item ) insLessThanEqual() insGreaterThanEqual() insNotEqual() insAnd() insNot() insOr() clearSQL() insIlike() setDatasourceDescription( QString uri )