I am using getPortalReportDataSubset function to build tempo report. In the port

I am using getPortalReportDataSubset function to build tempo report. In the portal report I have created a column (definition= process_duration() , Formatting = Normal text ) to capture process execution time.

It works fine on portal report but on tempo report comes empty.

Any workaround for this ?

OriginalPostID-140338

OriginalPostID-140338

  Discussion posts and replies are publicly visible

Parents
  • Works for me on 7.7 if using "Number" and =todecimal( process_duration()) and the SAIL code below. In my example the second column is the one with the process duration.

    I'm also attaching a video showing how I did it for you to find what's wrong with yours.

    = load(
    local!pagingInfo: a!PagingInfo(
    startIndex: 1,
    batchSize: 10
    ),
    with(
    local!result: getportalreportdatasubset(
    cons!PORTAL2SAIL_EXAMPLE_REPORT,
    local!pagingInfo
    ),
    local!col1name: local!result.columns[2].label,
    local!col1data: local!result.data[2].cells.value,
    local!test: local!result.startIndex,
    a!dashboardLayout(
    firstColumnContents: {
    a!textField(
    label: col1name,
    readOnly: true,
    value: local!col1data
    )
    },
    secondColumnContents: {}
    )
    )
    )


    portal_2_sail_process_duration_example.swf

Reply
  • Works for me on 7.7 if using "Number" and =todecimal( process_duration()) and the SAIL code below. In my example the second column is the one with the process duration.

    I'm also attaching a video showing how I did it for you to find what's wrong with yours.

    = load(
    local!pagingInfo: a!PagingInfo(
    startIndex: 1,
    batchSize: 10
    ),
    with(
    local!result: getportalreportdatasubset(
    cons!PORTAL2SAIL_EXAMPLE_REPORT,
    local!pagingInfo
    ),
    local!col1name: local!result.columns[2].label,
    local!col1data: local!result.data[2].cells.value,
    local!test: local!result.startIndex,
    a!dashboardLayout(
    firstColumnContents: {
    a!textField(
    label: col1name,
    readOnly: true,
    value: local!col1data
    )
    },
    secondColumnContents: {}
    )
    )
    )


    portal_2_sail_process_duration_example.swf

Children
No Data