Interface IWindowSpec<TProps>
Window specification for Window Functions.
public interface IWindowSpec<TProps> where TProps : class, new()Methods
Frame(FrameSpec)
Sets Frame (ROWS BETWEEN) for sliding windows.
IWindowSpec<TProps> Frame(FrameSpec frame)OrderBy<TKey>(Expression<Func<TProps, TKey>>)
Sort within window by Props field (ascending).
IWindowSpec<TProps> OrderBy<TKey>(Expression<Func<TProps, TKey>> keySelector)OrderByDesc<TKey>(Expression<Func<TProps, TKey>>)
Sort within window by Props field (descending).
IWindowSpec<TProps> OrderByDesc<TKey>(Expression<Func<TProps, TKey>> keySelector)OrderByDescRedb<TKey>(Expression<Func<IRedbObject, TKey>>)
Sort within window by IRedbObject base field (descending).
IWindowSpec<TProps> OrderByDescRedb<TKey>(Expression<Func<IRedbObject, TKey>> keySelector)OrderByRedb<TKey>(Expression<Func<IRedbObject, TKey>>)
Sort within window by IRedbObject base field (ascending).
IWindowSpec<TProps> OrderByRedb<TKey>(Expression<Func<IRedbObject, TKey>> keySelector)PartitionBy<TKey>(Expression<Func<TProps, TKey>>)
Partition by Props field.
IWindowSpec<TProps> PartitionBy<TKey>(Expression<Func<TProps, TKey>> keySelector)PartitionByRedb<TKey>(Expression<Func<IRedbObject, TKey>>)
Partition by IRedbObject base field (SchemeId, OwnerId, etc.).
IWindowSpec<TProps> PartitionByRedb<TKey>(Expression<Func<IRedbObject, TKey>> keySelector)