RefreshRecord, Options.FullRefresh BUT not all Fields?
Posted: Mon 05 Nov 2012 22:44
Hy, we have a very complex query. Its created in a way, the user can modify records. So after Post we need to RefreshRecord because of some Database Action.
The Problem:
We need to FullRefresh, because there are Functions in the Query that need to be refreshed.
BUT there are also Window-Funtions in the Query, e.g. (exakt content doesnt matter)
So refreshrecord kills our RowNumber, its clear: refreshRecord selects just one record, so the backend returns the result for 1 record.
Is there is a way to handle this? Can i explicit EXCLUDE fields from the RefreshRecord-Procedure on some way?
The Problem:
We need to FullRefresh, because there are Functions in the Query that need to be refreshed.
BUT there are also Window-Funtions in the Query, e.g. (exakt content doesnt matter)
Code: Select all
CAST(row_number() OVER(PARTITION BY date_to_yearmonth(date)=date_to_yearmonth(COALESCE(ldate, date)) ORDER BY COALESCE(ldate, date), field1, pos1) AS INTEGER) AS row_number,
Is there is a way to handle this? Can i explicit EXCLUDE fields from the RefreshRecord-Procedure on some way?