0

I'm trying to symbolize earthquake points by intensity, depth and date, I could create twelve separate layers but I thought using the rule based symbology would create a single nice and tidy layer, however I am having problems with the points displaying, they aren't. What's interesting is if I take the same SQL and put it in the Provider Feature Filter on the Source tab they do work.

I am missing something, but I don't know what, any ideas?

See attached below.

enter image description here

Below are two images, both use the same SQL but only the filter results in any records:

enter image description here

enter image description here

7
  • Can you specify what your field attributes are, does any of the symbol show up ? Have you tried one rule only : does it show up ?
    – Kasper
    Commented Mar 22, 2023 at 18:46
  • None of the symbols show up, unless the same SQL is added to the Feature Provider Filter. The field attributes are time stored as QDATE and spans a year, magnitude stored as double and has values 1 - 6.5ish, and depth, also a double and goes from .5 to 30Km. Commented Mar 22, 2023 at 18:54
  • Not clear to me what 'the same SQL' being added : can you show bothe cases by updating your question?
    – Kasper
    Commented Mar 22, 2023 at 19:25
  • I've added a couple screenshots Commented Mar 22, 2023 at 20:09
  • 1
    I am not sure the expression (in the rule) is SQL and handles Between. It is valid in the expression editor ?
    – Kasper
    Commented Mar 22, 2023 at 20:37

1 Answer 1

4

Short answer: Rule based styling expressions are not SQL, use the expression syntax instead

1
  • Thanks, I was afraid it might be something like that, I'll have to figure something out then. Commented Mar 23, 2023 at 19:28

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.