I am using the getdatasubsetdownloadlinkfromrule to provide export functionality

deeptip

Certified Senior Developer

over 10 years ago

I am using the getdatasubsetdownloadlinkfromrule to provide export functionality from tempo reports. While passing the filter criteria I use a!toJson() & a!fromJson() resp. While my expression works for any text type filters, if I have a date type filter it fails. Do we need some sort of conversion from date to text?

Discussion posts and replies are publicly visible

0 Antony Alexia Charles Arokiasamy
Certified Senior Developer
over 10 years ago

Yes we need date and conversion. While passing the function to a!toJson it must be of text type and when the value is passed to actual rule(where the data subset is formed)and where the filter value is there, we have to use todate() function for conversion.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 deeptip
Certified Senior Developer
over 10 years ago

Thanks that worked :). One more thing .. I am also trying to set the report name dynamically like-
concat(<constant value>,dateText(now(),"dd/mm/YYYY hh:mm:ss"))

However this too doesn't work, any suggestions?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Antony Alexia Charles Arokiasamy
Certified Senior Developer
over 10 years ago

I tried setting the name dynamically with the filtered value, but it didn't work it only accept values that is present inside " " in filename:
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 apoorvac over 10 years ago

Hi Deepti, in our case, I have set report name dynamically as input to the rule. Check if it helps to you too.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 deeptip
Certified Senior Developer
over 10 years ago

I tried doing that but that did not work. If possible please share your code snippet, that might help me fix my problem. Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 deeptip
Certified Senior Developer
over 10 years ago

updating with my findings- I was trying to append the file name with the timestamp (MM/dd/yyyy hh:mm:ss) and this was failing.. hence I replaced the "/",":" and space with a hyphen character and that worked. So I guess this was related to the special characters in the file name.

Thanks everyone for your pointers :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 apoorvac over 10 years ago

I did not use date as a part of filename. When I tried your expression, got the issue and was still debugging it. Thanks for the update. :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 deeptip
Certified Senior Developer
over 10 years ago

Adding new query to this- how do we pass array type using a!toJson()
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 apoorvac over 10 years ago

Array can be passed like any other variable. Tried one sample code. PFA screenshot. Hope it helps.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 deeptip
Certified Senior Developer
over 10 years ago

Thanks Apoorva, I realized that my issue wast not passing the array but the number of elements in the array. If I have like a lot many elements in the array,something goes wrong and my export function doesn't work. Any idea on where can I find details about the data size restrictions while using these functions?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel