Skip to main content
vinayj6479
vinayj6479
January 29, 2024
Question

I am want to Export an Excel report for a filter of time period using from and to date

  • January 29, 2024
  • 2 replies
  • 0 views

Hi Team,

Iam getting raw data when i use EXPORT DSE to excel, 

example in table the priority are stores as 1, 2,3 in numbers. so when i use export DSE to excel, i get the values in Numbers in column of priority, but i need text values instead of numbers such as 1 - normal, 2- escalated etc

My another Query  is  we are using record actions to export Functionality to call a process model and send exported excel to an email.

how do i pass ri!timeperiod to record actions from Interface

2 replies

harshitb6843
harshitb6843
January 29, 2024

The answer to your second question is - You can't. This timeperiod either has to be a column in your record. Or you can call your action's process on the interface using a!startProcess or a!startProcessLink and then pass the required values in parameters. 

konduruc733182
konduruc733182
January 29, 2024

Hello [mention:15cabcad3b4e42288665e0e265116f60:e9ed411860ed4f2ba0265705b8793d05] 

For the first question, Do you have a master table where you have your ID- Status mapping?

In that case I would suggest create a view and JOIN your master data value where in place of your status ID. Create a DSE for this and use it instead of your actual table.

    Terms & ConditionsAccessibility statement