查询picklist所有值

查询实体下PickList的所有value和name

--attributename 字段名
--logicalname 实体名

SELECT
	attributevalue,	
	value as name
FROM
	entity e
	INNER JOIN stringmap sm ON e.objecttypecode = sm.objecttypecode AND sm.attributename = 'new_upkeepstation' 
WHERE
	logicalname = 'incident'