User Metadata."Page Metadata Delta"

jwilder

There is a blob field in the User Metadata table called "Page Metadata Delta" that is a blob datatype. Most user personalization (moving columns, hide/show etc...) is stored in here as xml. I was wondering if anyone new how to map the guid's ({47F878F7-1EB4-4B40-A6D5-55E87F26029B} for example) to the actual controls/fields that are being referenced? Here is a sample of the xml for some personalization I did on page 20 General Ledger Entries:

<?xml version="1.0"?>
<delta xmlns:xsd="http://www.w3.org/2001/XMLSchema&quot; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&gt;
<changes>
<order id="{17F878F7-1EB4-4B40-A6D5-55E87F26029B}" sequence="{47F878F7-1EB4-4B40-A6D5-55E87F26029B}; {00000014-0000-0039-0008-0000836BD2D2}; {00000014-0000-0030-0008-0000836BD2D2}; 205eb6cb-6b7a-4f2d-b2e5-748d3b3bca7f; {87F878F7-1EB4-4B40-A6D5-55E87F26029B}; {97F878F7-1EB4-4B40-A6D5-55E87F26029B}; {CDBA910D-E283-4A38-AD03-C9D42763C3CE}; {27F878F7-1EB4-4B40-A6D5-55E87F26029B}; {37F878F7-1EB4-4B40-A6D5-55E87F26029B}; {57F878F7-1EB4-4B40-A6D5-55E87F26029B}; {67F878F7-1EB4-4B40-A6D5-55E87F26029B}; {77F878F7-0003-4B40-A6D5-55E87F26029B}; {77F878F7-0004-4B40-A6D5-55E87F26029B}; {77F878F7-0005-4B40-A6D5-55E87F26029B}; {77F878F7-0006-4B40-A6D5-55E87F26029B}; {77F878F7-0007-4B40-A6D5-55E87F26029B}; {77F878F7-0008-4B40-A6D5-55E87F26029B}; {77F878F7-0009-4B40-A6D5-55E87F26029B}" />
<order id="{97F878F7-1EB4-4B40-A6D5-55E87F26029B}" sequence="{3964E29E-BD34-4f2b-B7E5-3B3749ED8B92}; {EA0CB2A3-D17D-4148-BAC7-5D76DDA797F3}; {8AF9CED3-EAE5-4735-88A4-B2E24CF29384}" />
<order id="{dcaf515a-205a-4113-b2e4-37ecffeb7ee1}" sequence="{00000014-0000-0018-0008-0000836BD2D2}; {00000014-0000-000B-0008-0000836BD2D2}; {a4a26640-eb10-41aa-894d-ce8778650cde}; {bbc4c78a-4e7b-45eb-a018-42c1f3788c84}; {7CD09CCE-5C58-409e-A79B-05ED9416E806}; {1AF878F7-1EB4-4B40-A6D5-55E87F26029B}" />
<update id="d2371308-c54a-4221-a23a-a5ba38313c6e" uri="" name="Caption" value="" />
<update id="{8AF9CED3-EAE5-4735-88A4-B2E24CF29384}" uri="" name="Visible" value="False" />
<update id="{27F878F7-1EB4-4B40-A6D5-55E87F26029B}" uri="" name="Visible" value="False" />
<update id="{57F878F7-1EB4-4B40-A6D5-55E87F26029B}" uri="" name="Visible" value="False" />
<update id="{67F878F7-1EB4-4B40-A6D5-55E87F26029B}" uri="" name="Visible" value="False" />
<update id="{77F878F7-0003-4B40-A6D5-55E87F26029B}" uri="" name="Visible" value="False" />
<update id="{77F878F7-0004-4B40-A6D5-55E87F26029B}" uri="" name="Visible" value="False" />
<update id="{77F878F7-0005-4B40-A6D5-55E87F26029B}" uri="" name="Visible" value="False" />
<update id="{77F878F7-0006-4B40-A6D5-55E87F26029B}" uri="" name="Visible" value="False" />
<update id="{77F878F7-0007-4B40-A6D5-55E87F26029B}" uri="" name="Visible" value="False" />
<update id="{77F878F7-0008-4B40-A6D5-55E87F26029B}" uri="" name="Visible" value="False" />
<update id="{77F878F7-0009-4B40-A6D5-55E87F26029B}" uri="" name="Visible" value="False" />
<update id="{a4a26640-eb10-41aa-894d-ce8778650cde}" uri="" name="Caption" value="General Ledger Entries" />
<update id="{9e511277-3955-4b4c-8ebd-e34570808bf7}" uri="" name="Visible" value="False" />
<update id="{0ccf4a6a-de68-44e2-812f-928774f5ba1e}" uri="" name="Visible" value="False" />
<update id="{00000014-0000-0001-0008-0000836BD2D2}" uri="" name="FreezeColumnID" value="-1" />
<update id="{00000014-7198-B453-0008-0000836BD2D2}" uri="" name="Visible" value="1" />
</changes>
</delta>

SilverX

These guids are referencing entries in Object Metadata (field Metadata) with the same guids. From there you should be able to identify the fields they refer to.

jwilder

The object metadata does get this a little further but still not enough. The object metadata will reference the guid above but does not give the column name, instead it will say DataColumnName=1 or DataColumnName=2 etc... Here is an example:
<Controls xsi:type="ControlDefinition" ID="2" ControlGUID="{77F878F7-0004-4B40-A6D5-55E87F26029B}" DataColumnName="1"/>

There would need to be some other table that shows the control information. For example the "ControlDefinition" ID="2" is the actual control with ID 2 for Page 4 (Code field). But I do not know of a table that lists control information. This is the final missing piece. Here is a screen shot from object designer that I need to find the actual table for: