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 ;)

Thanks a lot Erik, even before watching, please make for us a video on partial records. Thanks!

Hey Eric, Top man, excellent channel, thanks for sharing your knowledge. Please can you do a video on partial records? Thanks,

@Hougaard

Жыл бұрын

Coming soon!

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

5 ай бұрын

From Customer Ledger Entries would probably be best.

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

Жыл бұрын

Nope

Hi @eric can we have any video related to performance tool kit extension or BCPT Suite

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

Жыл бұрын

You cannot do that, there's no query extension object..

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

9 ай бұрын

Don't believe so...

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

Жыл бұрын

You can set filters on the elements.

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)?

Hi eric, thanks for your video. could you tell me the name of the al dev tools?

@Hougaard

Жыл бұрын

That's the AZ AL Tools

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

Жыл бұрын

Embed the image bits in the src parameter

@navnav3134

Жыл бұрын

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

Жыл бұрын

@@navnav3134 no, you can embed base64 image in the src parameter

Right /left join doesn't have same behavior as t sql Does this have been fixed in latest version?

@mauriciovillatoro9361

Жыл бұрын

I am having the same issue.

@doffo748

10 ай бұрын

I have the same issue. LeftOuterJoin does not work. It keeps showing me only the records that are within my filter.

Hi Erik, Have you tried adding an extension column to a query at version 23? It's busted.

@Hougaard

8 ай бұрын

Busted how?

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

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

Ай бұрын

Why Linq? That has no place in the world of BC...

@ara3n

Ай бұрын

@@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

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!