Deep Link Report

[Brian_Boegs]

Does anyone have a report for items that displays a deep link?

[Brian_Boegs]

Hi Karen,

I am trying to create a report that has all my items in there and the LMS deep link to these item.

It is not a standard http link.

The deeplink requires the revision date to be formatted in milliseconds. That is a little beyond my sql abilities. The rest of the report is working fine.

SQL

to_number(to_date(TO_CHAR (FROM_TZ (CAST (to_timestamp(TO_CHAR(cp.rev_dte, 'DD/MM/YYYY HH24:MI:SS'), 'DD/MM/YYYY HH24:MI:SS') AS TIMESTAMP), 'US/Eastern') AT TIME ZONE 'GMT', 'DD-MON-YYYY HH24:MI:SS'), 'DD/MM/YYYY HH24:MI:SS')-to_date('01.01.1970 00:00:00','DD.MM.YYYY HH24:MI:SS'))*24*60*60*1000 AS rev_dte_millis

BIRT EXPRESSION:

params["DeeplinkStaticURL"].value.concat('/learning?destUrl=https%3a%2f%2fcompany%2eplateau%2ecom%2flearning%2fuser%2fdeeplink%5fredirect%2ejsp%3flinkId%3dITEM%5fDETAILS%26componentID%3d').concat(dataSetRow["CPNT_ID"]).concat('%26componentTypeID%3d').concat(dataSetRow["CPNT_TYP_ID"]).concat('%26revisionDate%3d').concat(dataSetRow["REV_DTE_MILLIS"]).concat('%26fromSF%3dY&company=zoetisinc')

[karenperez]

Dear boegersb,

You can create your own reports, or copy the standard and modify by adding the hyperlink you are looking for.

In the PRD > properties, use the "Hyperlink" area to create hyperlinks in your report.

I hope this helps!

Thank you.

Best Regards,

Karen Perez