Get Information of a parent

getFamilyName

(
    $getFamilyName := function($ParentId){
        $$[type="Family" and id = $ParentId].name
    };

    $[type = "FamilySymbol"].{
            "id": id,
            "type": type,
            "name": name,
            "familyname": $getFamilyName(parent.id),
        }
)

Get Information of the Family Symbol en de Family and assemblyCode moet matchen

(
  $getSym := function($id){ $$[type = "FamilySymbol" and id = $id and $string(values.assemblyCode) ~> /^61.4[024]$/i][0] };
  $getFam := function($id){ $$[type = "Family" and id = $id][0] };

  $[type = "FamilyInstance" and (
      $sym := $getSym(parent.id);
      $fam := $getFam($sym.parent.id);
      $count($match($fam.name, /^NLRS/)) = 1
  )].{
    "id": id,
    "type": type,
    "name": name,
    "familyTypeId": parent.id,
    "familyTypeName": $getSym(parent.id).name,
    "assemblyCode": $getSym(parent.id).values.assemblyCode,
    "familyName": $getFam($getSym(parent.id).parent.id).name
  }
)