Discoverer SQL doesnt get updated with recent changes
484215Dec 17 2007 — edited Jan 27 2011I am sure we all have faced this issue in the past.
Say, we have 3 tables joined together and I have picked one column from each of the tables in my report. Sometimes when I remove column from table A, it doesnt remove the join in the SQL. I mean SQL still shows the join and column in the select clause.
I have very complex logic and huge query, sometimes I have situations when I insert a new table with new join and I cant remove the dependency from this table even If I remove all the conditionsm columns or parameters from this table.
Is there any back door to this. I went eul5_worksheet_sql to edit the query. Didnt help.
Thanks In advance.