SQLTEXT column is Null

vikas shared this question 8 months ago
Answered

Report having 10 columns-7 Dimension and 3 Calculated columns.

When I running mention query in YF DBselect * from reportinstance order by ReportInstanceId desc

SQLTEXT column is null and documentID column =0

NOTE: For others reports SQLText column is not null and these reports also using calculated columns.

Please let me know the why sqlText column is null.

Comments (6)

photo
1

Hi Vikas,

Thanks for reaching out.

A null SQLText column indicates that what you're looking at for this particular report is actually a Bookmarked report.

You can confirm this by looking at the ReportStatusCode for the corresponding report:

/+ep+LeMmaAQQQAABBBBAAAEERiXwP9egwbhtqtB1AAAAAElFTkSuQmCC

Or in the UI, you can see saved bookmarks for the corresponding report by clicking the bookmark icon on the left side nav bar when heading into the report:

/A5TSAITr8l9cAAAAAElFTkSuQmCC

I made a new bookmark and confirm it was added in the way described above:

/w8cWAwgkzIhVgAAAABJRU5ErkJggg==

Regards,

Mike

photo
1

I can see in DB, ReportStatusCode= OPEN and InstanceName =null

refer attachment.

photo
1

here is attachment

photo
photo
1

Hi Vikas,

What behavior is this affecting in the application? Is there something wrong with the functionality of the report? What's actually contained in this report?

Regards,

Mike

photo
1

Hi Vikas,

I just wanted to check in and see how things are going with this.

Regards,

Mike

photo
1

Hi Vikas,

I'm going to go ahead and mark this one as Answered since I haven't heard back from you, but if you have further questions or concerns on this, if you respond, it will re-open the case and put it back in my queue and I'll be happy to help.

Regards,

Mike