Disable autorun

Hi Yamini,

I suppose this setting is being overlapped by the already set value at the report level. it can be helpful for all new reports but not for the existing reports which are already there with this setting on.

Regards

Pratap

Hello Pratap,

Yes, you are absolutely right.

We investigated and found that with this setting on, it will only be useful for any brand-new reports; it won't help with any already-existing reports.

If you would like, we can raise an idea to the development team for this kind of issue.

Let me know your thought on this

Regards,

Yamini Naidu

Hi Yamini,

I understand that, but is there any quick alternative for this from the backend?

as i can see reportformat table have one setting formattypecode = 'WAITFORPROMPT'

maybe i am missing something , if possible can we check that option?

Regards

Pratap

Hello Pratap,

Allow me some time, let me investigate this more and get back to you with the findings.

Regards,

Yamini Naidu

Hi Yamini,
Any update?
Regards
Pratap

Hello Pratap,

Sorry for the delay in responding.

Hope you are doing well

This is to let you know that a task has been created for the product team so they can provide an update on your concern.

As soon as we receive a response from them, we'll let you know.

Regards,

Yamini Naidu

Hello Pratap,

Wish you a very Happy New Year

Thank you so much for your patience

Regarding your concern, we received a response from the wider team, and have shared us the below updates for your reference

This is a bit difficult because WAITFORPROMT = FALSE is implied by default, so there are no WAITFORPROMPT records (unless someone has turned it on or off)

The script below will add the WAITFROMPROMPT option for every report in the system (whether they have filters or not) if they don't already have a WAITFORPROMPT record.

INSERT INTO ReportFormat
SELECT ReportId, 'TITLE' AS EntityCode, 0 AS EntityId, 'WAITFORPROMPT' AS FormatTypeCode, 'TRUE' AS FormatCode, 0 as FormatValue , NULL AS Description, 0 AS FieldId, 0 AS ChartId , 0 AS SeriesId, null AS AxisCode
FROM ReportHeader
WHERE RoleCode = 'OPERATIONAL' AND ReportStatusCode = 'OPEN'
AND ReportId NOT IN (SELECT ReportId FROM ReportFormat WHERE FormatTypeCode = 'WAITFORPROMPT')

(This is PostgreSQL syntax and may require changes for other repository databases)

As always, I suggest that a backup of the Repository database be taken before running this query. Yellowfin should also be restarted to flush any caches that might hold the pre-query settings.

I believe this will be helpful for you, please let me know.

Regards,
Yamini Naidu

Hello Pratap,

Hope you are doing well.

I just want to touch base to see if you had chance to read through my response. If you can let me know that would be great. Thank you!

Regards,

Yamini Naidu

Hello Pratap,

I just want to touch base to see if all is well, if you can let me know that would be great. I look forward to your reply.

Thank you!

Kind Regards

Yamini

Hello Pratap,

Hope you are doing well.

As there is no revert back from you and because of age and inactivity I am going to go ahead and mark this ticket as closed for now. If you wish to re-open and discuss further I will be more than happy to do so.

Thanks!

Regards,

Yamini Naidu