查找具有特定值的子级的属性名称

function findPropertiesWithValue(obj, targetValue) {
  let result = [];

  for (let key in obj) {
    if (obj[key] === targetValue) {
      result.push(key);
    } else if (typeof obj[key] === 'object') {
      result = result.concat(findPropertiesWithValue(obj[key], targetValue));
    }
  }

  return result;
}

// 示例数据
const data = {
  prop1: 'targetValue',
  prop2: {
    prop3: 'targetValue',
    prop4: {
      prop5: 'targetValue',
      prop6: 'otherValue'
    }
  },
  prop7: 'otherValue'
};

// 调用递归函数
const result = findPropertiesWithValue(data, 'targetValue');
console.log(result); // 输出: ['prop1', 'prop3', 'prop5']

SELECT column_name
FROM table_name
WHERE column_name = 'targetValue';

def find_properties_with_value(obj, target_value):
    result = []

    for key, value in obj.items():
        if value == target_value:
            result.append(key)
        elif isinstance(value, dict):
            result.extend(find_properties_with_value(value, target_value))

    return result

# 示例数据
data = {
    'prop1': 'targetValue',
    'prop2': {
        'prop3': 'targetValue',
        'prop4': {
            'prop5': 'targetValue',
            'prop6': 'otherValue'
        }
    },
    'prop7': 'otherValue'
}

# 调用递归函数
result = find_properties_with_value(data, 'targetValue')
print(result)  # 输出: ['prop1', 'prop3', 'prop5']