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
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
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
At step 4, Tick the box ' selected feature'
Oisin
Get BlueMail for Android
On 30 May 2024, 20:49, at 20:49, Bernd Vogelgesang via QGIS-User
wrote:
>Did you e.g. try to copy the selected region to a memory layer and
>perform the clip with that? Maybe the outcome gives some clues …
>
>
get_feature(layer, attribute, value)
This returns a feature. You can then wrap this in attributes() to return a
dictionary of attribute names and values.
You then add ['attributename'] on end to return value.
So for each table
something like
attributes(get_feature('table1', 'common-id-name',
No it won't work. It's not SQL syntax, it's expression syntax. So you need to
use a function to get the corresponding feature from another layer. Hence
getfeature() or one of the overlay_ functions.
You will end up with a long expression.
Or, you could use sql in dB manager?
Oisin
07570
You definitely need to define the layer for each attribute (except the current
layer).
You also need a way to find the comparable record, e.g.
(i) with a common id (use getfeature() to access attribute) or
(ii) spatially use one of the overlay functions.
Oisin
Get BlueMail for Android
On
If you use Python it should be fairly simple to enumerate all layers, test to
see if they're file based and then use pattern matching to alter the file paths
Oisin
07570 977449
Get BlueMail for Android
On 4 Apr 2024, 19:28, at 19:28, "Tony Shepherd (FarmMaps NZ) via QGIS-User"
wrote:
>Hi
Once you have created the virtual field, you can add them to your form. Open
form properties,go to form, choose drag and drop form designer, add the
available attributes from left hand panel to middle panel. Right hand panel is
for form widget settings.
Hope that helps
Get BlueMail for
