Re: [Qgis-user] Query Builder - I thought I understood what I was doing.

Or this: right("string",4) in ('2022','2023','2024') Árni Geirsson *Alta ehf* // +354 582 5003 // +354 897 9549 On Wed, 12 Jun 2024 at 19:07, chris hermansen via QGIS-User < qgis-user@lists.osgeo.org> wrote: > Jeremy, list; > > On Wed, Jun 12, 2024 at 11:40 AM Jeremy Swarm via QGIS-User < > qg

Re: [Qgis-user] Query Builder - I thought I understood what I was doing.

Are you entering the filter in the expression builder from the attribute table. If so, type substring("DateSale") in ('2021',  '2022', '2023', '2024') This should filter the table to show features with "DateSale"='2021' or '2022' or '2023' or '2024'. ⁣Oisin Get BlueMail for Android ​ On 12 J

Re: [Qgis-user] Query Builder - I thought I understood what I was doing.

Jeremy, list; On Wed, Jun 12, 2024 at 11:40 AM Jeremy Swarm via QGIS-User < qgis-user@lists.osgeo.org> wrote: > I have a set of vectors (it's a parcel map) from my county. This layer has > a number of attributes defined. I would like to filter the features by an > attribute called "DateSale". it

Re: [Qgis-user] Query Builder - I thought I understood what I was doing.

Sorry, slice doesn't work on expressions. Use substring("DateSale", 7, 10) ⁣Oisin 07570 977449 Get BlueMail for Android ​ On 12 Jun 2024, 19:59, at 19:59, "oisin.kelly.w...@gmail.com" wrote: >ClIf its a string can use slice, e.g. >"DateSale"[7:10] to return > > >⁣O > >Get BlueMail for An

Re: [Qgis-user] Query Builder - I thought I understood what I was doing.

this explanation is opaque. can you explain how i use this in the query builder? is it a matter of adding an attribute that is calculated by the slicing? -- This message would have been encrypted if you were using Delta Chat or some other autocrypt-compatible email client. I am also reachable

Re: [Qgis-user] Query Builder - I thought I understood what I was doing.

ClIf its a string can use slice, e.g. "DateSale"[7:10] to return ⁣O Get BlueMail for Android ​ On 12 Jun 2024, 19:40, at 19:40, Jeremy Swarm via QGIS-User wrote: >I have a set of vectors (it's a parcel map) from my county. This layer >has a number of attributes defined. I would like to f

[Qgis-user] Query Builder - I thought I understood what I was doing.

I have a set of vectors (it's a parcel map) from my county. This layer has a number of attributes defined. I would like to filter the features by an attribute called "DateSale". it is formatted MM/DD/. I believe it is astring. I would like to find features which end with any of 2021,2022,202

Re: [Qgis-user] Query Builder does not support joins on postGIS layers - QGIS Dufour

On Wed, Nov 13, 2013 at 2:23 AM, Andrew Kokkalis wrote: > In QGIS 1.8, when inserting new layers, the user could combine multiple > layers and perform join operations on specified attributes. Hey Andreas, I'm not sure where you mean. Nothing has been removed in this regard as far as I know. I

[Qgis-user] Query Builder does not support joins on postGIS layers - QGIS Dufour

System configuration: QGIS 2.0.1 on Ubuntu 13.04 (64bit). I use QGIS to visualize multiple postGIS layers extracted from OSM data. In QGIS 1.8, when inserting new layers, the user could combine multiple layers and perform join operations on specified attributes. This feature was also available fr

[Qgis-user] Query Builder error (MS SQL 2008 table)

Hello Qgis-users, I am trying to make very simple query in Query Builder on layer 'point' which is opened from MS SQL 2008 R2 server "ID" = 6 but this error always appear: [Microsoft][SQL Server Native Client 10.0][SQL Server] Invalid object name 'point'. QODBC3: Unable to

Re: [Qgis-user] Query Builder

Thank you for your feedback. I followed your suggestions and everything went fine! I Changed the encoding to UTF-8 and the problem is gone! BTW using 1.7.3 Best Regards, André Mano 2012/1/7 Sake Wagenaar > I noted something else, by opening the attribute table in LibreOffice > Calc or Excel

Re: [Qgis-user] Query Builder

I noted something else, by opening the attribute table in LibreOffice Calc or Excel. Several names in the second column contain strange characters, which are invisible in QGIS (e.g.: MExRTOLA en ESPIxRITO SANTO; strange characters have been replaced by 'x') . That's why your query returns no re

Re: [Qgis-user] Query Builder

I did a query on your file and got the same result (QGIS 1.7.3, Windows version). If I remove one of the values en enter it again, the query returns the modified record. This only works if I don't use special characters. Sake Wagenaar Op 7-1-2012 16:44, ALT SHN schreef: Hello, I'm having a

Re: [Qgis-user] Query Builder

On 01/07/2012 05:44 PM, ALT SHN wrote: Hello, I'm having a hard time using query builder with a point vector layer. Somehow it doens't seem to recognize all the entities, and as such a simple query as the one below returns "The where clause returned 0

[Qgis-user] Query Builder

Hello, I'm having a hard time using query builder with a point vector layer. Somehow it doens't seem to recognize all the entities, and as such a simple query as the one below returns "The where clause returned 0 entities" "Freguesia" = 'ESPIRITO SANTO' This never happened to me before. I attach

Re: [Qgis-user] Query builder tool

Dnia piątek, 18 grudnia 2009 o 19:26:31 Woolard, Zachary S. napisał(a): > If you open the attribute table for a shapefile, there is a button to > the lower right of the attribute table labeled "Advanced." This opens > the query builder tool. If you have your data in PostGIS, you will also find mo

RE: [Qgis-user] Query builder tool

eo.org] On Behalf Of legio nostra Sent: Friday, December 18, 2009 12:29 PM To: qgis-user@lists.osgeo.org Subject: [Qgis-user] Query builder tool Hello everyone, Is there a tool such as Query builder? in Qgis? Thanks ___ Qgis-user mailing list

[Qgis-user] Query builder tool

Hello everyone, Is there a tool such as Query builder? in Qgis? Thanks ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user