RE: Extracting and parsing XML from fields (CRM related)

phual

SSChasing Mays

Points: 659

January 7, 2012 at 4:48 pm

#1430083

Isn't that what I've done in the second post?

I've presented a table consisting of two fields:

ConstraintBasedGroupId

Constraints

I've presented sample values for these two fields (i.e. one row of the source table):

ConstraintBasedGroupId = '065bbcce-eb01-e003-a59b-5550569a00af'

Constraints = '<Constraints>

<Constraint>

<Expression>

<Body>

resource["Id"] == {005b7cce-de01-e011-a55b-0050569d00bf} ||

resource["Id"] == {3dcbc1d6-a3e1-df11-a501-00188b8b43b5} ||

resource["Id"] == {3fcbc1d6-a3e1-df11-a501-00188b8b43b5} ||

resource["Id"] == {49cbc1d6-a3e1-df11-a501-00188b8b43b5} ||

resource["Id"] == {4ccbc1d6-a3e1-df11-a501-00188b8b43b5} ||

resource["Id"] == {4dcbc1d6-a3e1-df11-a501-00188b8b43b5} ||

resource["Id"] == {4ecbc1d6-a3e1-df11-a501-00188b8b43b5} ||

resource["Id"] == {4fcbc1d6-a3e1-df11-a501-00188b8b43b5} ||

resource["Id"] == {53cbc1d6-a3e1-df11-a501-00188b8b43b5} ||

resource["Id"] == {55cbc1d6-a3e1-df11-a501-00188b8b43b5} ||

resource["Id"] == {5acbc1d6-a3e1-df11-a501-00188b8b43b5} ||

resource["Id"] == {71cbc1d6-a3e1-df11-a501-00188b8b43b5}

</Body>

<Parameters><Parameter name="resource" />

</Parameters>

</Expression>

</Constraint>

</Constraints>'

And I've presented the output I'm trying to achieve for that single source row (a table containing multiple rows)

ConstraintBasedGroupId TeamId

'065bbcce-eb01-e003-a59b-5550569a00af' '005b7cce-de01-e011-a55b-0050569d00bf'

'065bbcce-eb01-e003-a59b-5550569a00af' '3dcbc1d6-a3e1-df11-a501-00188b8b43b5'

'065bbcce-eb01-e003-a59b-5550569a00af' '3fcbc1d6-a3e1-df11-a501-00188b8b43b5'

'065bbcce-eb01-e003-a59b-5550569a00af' '49cbc1d6-a3e1-df11-a501-00188b8b43b5'

'065bbcce-eb01-e003-a59b-5550569a00af' '4ccbc1d6-a3e1-df11-a501-00188b8b43b5'

'065bbcce-eb01-e003-a59b-5550569a00af' '4dcbc1d6-a3e1-df11-a501-00188b8b43b5'

'065bbcce-eb01-e003-a59b-5550569a00af' '4ecbc1d6-a3e1-df11-a501-00188b8b43b5'

'065bbcce-eb01-e003-a59b-5550569a00af' '4fcbc1d6-a3e1-df11-a501-00188b8b43b5'

'065bbcce-eb01-e003-a59b-5550569a00af' '53cbc1d6-a3e1-df11-a501-00188b8b43b5'

'065bbcce-eb01-e003-a59b-5550569a00af' '55cbc1d6-a3e1-df11-a501-00188b8b43b5'

'065bbcce-eb01-e003-a59b-5550569a00af' '5acbc1d6-a3e1-df11-a501-00188b8b43b5'

'065bbcce-eb01-e003-a59b-5550569a00af' '71cbc1d6-a3e1-df11-a501-00188b8b43b5'

Or am I missing something fundamental? :unsure:

Stuart