日期:2014-05-17 浏览次数:20861 次
select event_id as eventId, event_name as eventName, event_light_enum_id as eventLightEnumId, curr_light_enum_id as currLightEnumId,
msg_status as msgStatus, auth_status as authStatus, oversee_status as overseeStatus, problem_class_enum_id as problemClassEnumId,
parent_class_enum_id as parentClassEnumId, class_enum_id as classEnumId, warning_level_enum_id as warningLevelEnumId, last_section__enum_id as lastSectionEnumId, curr_section__enum_id as currSectionEnumId,
event_detail as eventDetail, problem_desc as problemDesc, position_des as positionDes, handle_dept_name as handleDeptName, handle_advice as handleAdvice,
verify_count as verifyCount, verify_result as verifyResult, closed_status_enum_id as closedStatusEnumId, street_code as streetCode,
community_code as communtiyCode, key_area_id as keyAreaId, (select name from sde.t_kaw_key_area b where key_area_id=b.objectid) as keyAreaName,
key_area_type_enum_id as keyAreaTypeEnumId, duty_grid_code as dutyGridCode, unit_grid_code as untiGridCode, task_code as taskCode, oversee_name as overseeName,
oversee_phonenumber as overseePhonenumber, report_time as reportTime, create_time as createTime, handle_time_limit as handleTimeLimit, coordinate_x as coordinateX,
coordinate_y as coordinateY from t_kaw_event t where 1=1 order by report_time desc