Help with retrieving the 'status' field in a formula

[abidoss]

Hello once again, please, can someone tell me where the issue is in this forum? I can't retrieve the "status" field even though it exists in the information.

$vacancesesIds = vacancesesIds;

if (array\length($vacancesesIds) > 0) {
    $premierId = array\at($vacancesesIds, 0);

    $informations = json\encode(record\fetch('Vacances', $premierId));
   output\printLine($informations);
  
    if (array\length($informations, "status")) {
        $status = array\get($informations, 'status');
        output\printLine("The status associated with the ID is: $status");
        
    } else {
        output\printLine("The 'status' field is not present in the information.");
    }
} else {
    output\printLine("The list of vacationIds is empty.");
}

​ 

[Firyo]

Hi,

I can't find the documentation about the "get" function inside the "array" category.
The "at" exists but not the "get" one.

Are you sure you are using the correct function to get the "status" field inside your "Information ?

https://docs.espocrm.com/administration/formula/array/#arrayat

Regards,
Firyo.

[rabii]

Not sure why you make it difficult using that code, i would do something like below:

$vacancesesIds = vacancesesIds;

if (array\length($vacancesesIds) > 0) {
    
    $vanceId = record\fetch('Vacances', array\at($vacancesesIds, 0));

    if ($vanceId) {
        $status = object\get($vanceId, 'status');
    }
  
    if ($status) {
        output\printLine("The status associated with the ID is: ");
        output\print($status);
    }
    else
    {
        output\printLine("The 'status' field is not present in the information.");
    }
}
else {
    output\printLine("The list of vacationIds is empty.");
}​ 

[espcrm]

Curious, what the point of this?

> $vacancesesIds = vacancesesIds;

[rabii]

Nothing just used it as he used it in the code. tbh it would be easier to just use vacancesesIds directly without assigning it to a variable.

[espcrm]

Cool, I thought it was some hidden trick when using formula.

Like you guys would just
if ($vanceId) whereas me I would probably do something like this? if ($vanceId=='true')

[abidoss]

Thank you, Rabiiii. You always remain an excellent teacher.