HSDL HDL lines
Summary
looking to query HDL lines from a successfully loaded HSDL template.Content
I was trying to report out on the HDL lines (successfully) loaded from an HSDL execution. Is this possible to do? From what I have seen so far, it does not seem like successful lines are stored.
SELECT HRC_DL_DATA_SET_BUS_OBJS.DATA_SET_ID AS DATA_SET_ID, HRC_DL_DATA_SETS.DATA_SET_NAME AS DATA_SET_NAME, HRC_DL_DATA_SET_BUS_OBJS.DATA_FILE_NAME AS DATA_FILE_NAME, HRC_DL_DATA_SET_BUS_OBJS.DATA_SET_BUS_OBJ_ID AS DATA_SET_BUS_OBJ_ID, HRC_DL_FILE_LINES.* FROM HRC_DL_DATA_SET_BUS_OBJS HRC_DL_DATA_SET_BUS_OBJS, HRC_DL_DATA_SETS HRC_DL_DATA_SETS, HRC_DL_FILE_LINES HRC_DL_FILE_LINES WHERE HRC_DL_DATA_SET_BUS_OBJS.DATA_SET_ID =HRC_DL_DATA_SETS.DATA_SET_ID AND HRC_DL_DATA_SET_BUS_OBJS.REQUEST_ID=HRC_DL_DATA_SETS.REQUEST_ID AND HRC_DL_DATA_SETS.UCM_CONTENT_ID = :p_content_id AND HRC_DL_FILE_LINES.DATA_SET_BUS_OBJ_ID(+) = HRC_DL_DATA_SET_BUS_OBJS.DATA_SET_BUS_OBJ_ID
Tagged:
4