JSONArray_MatchBy_KeyValuePair ( inputArray, matchKey, matchValue )

A While() loop that searches an array of objects for a specific key-value pair. Returns an array of indexes.

Be the first to rate this function Log in to vote

David A Sullivan - Show more from this author
Mandelbrot LLC
http://mandelbrotllc.com

Sample input:

"[{\"foo\":\"bar\"}, {\"herp\":\"derp\", \"foo\":\"bar\"}, {\"herp\":\"derp\"} ]" , "foo" ; "bar"

Sample output:

[0,1]

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
A While() loop that searches an array of objects for a specific key-value pair.  Returns an array of indexes. 

v1.1 2024-09-26 by sully@mandelbrotllc.com
*/

While (

  [
    array = inputArray ;
    key = matchKey ;
    value = matchValue ;
    
    objCount = ValueCount ( JSONListKeys ( array ; "" ) ) ;
    i = 0 ; 
    matchArray = "" ;
    currentValue = "" ;
    matchCount = 0
  ] ; 

  i < objCount ;

  [
    currentValue = JSONGetElement ( array ; "[" & i & "]." & key ) ;
    matchCount =  If ( PatternCount ( currentValue ; value ) > 0 ; matchCount + 1 ; matchCount ) ;
    matchArray = If ( PatternCount ( currentValue ; value ) > 0 ; JSONSetElement ( matchArray ; "[" & matchCount - 1 & "]" ; i ; 2 ) ; matchArray ) ;
    i = i + 1 
  ] ; 

  matchArray

)

A While() loop that searches an array of objects for a specific key-value pair. Returns an array of indexes. Requires FM21+.

2024-09-05 by sully@mandelbrotllc.com
Special thanks to Martin Sorich for spotting a typo

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

JSONArray_MatchBy_KeyValuePair ( inputArray, matchKey, matchValue )

Comments

Support this website.

Support this website.