- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2023 04:02 PM
Hello community! I am in the process of trying to create a Dynamic Content Widget that allows the user to set some fields and it will generate a calendar report based on their selections. Using the info in Embedding reports in Jelly, I have gotten to ALMOST work. The user can select their items and then click a button to create the report. The calendar report appears but no events:
I know they're there because if I click on the "View all records" link at the bottom, the resulting List View shows me just what I want:
Here's the parameters I set:
var params = {sysparm_table: "change_request", sysparm_type: "calendar", sysparm_field: "start_date", sysparm_trend_field: "start_date", sysparm_trend_interval: "year", sysparm_query: QFull};
(QFull is built before this based on the selections and I know that is working based on the List View...)
It seems that I'm not setting the parameter which corresponds to the Report UI field of "Calendar by" correctly. What am I missing here?
Thanks for the help!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-05-2023 12:16 PM
After MULTIPLE Google searches, I finally found the parameter I needed. Seems the parameter for calendar fields is called "sysparm_cal_field". Once I used that - it all worked correctly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-05-2023 12:16 PM
After MULTIPLE Google searches, I finally found the parameter I needed. Seems the parameter for calendar fields is called "sysparm_cal_field". Once I used that - it all worked correctly.