Announcements
No record found.
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?
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
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.
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.
That makes sense Martin. Thx.
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 617
André Arnaud de Cal... 461 Super User 2026 Season 1
Syed Haris Shah 298 Super User 2026 Season 1
