Custom Attribute with select statement

here is a screenshot from IFS

@akrageb  

You are incorrectly assigning the variable part_no,

you should use :part_no (so do not forget the : sign)

Here is another example:

you can find more info here

Set Implementation Type (ifs.com)

@kvbe  many thanks for you reply.

You are right, I fixed this. The error is gone. Still however not getting my desired result.

The first issue is that instead getting the last 3 digits of part_no, I got the last 6 numbers (see the image below). I need to show only last 3 numbers whether they are digits or letters.

Please notice that the query was validated on the DB.

Furthermore, when the “Part_No” is a string or has letter IFS generates an error even though the cast is done using cast(). The error is below

{"error":{"code":"DATABASE_ERROR","message":"Database error occurred. Contact administrator.","details":[{"code":6502,"message":"ORA-06502: PL/SQL: numeric or value error: character to number conversion error"}]}}

@akrageb  make sure after you created your query that you delete the field and recreate it on the field. 

Als I would not do any casting in your query and make sure your custom field is a string. 

Hankx agian @kvbe 

In fact I could understand why I need to recreate the field again and why not casting?