Feature request: Post Filter in Query Editor

[njerigrevious]

Similar requests

• I have searched and found no existing similar requests

How are you using Studio?

Legend Query

What problems are you trying to solve?

Many users have requested the ability to perform a post-filter rather than a regular filter in Query. Post filters allow you to perform filter operations on the Tabular Data Structure TDS structure returned by the project function.

Describe the solution you would like to see implemented

• Add TDSRow class to graph
• Add value specification processing of filter on projection
• Add query builder processing on filter on projection
• Add lambda builder processing on filter on projection
• FORM MODE
  • add post filter panel
  • add support for hiding/showing panel. default should hide
  • DND for projection columns
    • disable for graph fetch
    • auto generate filter lambda based on column
    • handle derivation columns (should use engine return type api to generate correct post filter lambda)
    • enable group filter just like in regular filter

Sample Query to Support

|model::Person.all()->project(
  [
    x|$x.firstName,
    x|$x.lastName
  ],
  [
    'First Name',
    'Last Name'
  ]
)->filter(
  row|$row.getString('First Name') == 'John'
)

[akphi]

@njerigrevious the correct label to use for this is Component: Query Builder, not Application: Query since this refers to the shared part that even Studio can use. Please note that next time. Thanks!!