Yifan Wang
Rank: #6977
16Views
2Comments
Dynamic sql - unfixed number of WHERE clauses and ORDER BY clauses
Question
SQL

Hi,


I'm working on a query builder rn, which allows user to add unlimited number of filters and column sorts. The closest widget I can find is https://www.outsystems.com/forge/component-overview/365/advanced-filter-builder although this looks very powerful, it is a bit too old and our project is quite demanding on ui design. Is there any general idea of how I should approach this problem? Thanks!


Best

0
0
on 2020-10-16
Copy link to comment
Daniël Kuhlmann
mvp_badge
MVP
Rank: #17

Hi Yifan,

If the functionality of that Forge component is covering your requirements then what you could do is clone it and update the UI part of it.

Regards,

Daniel

1
0
on 2020-10-16
Copy link to comment
Yifan Wang
Rank: #6977

Daniël Kuhlmann wrote:

Hi Yifan,

If the functionality of that Forge component is covering your requirements then what you could do is clone it and update the UI part of it.

Regards,

Daniel

 Yeah that's a good idea! I am looking at it's design. Thanks!

 

0
0
on 2020-10-16
Copy link to comment