QgsPgQueryBuilderBase Query builder for PostgreSQL layers (using PostGIS) Gary Sherman QgsPgQueryBuilderBase 0 0 442 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 50 25 = btnIn 50 25 IN btnNotIn 50 25 NOT IN btnLessThan 50 25 < btnGreaterThan 50 25 > btnPct 50 25 % btnLessEqual 50 25 <= btnGreaterEqual 50 25 >= btnNotEqual 50 25 != btnLike 50 25 LIKE btnAnd 50 25 AND btnILike 50 25 ILIKE btnOr 50 25 OR btnNot 50 25 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 )