Thanks a lot Erik, even before watching, please make for us a video on partial records. Thanks!
@arpadozsvar2129
2 жыл бұрын
Hej Erik, Thanks for your great videos which are sometimes also funny to watch. Thanks. Because you mentioned: pls make for us a video on partial records. Thanks!
@weinicht1953
2 жыл бұрын
Loving your videos and the amount of tabs in your browser. Feeling right at Home 😅 Thanks for your efforts, really helpful stuff! You just earned another sub ;)
@lmsf_data-ip9gg
Ай бұрын
This is a great intro video, but is there also a way to add functionality to a query object to return all data for all companies? Not just the context you are in at the moment? I've seen CHatGPT suggest the use of DataScope=AllCompanies, but would this be able to be used in a query?
@Hougaard
Ай бұрын
No.
@nickblackburn6543
2 жыл бұрын
Hey Eric, Top man, excellent channel, thanks for sharing your knowledge. Please can you do a video on partial records? Thanks,
@Hougaard
2 жыл бұрын
Coming soon!
@tarekdemiati9991
Ай бұрын
Great content as usual. I would have love to be able to use RecordRef and FieldRef inside a query, so I was wondering if it's possible to generate a query object in the fly as a text object and then execute it ?
@Hougaard
25 күн бұрын
No.
@prebenborg
2 жыл бұрын
Very interesting. I met my first query challenge this week. I need to extend “Calc. Warehouse adjustment” that’s build on a query. But now I need to extend the standard bc query with a reason code field. But is that even possible? Has MS burned a bridge here?
@Hougaard
2 жыл бұрын
You cannot do that, there's no query extension object..
@kf5ydu
9 ай бұрын
Hi Erik, As always your videos are incredible. I was wondering if there is a way to do something similar to a union in sql, where you can combine multiple similar datasets. An example would be a combined list of sales invoice and credit memo lines. I’m thinking the only way to do this might be some sort of conditional join on the item ledger based on the document number series if that is possible?
@Hougaard
9 ай бұрын
From Customer Ledger Entries would probably be best.
@plymouthfop
11 ай бұрын
In a Record you can use FilterGroup(-1) for an OR filter.. aka cross field filter. I need to do the same in a query.. how do I say filter (Field1 = true OR Field2 = true)?
@YRALPROGRAMMERWOMAN
2 жыл бұрын
Hello Erick One question is that I need to make a range in a query that only shows me a range of specific rows. For example, I need it to show me from 1 to 20,000 and from 20,000 to 4,000. The range must be with the rows. thank you very much for your help
@Hougaard
2 жыл бұрын
You can set filters on the elements.
@bunnyjsb
2 жыл бұрын
Hi @eric can we have any video related to performance tool kit extension or BCPT Suite
@jerrycic7866
Жыл бұрын
Thank You Sir! Is there a way to implement "Cross Apply"? for example I just want to retrieve the first row from a secondary table ordered by some date column. I am trying to convert all my stored procedures and SQL views to work similarly when we migrate to the BC 365 cloud from on prem Nav.
@Hougaard
Жыл бұрын
Don't believe so...
@brianhubbard251
11 ай бұрын
Hi Erik, Have you tried adding an extension column to a query at version 23? It's busted.
@Hougaard
11 ай бұрын
Busted how?
@sureshbhat6937
2 жыл бұрын
Hey Erik - Is there any way to see the resulting SQL statement for the above query, what I mean is SELECT SH FIELDS ... and so on anywhere in AL or any other place where it stores the SQL statement.
@Hougaard
2 жыл бұрын
Nope
@navnav3134
2 жыл бұрын
Dear Eric, Is there any method to get the company logo and add it to the email body? For example: when you make a video on send attachements by email, we need also to add company logo in the email body. Best Regards, Nav
@Hougaard
2 жыл бұрын
Embed the image bits in the src parameter
@navnav3134
2 жыл бұрын
Dear @@Hougaard As you know in business central, if we use embed src img file we need to put the path of the image which is saved on the server, but what if the user try to send the email from his own side. the picture will not appear since it is saved on the server. Any idea how to solve this issue? For email: I am using Email Item record. Best Regards, Nav
@Hougaard
2 жыл бұрын
@@navnav3134 no, you can embed base64 image in the src parameter
@nordniu2340
2 жыл бұрын
Hi eric, thanks for your video. could you tell me the name of the al dev tools?
@Hougaard
2 жыл бұрын
That's the AZ AL Tools
@dmichalopoulos4239
25 күн бұрын
Query object needs Work from microsoft , they blocked access to SQL and we cant even union or distinct and many other sql features when will microsoft update that object?!
@Hougaard
24 күн бұрын
What work are you missing?
@spidione1
2 жыл бұрын
Right /left join doesn't have same behavior as t sql Does this have been fixed in latest version?
@mauriciovillatoro9361
2 жыл бұрын
I am having the same issue.
@doffo748
Жыл бұрын
I have the same issue. LeftOuterJoin does not work. It keeps showing me only the records that are within my filter.
@umarnaeem6128
Жыл бұрын
can we do a not exist join ?
@Hougaard
Жыл бұрын
Here's your options: learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-sqljointype-property
@ara3n
4 ай бұрын
The query objects needs to be redesigned. It was built with designer for non developer. MS needs to redesign it to write Linq queries. The current syntax / structure is horrible.
@Hougaard
4 ай бұрын
Why Linq? That has no place in the world of BC...
@ara3n
4 ай бұрын
@@Hougaard I'm not sure what you mean. The goal linq and BC Query is to write a query. It's just one is easier/ faster to write than the other. For example var query = from header in salesHeaders join line in salesLines on header.OrderNo equals line.OrderNo select new { OrderNo = header.OrderNo, ItemNo = line.ItemNo, Quantity = line.Quantity }; It's 4 lines of code
Пікірлер