SETRANGE: Both values included. With SETFILTER it is possible to exclude the limits. My favorite SETFILTER: SETFILTER("Ending date", '%1|%2..', 0d, WORKDATE);
Dear Eric, How can we put the filter inside the filter pane?. for example onopen page put true inside filter pane for a boolean record, like saved view. Best Regards, NAV
@@Hougaard this will put the filter as background and we can not remove it. Anyway, I fix it by using the filtered record inside (settable view) function. Thanks for your reply dear. Nav
Can it be imaginable to substitute setrange and setfilter in the future? Wouldn't it be easier to have something like the where clauses in sql? This would avoid having x lines with setfilter and setrange.
YOU FORGOT TO TELL THEM THAT SetRange ALSO IS MORE PERFORMANT THAN THE OTHER OPTIONS! But your points of using the power of type checking is of course correct.
So, are you, once and for all, as the product group official representitive here on UA-cam , stating that: The SQL SELECT statement created from SetRange is performing better than the SQL SELECT statement created from SetFilter?
@@Hougaard I am in no way in the authority to represent the product group. And I really hope we don't end up creating different SQL statements. But the runtime cost is cheaper since you don't have to parse the input text, does it matter in most cases? No, but let's find all arguments to steer people towards SetRange.
But if it only the parsing cost we're talking about, then that's less than the deviation of the latency of the subsequently SQL operation. The reason I didn't mention this in the video, is that there has been soo many urban legends surrounding this, going all the way back to Peter Bang.... Someone have talking with someone saying that setfilter is .... than setrange.
Great video, this one threw me a bit when I was leaning CAL. Would be good to do one showing when to use Reset or Clear.
Nice and great video on the impact of type checking in the longer run.
Thanks Erik. Still the best Pascal channel on yt....
Totally gonna quote you on that :)
@@Hougaardby far the best BC AL Channel.
Great video with good explanation! Finally I get the difference and will use it for building an app.
SETRANGE: Both values included. With SETFILTER it is possible to exclude the limits.
My favorite SETFILTER:
SETFILTER("Ending date", '%1|%2..', 0d, WORKDATE);
Hats Off Errik sir,
I am new in this field and i wanted to be like you;
Ive never come across AL programming before, seems very interesting !! Nice video :D
Glad you liked it!
Dear Eric,
How can we put the filter inside the filter pane?. for example onopen page put true inside filter pane for a boolean record, like saved view.
Best Regards,
NAV
That's just by adding a filter to record you're passing to page.run()
@@Hougaard this will put the filter as background and we can not remove it.
Anyway, I fix it by using the filtered record inside (settable view) function.
Thanks for your reply dear.
Nav
Can someone tell please, how can we check for duplicate records in a tabls having multiple primary keys and throw error?
Hi Erik, is there any difference between do GL.SetRange("Posting Date", D, D2 ) or do GL.SetRange(GL."Posting Date", D, D2)?
Thanks.
No, but the first is nicer to read.
@@Hougaard Thanks.
What about applying multiple filters? How is that achieved?
To the same field? With filter groups
@@Hougaard thank you, I was thinking of filtering the record on multiple fields, can you do that with set range?
Hi Erik Nice Video,
How do you Groups Records, like the "Group by" clause in SQL?
Only with the tree control, there's a video about that :)
@@Hougaard Yes, I saw that video. Thanks.
Can it be imaginable to substitute setrange and setfilter in the future? Wouldn't it be easier to have something like the where clauses in sql? This would avoid having x lines with setfilter and setrange.
Several tables in BC are not SQL (virtual, temporary, CRM, CDS) so a common filter language still seems like a good idea.
@@Hougaard HI, do you think SQL queries instead AL, support could be possible 🤔 in the future for BC?
Never say never :)
YOU FORGOT TO TELL THEM THAT SetRange ALSO IS MORE PERFORMANT THAN THE OTHER OPTIONS!
But your points of using the power of type checking is of course correct.
So, are you, once and for all, as the product group official representitive here on UA-cam , stating that:
The SQL SELECT statement created from SetRange is performing better than the SQL SELECT statement created from SetFilter?
@@Hougaard I am in no way in the authority to represent the product group.
And I really hope we don't end up creating different SQL statements. But the runtime cost is cheaper since you don't have to parse the input text, does it matter in most cases? No, but let's find all arguments to steer people towards SetRange.
But if it only the parsing cost we're talking about, then that's less than the deviation of the latency of the subsequently SQL operation.
The reason I didn't mention this in the video, is that there has been soo many urban legends surrounding this, going all the way back to Peter Bang.... Someone have talking with someone saying that setfilter is .... than setrange.
@@phduck I will buy the theoretical performance gain as my side argument in "why setrange is better!" :D
There is no difference in performance. SQL statements are identical.