1

Does anyone know how to use the new get Attribute function in conjunction with the "Like" command?

I have a table with an Attribute "Sub_Region" and want to show the features that match the atlas feature of the same name...

The syntax below works for "=" "Sub_Region" = attribute($atlasfeature, 'Region_Name')

However, some of my precincts cover two regions, so the attribute might be 'Central, Western'. I can manually show only those of interest by selecting: "Sub_Region" like '%Western%' .... however I want to inset the Attribute function so that I don't have to manually change the query as I export the atlas but can't work out the correct syntax...

Any suggestions?

asked Nov 28, 2014 at 1:16

1 Answer 1

3

Try something like:

 "Sub_Region" like '%' || attribute($atlasfeature, 'Region_Name') || '%'
answered Nov 28, 2014 at 3:45
1
  • perfect! thanks. I knew it would be obvious as soon as I got it... Commented Nov 28, 2014 at 4:53

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.