My dql query:
SELECT dss_reg_number,dsdt_reg_date,dss_department_index,dss_author_name,dss_contract_number,filename, dss_quality, dss_color, drs_list_format, drs_file_zoom, dri_page_count, drs_file_copy_count, dss_status FROM dbo.uv_printrequest_exec
return wrong values for fields dss_quality, dss_color,dss_status.
Values of this fields should be longer then it show in dql result. sql query to this view return right results.
View "dbo.uv_printrequest_exec" constructor :
SELECT p_req.r_object_id, drds.dss_reg_number, drds.dsdt_reg_date, dis.dss_author_name, app_inf.dss_department_index, p_req.dss_contract_number,
SUBSTRING(dpr.drs_file_path, dbo.udf_Instr('\', dpr.drs_file_path, 1, 20) + 1, LEN(dpr.drs_file_path) - dbo.udf_Instr('\', dpr.drs_file_path, 1, 4) + 1) AS filename,
CASE p_req.dsb_draft WHEN '1' THEN 'чистовик' WHEN '0' THEN 'черновик' END AS dss_quality,
CASE dpr.drb_file_color_print WHEN '0' THEN 'ч/б' WHEN '1' THEN 'цв' END AS dss_color, dpr.drs_list_format, dpr.drs_file_zoom, dpr.dri_page_count,
dpr.drs_file_copy_count,
CASE drds.dss_status WHEN 'Archived' THEN 'архив' WHEN 'Execution' THEN 'исполнение' WHEN 'Signature' THEN 'утверждение' END AS dss_status
FROM dbo.ddt_registered_document_s AS drds INNER JOIN
dbo.ddt_printrequest_s AS p_req ON drds.r_object_id = p_req.r_object_id INNER JOIN
dbo.ddt_printrequest_r AS dpr ON p_req.r_object_id = dpr.r_object_id INNER JOIN
dbo.ddt_internal_s AS dis ON p_req.r_object_id = dis.r_object_id INNER JOIN
dbo.ddv_appointment_info AS app_inf ON dis.dsi_author_app_id = app_inf.dsi_appointment_id
Any idea ? what am i doing wrong ?
Our platform documentum 5.3 sp 2.
