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?
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.
That makes sense Martin. Thx.
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.
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.
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
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,351
André Arnaud de Cal... 874 Super User 2025 Season 2
Sohaib Cheema 638 User Group Leader
