Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

New filter to reduce a result-set by selecting first/last rows #363

Closed
7 tasks done
Seddryck opened this issue Apr 9, 2018 · 1 comment
Closed
7 tasks done

New filter to reduce a result-set by selecting first/last rows #363

Seddryck opened this issue Apr 9, 2018 · 1 comment
Labels
beta-available feature-request
Milestone
v1.19

Comments

@Seddryck
Copy link
Owner

Seddryck commented Apr 9, 2018 •
edited
Loading

The idea is to be able to reduce the filter to only select a subset of the returned rows. The subset of selected rows is based on a top/bottom approach, the operand in the predicate specifies how to order the case.

The following example will return the 5 rows where the timestamp is the maximum

<filter>
  <ranking operand="timestamp" type="dateTime">
    <top count="5"/>
  </ranking>
</filter>

In the following example we'll consider data by groups. groups will be created for each distinct value of columns 1 and 3.

<filter>
  <ranking operand="value">
    <top/>
     <group-by>
          <column index="1"/>
          <column index="3"/>
     </group-by>
  </ranking>
</filter>
  • Top and Bottom filters
  • Handle different column-types
  • Specify "count"
  • Support of aliases & expressions
  • Support of group-by
  • Combine first/bottom and group-by
  • Manage Xml and builders
@Seddryck Seddryck added this to the v1.19 milestone Apr 9, 2018
Seddryck pushed a commit that referenced this issue May 25, 2018
Merge branch 'feature/Filtering_of_first_or_last_rows_of_a_result-set_(…
29c24c6 
…#363)' into develop

# Conflicts:
#	NBi.Core/NBi.Core.csproj
#	NBi.Testing/NBi.Testing.csproj
#	NBi.Testing/Unit/NUnit/Builder/MembersContainsBuilderTest.cs
#	NBi.Testing/Unit/NUnit/Builder/StructureContainBuilderTest.cs
#	NBi.Testing/Unit/Xml/Constraints/AllRowsXmlTest.cs
#	NBi.Xml/SerializationOption/ReadOnlyAttributes.cs
@Seddryck
Copy link
Owner Author

Beta available at https://ci.appveyor.com/project/Seddryck/nbi/build/1.19.0-beta.22.build.410/artifacts

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
beta-available feature-request
Projects
None yet
Milestone
v1.19
Development

No branches or pull requests
1 participant
@Seddryck