Report created on RITM or sc task table unable to show all the variables

[deloittepad8605]

Hi Team,

We have created Report on RITM table and trying to show the variables on the report.

Some to some extend we are able to add and get the values in the list view. After adding few more variables to list, all the values are coming empty.

Is there any limitation that, we can add up to these many variables only to report? any work around for this?
This is initial data shown in screenshot 1.

After adding few more variables its showing like this.

it will be helpful if anyone have faced this issue and got any workaround.

Best Regards,

Pooja

Best Regards,

Pooja

[Uncle Rob]

This looks like it might be a condition issue.  Do both lists display the exact same results?  Were they sorted the same way?

Please post a screenshot of the report conditions that generates the blank list.

[deloittepad8605]

Condition for both the report are same
When I added just one extra variable to the list, all the variables which are showing are also started showing blank.

Best Regards,

Pooja

[Deepak Shaerma]

hi @deloittepad8605 

Yes, there are known limitations and considerations when trying to show variables from RITM (sc_req_item) table in reports or list views

The variables you're referring to are item variables, which are stored in the sc_item_option_mtom and sc_item_option tables and not as direct fields on the RITM (sc_req_item) table.

When you add too many variables to a report or list view:

• You may hit a performance limit, especially if the query is doing a lot of joins or dot-walking.

• Variables may not show if the column limit for list views or reports is exceeded.

• Dot-walking to variables is inherently slower and limited.

Please Mark this Helpful and Accepted Solution. If this Helps you to understand. This will help both the community and me..
- Keep Learning ‌‌
Thanks & Regards 
Deepak Sharma 

[deloittepad8605]

Hi Deepak,

Thanks for your reply.

Any work around for this?

Best Regards,

Pooja