How to read a cotainer field in a view

[Peter]

Hi.

(Ax 4.0, sql2005)
I have a view showing informations about my projects:

select Projid, Name from Projtable

I would like to show the date(s) where the project status was changed
between 3 to 4.

I have set up a databaselog where these informations are kept. My challenge
is, that the ínformation I am seeking is in a field called Data. This field
is a container type, and I am not able to show the content in a read-able way.

I know that there is a C## funciton called something like Con2Str. But my
views are bulid in Tsql.

Can anyone advice me ?

--
Med venlig hilsen / Regards

Peter

[SysProg]

Hi Peter,

If I understand correctly, you want to be able to use a select statement to
look at data stored in an ax container.

You will have to read the data into a field on a table using x++ first.

Something like:

for(i=0; i <= conlen(mycontainer); i++)
{
mycreatedField = conpeek(mycontainer, i);
}

Then you can use a select statement in SQL because the data will be stored
in a field you created.

I hope this helps a little.

Regards.