Display Filters Values for all reports

Hi Gadi,

You can find this value in the reportformat table:

When this is set to "NO", this row is removed.

A good way to do this on a per-client basis would be to adjust the following query:

SELECT * FROM 735yellowfin20170608.reportformat
WHERE 
ReportId IN (SELECT ReportId FROM reportheader WHERE IpOrg=1) 
and FormatTypeCode='FILTERDISPLAY' 
and EntityCode='TITLE'

Is this what you are going for?

Regards,

Nathan

Hi Nathan, are you doing INSERT, UPDATE? There are also some reports that do not have any entries in that table because we precreated most of the reports.

This is the query we previously did but it screwed a bunch of reports which duplicated many of the filters.

insert into ReportFormat
(ReportId, EntityCode, EntityId, FormatTypeCode, FormatCode) 
select ReportID, 'TITLE', 0, 'FILTERDISPLAY', 'TOP' from ReportHeader
where ReportID not in (select ReportID from ReportFormat where FormatTypeCode = 'FILTERDISPLAY')
and ReportID in (select distinct ReportID from ReportFormat where ReportID > 0)

Hi Gadi,

Sorry for the delay here. A simple insert worked in my tests, but this was on a very simple report.

INSERT INTO 735yellowfin20170525.reportformat
VALUES (61827,'TITLE',0,'FILTERDISPLAY','TOP',0,null,0,0,0,null)

One thought in looking at the query, is that you may be inserting rows for append sub-queries as well which will have their own report id in the reportheader table. It might be worth adding a "WHERE parentreportid=0" to this query.

Can you describe the symptoms a bit more? Did all report experience duplication?

Regards,

Nathan

Hi Gadi,

Any luck in resolving this one? I am going to set this ticket to closed for now, but let me know if you would like to proceed with investigations here and it will be re-opened!

Nathan