New Topic

Community Topic Question Report Builder

Category Report Builder

Product Version 7.4

SQLTEXT column is Null

Vikas Bhorhari shared this question 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.

The same question

Replies (5)

Mike Sheehan ●

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

Reply URL

Vikas Bhorhari ●

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

refer attachment.

Reply URL

Vikas Bhorhari ●

here is attachment

Files:

URL

Mike Sheehan ●

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

Reply URL

Mike Sheehan ●

Hi Vikas,

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

Regards,

Mike

Reply URL

Mike Sheehan ●

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

Reply URL