Best Of

gymhood96 wrote: »

@JJMc So it's not a bug in VSCode? It's a bug in BC?

Yes, it is, It's a BC bug

this should be your correct event:
[EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnUpdateUnitPriceByFieldOnAfterFindPrice', '', false, false)]

Hello,

I have had a few Business Central clients report that they have checked their data Storage Capacity Usage in their admin center and discover that they are over capacity, which they had not anticipated.

There are data retention tools and procedures, which we have helped these clients with, but as far as I am aware, there is currently there is no automated notification of either growth or of exceeding capacity in BC or the admin center, nor any tools or reports to provide growth pace and trends, which they may extrapolate from. These would be very useful as they would allow customers to make better decisions regarding data retention policies for data they can remove as redundant and manage their license budget to buy more capacity for data they must retain.

I wanted to see if some did know of such tools or reporting.

I have searched the forum for previous posts on this but have not found anything. Apologies in advance if I have missed anything in my search.

Thank you

RecRef.Open(8700);
RecRef.SetLoadFields(2, 8);
RecRef.field(2).SetFilter('<>%1&<>%2&<>%3', 2000000184, 2000000183, 2000000185);
RecRef.field(8).SetFilter('>=%1', 240);
FldRef := RecRef.field(8);
if FldRef.CalcSum() then
  VariantValue := Round(FldRef.Value(), 0.01, '>') / 1000;
RecRef.Close();

Table Information is protected, so you need to use RecRef.
That calculates the used storage in megabytes.

So, you set the filter to be empty and then expect the filter to distinguish an empty string from any other value. Isn't that unreasonable?

If you want to filter for a distinct value, you should always use SETRANGE. SETRANGE automatically quotes the value for you (or does behind the scenes what proper quoting would do).

If you can't, or don't want to use SETRANGE, you should use replacement placeholders. In your case this would be

SETFILTER("Source Batch Name",'%1','')

. This is, however, tricky, as certain filter meta characters change the way values are folded into the filter string. In some cases, proper quoting applies, in other cases the same thing happens as if you used STRSUBST to create the filter string parameter, i.e.

SETFILTER(Field,STRSUBST('%1*','ABC'))

and in even other cases what looks like a placeholder is treated as literal value.

So, in essence, GETFILTER returns '' because you SETFILTER ''. If you want to GETFILTER '''''''' (i.e. the filter expression

''

), you need to set the filter accordingly.

Check out the documentation on setting filter strings (ignore the section on the quick filter, unless you want to analyze how the system mangles your input by looking at the Filters section on the "About this page" page; take into account that you need to double all single quotes that are part of the filter string and surround the whole string with single quotes, in order to use it as a literal string in C/AL Code) and my analysis of how SETFILTER's parameters are treated.

It's a bug in VSCode. Microsoft is working on fixing that