Set init value from Install Codeunit in AL

tomasevicstefan

Does anyone know how to set init values to custom fields on standard table (existing records) throw install codeunit?

wynner0

tomasevicstefan wrote: »

@wynner0 Yes, I thought on that codeunit and these triggers, but I didn't want to hardcode init values.

Maybe something like this:

if field.value = 0 then field.init()

for existing records

Exactly. Or you can loop through all of them.

IF Item.FINDSET(TRUE,FALSE) THEN
   REPEAT
      IF Item."Some field" > x then
         Item."Your New Field" := y;
      else
         Item."Your New Field" := z;
   until Item.Next() = 0

Juhl

Like normal! ??

wynner0

I think you are looking for these triggers:

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-extension-install-code

Just modify all the records in the table by looping through or with MODIFYALL.

tomasevicstefan

@wynner0 Yes, I thought on that codeunit and these triggers, but I didn't want to hardcode init values.

Maybe something like this:

if field.value = 0 then field.init()

for existing records

wynner0

tomasevicstefan wrote: »

@wynner0 Yes, I thought on that codeunit and these triggers, but I didn't want to hardcode init values.

Maybe something like this:

if field.value = 0 then field.init()

for existing records

Exactly. Or you can loop through all of them.

IF Item.FINDSET(TRUE,FALSE) THEN
   REPEAT
      IF Item."Some field" > x then
         Item."Your New Field" := y;
      else
         Item."Your New Field" := z;
   until Item.Next() = 0