SQL IN Statement

Luc

31 mai 2024 11:48 Modifié

I need some help doing the following.

1. I querry a layer on an id. This generates multple features with this id.

2. I want to use a sql statment with the IN function in my set layer definition, so using a for each a build a string which end up looking like this, this is a different locationid: (1,2,3).

3. Then i use the following expression in the layer definition =`DIFFERENTLOCATIONID' IN '${$test.result}'`. Test result being the (1,2,3). This will hopefully filter out on this diferentid.

I tested this querry in the REST API and it works. Why is this not wokring in Vertigis. The layer crashes when trying to execute.

0

• 

  Mike Diss-Torrance

  31 mai 2024 11:48

  Try adding brackets around the numbers: SQL IN Operator (w3schools.com) so the resultant where clause looks like this:

  DIFFERENTLOCATIONID IN (1,2,3)

   

  0
• 

  Luc

  31 mai 2024 11:56

  =`DIFFERENTLOCATIONID IN (${$test.result})` When i use it like this and removed the brackets from the input string it works! Thankyou!

  0
• 

  Berend Veldkamp

  14 juin 2024 12:38

  No need to remove brackets if you do this $test.result.join(",")

  0

Vous devez vous connecter pour laisser un commentaire.