Embedding a custom calendar report - can't get "Calendar by" set right!

Jeff R_
Giga Expert

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:

JeffR__0-1696459880844.png

 

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:

JeffR__1-1696460221389.png

 

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!

1 ACCEPTED SOLUTION

Jeff R_
Giga Expert

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.

View solution in original post

1 REPLY 1

Jeff R_
Giga Expert

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.