Marcin.B
DTDrizzle Team
•Created by Marcin.B on 1/8/2024 in #help
[Beginner] complex "where" clause
@francis Thx for the suggestion
38 replies
DTDrizzle Team
•Created by Marcin.B on 1/8/2024 in #help
[Beginner] complex "where" clause
@francis Actually the parsing is not the main problem for me. I'm familiar with recurection. My main concern is how to prepare proper where() method, rephrasing it in "plain sql", how to properly set "brackets" for nested and/or operators.
I think I follow @solo example, I have certain ideas....
38 replies
DTDrizzle Team
•Created by Marcin.B on 1/8/2024 in #help
[Beginner] complex "where" clause
Lucky for me "and"/"or" operators are not "array types"
38 replies
DTDrizzle Team
•Created by Marcin.B on 1/8/2024 in #help
[Beginner] complex "where" clause
I am the beginner (both typescript/drizzle), coming from Pascal/Delphi world, who apparently jumped into very deep water 😨
38 replies
DTDrizzle Team
•Created by Marcin.B on 1/8/2024 in #help
[Beginner] complex "where" clause
@Angelelz Could you at least propose how to deal with "and" and "or" operators in this scenario
38 replies
DTDrizzle Team
•Created by Marcin.B on 1/8/2024 in #help
[Beginner] complex "where" clause
datagrid comes from DevExpress DevExtreme package - https://js.devexpress.com/Angular/Documentation/Guide/UI_Components/DataGrid/Getting_Started_with_DataGrid/ and this is not an advertisment in any possible way 😉
38 replies
DTDrizzle Team
•Created by Marcin.B on 1/8/2024 in #help
[Beginner] complex "where" clause
And @Angelelz what is the right price?
38 replies
DTDrizzle Team
•Created by Marcin.B on 1/8/2024 in #help
[Beginner] complex "where" clause
I have made first attempts. Recursion is the only way since arrays can be nested. Conversion to plain sql could be much easier, at least for me 😉 , since we can easily convert schema field names to database names , but I'm really curious how it could be in "drizzle" way.
38 replies
DTDrizzle Team
•Created by Marcin.B on 1/8/2024 in #help
[Beginner] complex "where" clause
Thanks, @solo , for the tip. How would start with the conversion, not knowing what will come in the criteria? As I wrote, user can specify any criteria using any fields that are in the query.
38 replies
DTDrizzle Team
•Created by Marcin.B on 1/8/2024 in #help
[Beginner] complex "where" clause
Unfortunately it comes from commercial datagrid component, so apparently I have to parse it. But I'm more concerned about drizzle side, all possible "and"s and "or"s mixed together...
38 replies