Your video is very helpful! Questions: Is it possible to make a dynamic filter based on first four number of a varchar field in a query or API? For example, if an varchar field's content was made with year-description, such as 2024-product, how do I filter anything produces in recent five years?
Hi Erik In this video, I didn't find any information about filtering a specific value at a specific location in a field value. For example: I need to select all Sales Hader in which the symbol "1" is in the third place in the "No." field. I think it will be useful for someone: SalesHeader.SetFilter("No.", '??1*');
Can you apply a filter for a calculated page field by using the MARK method? Would you set these filters OnOpenPage for the examples you showed so an action isn't needed? Or would it have to be OnAfterGetRecord?
Hi Erik Thanks for this session. I have a question regarding table filters. Can we modify standard filters in a table Ex: Table 1003 Job Planing Line No field TableRelation = IF (Type = CONST(Resource)) Resource ELSE IF (Type = CONST(Item)) Item WHERE(Blocked = CONST(false))..New filter ELSE IF (Type = CONST("G/L Account")) "G/L Account" ELSE IF (Type = CONST(Text)) "Standard Text";
Dear Eric, Is there any way to filter inside the filter pane? for example: when we put filter on some invoices, and navigate to the report to print the invoices, in the request page all invoices appears. So, is there any method to get only the filtered invoices other than the on lookup method, to avoid opening the page.
EH, what if I need to filter records based on more than one field and for more than one condition? E.g. If an employee applies for leave and I'd like to check who else is on leave within that date range - which involves a few periodicity checks to refine it. Cheers.
Hi Erik, New to AL coding. I am extending the customer card and adding "Global Dimension 2". I would like to filter the pulldown so that only a few items show. My code which does not work is as follows: field("Global Dimension 2 Code"; Rec."Global Dimension 2 Code") { ApplicationArea = all; TableRelation = "Dimension Value".Code where("Global Dimension No." = Const(2), Code = filter(0003 | 0005)); }
You can pass filters to a report in the Report.Run(....., Record) parameter, or you can create a procedure in the report that takes the filters, and the create the report as a variable.
Thanks Erik for your wonderful session...
Wow!
Love it... will have to watch again and again....
Your video is very helpful!
Questions:
Is it possible to make a dynamic filter based on first four number of a varchar field in a query or API?
For example, if an varchar field's content was made with year-description, such as 2024-product, how do I filter anything produces in recent five years?
2024*|2025*|2026*
Hi Erik
In this video, I didn't find any information about filtering a specific value at a specific location in a field value.
For example:
I need to select all Sales Hader in which the symbol "1" is in the third place in the "No." field.
I think it will be useful for someone:
SalesHeader.SetFilter("No.", '??1*');
Hi!
How can i filter inside page ui for two fields? For example on posted invoice do something like this: "Amount Including VAT" "Remaining Amount"
You cannot filter like that...
Can you apply a filter for a calculated page field by using the MARK method? Would you set these filters OnOpenPage for the examples you showed so an action isn't needed? Or would it have to be OnAfterGetRecord?
You would typically do that by calling page.run(id,RecWithFilers);
Hi Erik
Thanks for this session. I have a question regarding table filters.
Can we modify standard filters in a table
Ex: Table 1003 Job Planing Line
No field
TableRelation = IF (Type = CONST(Resource)) Resource
ELSE
IF (Type = CONST(Item)) Item WHERE(Blocked = CONST(false))..New filter
ELSE
IF (Type = CONST("G/L Account")) "G/L Account"
ELSE
IF (Type = CONST(Text)) "Standard Text";
Answer is coming in a future video, stay tuned to the channel ;)
Dear Eric,
Is there any way to filter inside the filter pane?
for example: when we put filter on some invoices, and navigate to the report to print the invoices, in the request page all invoices appears.
So, is there any method to get only the filtered invoices other than the on lookup method, to avoid opening the page.
Yes, you can pass a record variable with filters on to report.run
@@Hougaard thank you, it is working
Appreciate your support❤️❤️❤️
EH, what if I need to filter records based on more than one field and for more than one condition? E.g. If an employee applies for leave and I'd like to check who else is on leave within that date range - which involves a few periodicity checks to refine it. Cheers.
You can set one filter per field, you can create a combined filter on a single field (like 1|2|3 , or 1000...3000|5000..6000)
@@Hougaard Will give it a go, Cheers.
Erik why can't we filter on @(chair) it gives an error something to do with the parenthesis
What's the exact error you're getting?
Hi Erik,
New to AL coding. I am extending the customer card and adding "Global Dimension 2". I would like to filter the pulldown so that only a few items show. My code which does not work is as follows:
field("Global Dimension 2 Code"; Rec."Global Dimension 2 Code")
{
ApplicationArea = all;
TableRelation = "Dimension Value".Code where("Global Dimension No." = Const(2), Code = filter(0003 | 0005));
}
Are there spaces on each side of the | sign
@@Hougaard Good catch, I removed the spaced and it still does not work. Am I missing some additional properties?
19:56 What is the best way to pass those filters to a report? Awesome video!
You can pass filters to a report in the Report.Run(....., Record) parameter, or you can create a procedure in the report that takes the filters, and the create the report as a variable.
Great Video. Is it possible to filter by barcode?. I have the barcode for an item in ' Item References '
Relational filtering is not possible.
@@Hougaard Ok. Thanks. Your videos are helping a lot. Keep up the good work. You got a new follower here.
Nice. Thanks 👍
Make a video on Document Page
Teacher
Rec.Reset
Rec.Init
What is the difference
who use this and that
Reset clears filter, company, and fields... Init initialize all fields to the init value