mibuso.com
Home› NAV Three Tier
Options

User Metadata."Page Metadata Delta"

jwilderjwilder Member Posts: 263
in NAV Three Tier
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>
Jason Wilder
jwilder@stonewallkitchen.com

Answers

  • Options
    SilverXSilverX Member Posts: 134
    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.
    Cheers
    Carsten


    ==> How To Ask Questions The Smart Way
    This post is my own opinion and does not necessarily reflect the opinion or view of my employer.
  • Options
    jwilderjwilder Member Posts: 263
    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:
    1w8istnfvef9.jpg
    Jason Wilder
    jwilder@stonewallkitchen.com
Sign In or Register to comment.