Search function on Array returning the index

Completed

Follow

0

Don Seur

• March 04, 2019 14:20

I would like to have the possibilty to search an array for a given value and get the index returned instead of only true or false. 
E.g. I had a case in which I had one array with codes and a second array with corresponding descriptions. I had to search the first array on a certain value and get the desciption out of the second array having the same index. To do the search I had to use a while do loop. It would be great if there was an out-of-the-box function for it.

• Comment actions Permalink

  Official comment

  

  Salvatore Raunich

  • March 05, 2019 21:08

  Hi Don,

  thanks for your feature request. An array function like this would certainly improve our SQL grammar and the usability of array manipulation in Data Virtuality.

  I added this feature request to the customer wishlist and we will plan it for one of the next minor releases.

  I will keep you updated here as soon as I have an exact estimation.

  Best

  Salvatore 

• 0

  Comment actions Permalink

  

  Salvatore Raunich

  • March 01, 2022 18:15

  Hi Don,

  I am happy to inform you that we finally implemented this functionality and released it in the latest Data Virtuality Platform 2.4.21.

  Best

  Salvatore

Please sign in to leave a comment.