Table with container field

(0) Share

Report

Posted on by Community Member

In F&O, you can have table field with "container" data type. For this type of field, how do we present the actual data when the entity contain this table pushed to BYOD and user try to query the value using SQL statement?

All responses (5)

Answers (1)

Suggested answer

nmaenpaa 101,158 Moderator on at

Like (0)

Report

RE: Table with container field

If the container is something that's encoded by the AOS, then yes, you must also decode it on the AOS. You can then export the decoded result via your data entity. The details depend on the details of your container contents.
Community Member on at

Like (0)

Report

RE: Table with container field

That makes sense Martin. Thx.
Community Member on at

Like (0)

Report

RE: Table with container field

So the only way to decode the hex value created from container field is to through X++? That's doesn't seem very practical, giving that some external system can only access to the F&O database through BYOD.
Verified answer

Martin Dráb 234,712 Most Valuable Professional on at

Like (0)

Report

RE: Table with container field

Since it can contain absolutely anything (e.g. a DLL file), there is no universal way how to present the data. It depends on the content.

Also, BOYD is based on data entites. You should first ask yourself how you want to convert the container table field to an entity field that will be useful in BYOD, and whether it makes sense at all.
WillWU 22,357 on at

Like (0)

Report

RE: Table with container field

Hi Yvonne Huang,

In X++, container is one of the primitive (value) types. A container can contain an ordered sequence of primitive values or other containers.Containers can be said to be similar to an arary or List/stack classes.

The container in database is stored in hexadecimal format. You can't use SQL statement to query the value in your database.

You could use conpeek() method in X++ to return the value you want.

docs.microsoft.com/.../containers