Webdesigner: Build Collections from XMLObjects

Hi there,

i try to (re)build a collection from an XML-Object (e.g. select GetXMLObject() from User) that i've created in the Webdesigner.

Is It possible to load or fill a collection from it?

For Example: This data is in my OrderDetail1 of the PWO and I will show an approver the content in a popup.

<DbObject Display="Lastname, Firstname" Version="1" DbVersion="002.013.0004.0001.002"><Key><Table Name="Person" Display="Schröder, Gerhard"><Prop Name="CentralAccount" Value="FIRSTNAMEL" /></Table></Key><Columns><Column Name="ApprovalState" Display="Zertifizierungsstatus"><Value>0</Value></Column><Column Name="BirthDate" Display="Geburtsdatum"><Value>1965-11-22 00:00:00</Value></Column><Column Name="Building" Display="Gebäude"><Value /></Column><Column Name="CanonicalName" Display="Kanonischer Name"><Value /></Column><Column Name="CentralAccount" Display="Zentrales Benutzerkonto"><Value>GERHARDS</Value></Column><Column Name="CentralEBSAccount" Display="EBS Benutzerkonto"><Value>FIRSTNAMES</Value></Column><Column Name="CentralPassword" Display="Zentrales Kennwort"><Value /></Column><Column Name="CentralSAPAccount" Display="Zentrales SAP Benutzerkonto"><Value>SCHROEDG</Value></Column><Column Name="City" Display="Ort"><Value /></Column><Column Name="CompanyMember" Display="Firmenmitglied"><Value /></Column><Column Name="CustomProperty01" Display="Freies Feld Nr. 01"><Value /></Column><Column Name="CustomProperty02" Display="Freies Feld Nr. 02"><Value /></Column><Column Name="CustomProperty03" Display="Freies Feld Nr. 03"><Value /></Column><Column Name="CustomProperty04" Display="Freies Feld Nr. 04"><Value /></Column><Column Name="CustomProperty05" Display="Freies Feld Nr. 05"><Value /></Column><Column Name="CustomProperty06" Display="Freies Feld Nr. 06"><Value /></Column><Column Name="CustomProperty07" Display="Freies Feld Nr. 07"><Value /></Column><Column Name="CustomProperty08" Display="Freies Feld Nr. 08"><Value /></Column><Column Name="CustomProperty09" Display="Freies Feld Nr. 09"><Value /></Column><Column Name="CustomProperty10" Display="Freies Feld Nr. 10"><Value /></Column><Column Name="DateLastWorked" Display="Letzter Arbeitstag"><Value /></Column><Column Name="DeactivationEnd" Display="Zeitweilig deaktiviert bis"><Value /></Column><Column Name="DeactivationStart" Display="Zeitweilig deaktiviert ab"><Value /></Column><Column Name="DefaultEmailAddress" Display="Standard-E-Mail-Adresse"><Value /></Column><Column Name="Description" Display="Beschreibung"><Value /></Column><Column Name="DialogUser" Display="Systembenutzer"><Value /></Column><Column Name="DialogUserPassword" Display="Kennwort"><Value /></Column><Column Name="DialogUserSalt" Display="Zufallswert für das Kennwort"><Value /></Column><Column Name="DisplayTelephoneBook" Display="Aufnahme in das Telefonbuch"><Value>False</Value></Column><Column Name="DistinguishedName" Display="Definierter Name"><Value /></Column><Column Name="EntryDate" Display="Eintrittsdatum"><Value>2014-11-10 00:00:00</Value></Column><Column Name="ExitDate" Display="Austrittsdatum"><Value /></Column><Column Name="Fax" Display="Fax"><Value /></Column><Column Name="FirstName" Display="Vorname"><Value>Gerhard</Value></Column><Column Name="Floor" Display="Etage"><Value /></Column><Column Name="FormerName" Display="Geburtsname"><Value /></Column><Column Name="Gender" Display="Geschlecht"><Value>1</Value></Column><Column Name="GenerationalQualifier" Display="Generationskennzeichen"><Value /></Column><Column Name="IdentityNumber" Display="Dienstausweisnummer"><Value /></Column><Column Name="Ident_DialogCulture" Display="Sprachkultur"><Value /></Column><Column Name="ImportSource" Display="Datenquelle Import"><Value /></Column><Column Name="Initials" Display="Initialen"><Value>GS</Value></Column><Column Name="InternalName" Display="Vollständiger Name"><Value>Lastname, Firstname</Value></Column><Column Name="IsCar" Display="Firmenwagen"><Value>False</Value></Column><Column Name="IsDummyPerson" Display="Dummy-Person"><Value>False</Value></Column><Column Name="IsDuplicateName" Display="Doppelt vorhanden"><Value>False</Value></Column><Column Name="IsExternal" Display="Extern"><Value>False</Value></Column><Column Name="IsInActive" Display="Dauerhaft deaktiviert"><Value>False</Value></Column><Column Name="IsMasterIdentity" Display="Hauptidentität"><Value>False</Value></Column><Column Name="IsNoInherite" Display="Keine Vererbung"><Value>False</Value></Column><Column Name="IsNoteBookUser" Display="Notebook Benutzer"><Value>False</Value></Column><Column Name="IsRemoteAccessAllowed" Display="Remote-Zugriff erlaubt"><Value>False</Value></Column><Column Name="IsSecurityIncident" Display="Sicherheitsgefährdend"><Value>False</Value></Column><Column Name="IsSupporter" Display="Helpdesk-Mitarbeiter"><Value>False</Value></Column><Column Name="IsSupporterGroup" Display="Bearbeitergruppe"><Value>False</Value></Column><Column Name="IsTemporaryDeactivated" Display="Zeitweilig deaktiviert"><Value>False</Value></Column><Column Name="IsTerminalServerAllowed" Display="Anmeldung am Terminalserver erlaubt"><Value>False</Value></Column><Column Name="IsVIP" Display="VIP"><Value>False</Value></Column><Column Name="IsX500Dummy" Display="X500-Dummy"><Value>False</Value></Column><Column Name="JPegPhoto" Display="Bild"><Value /></Column><Column Name="LastName" Display="Nachname"><Value>Lastname</Value></Column><Column Name="MiddleName" Display="Zweiter Vorname"><Value /></Column><Column Name="NameAddOn" Display="Namenszusatz"><Value /></Column><Column Name="PasswordAnswer" Display="Antwort für zentrales Kennwort"><Value /></Column><Column Name="PasswordQuery" Display="Frage für zentrales Kennwort"><Value /></Column><Column Name="PersonalTitle" Display="Berufsbezeichnung"><Value /></Column><Column Name="PersonnelNumber" Display="Personalnummer"><Value /></Column><Column Name="Phone" Display="Telefon"><Value /></Column><Column Name="PhoneMobile" Display="Mobiltelefon"><Value /></Column><Column Name="PostalOfficeBox" Display="Bürobriefkasten"><Value /></Column><Column Name="PreferredName" Display="Bevorzugter Name"><Value /></Column><Column Name="Remarks" Display="Bemerkungen"><Value /></Column><Column Name="RiskIndexCalculated" Display="Risikoindex (berechnet)"><Value>0</Value></Column><Column Name="Room" Display="Raum"><Value /></Column><Column Name="Salutation" Display="Anrede"><Value>Mr</Value></Column><Column Name="SecurityIdent" Display="Sicherheitsmerkmal"><Value /></Column><Column Name="Sponsor" Display="Sponsor"><Value /></Column><Column Name="Street" Display="Straße"><Value /></Column><Column Name="SubCompany" Display="Unterorganisation"><Value /></Column><Column Name="Title" Display="Titel"><Value /></Column><Column Name="UID_Department" Display="Primäre Abteilung"><Key><Table Name="Department" Display="Managed Datacenter"><Prop Name="FullPath" Value="Portfolio\Manage &amp; Transform\Managed Datacenter" /></Table></Key></Column><Column Name="UID_DialogCountry" Display="Land"><Value /></Column><Column Name="UID_DialogState" Display="Bundesland"><Value /></Column><Column Name="UID_FirmPartner" Display="Firma"><Value /></Column><Column Name="UID_Locality" Display="Primärer Standort"><Value /></Column><Column Name="UID_Org" Display="Primäre Geschäftsrolle"><Value /></Column><Column Name="UID_PersonDeputy" Display="1. Stellvertreter"><Value /></Column><Column Name="UID_PersonDeputyITShop" Display="Stellvertreter IT Shop"><Value /></Column><Column Name="UID_PersonDeputySecond" Display="2. Stellvertreter"><Value /></Column><Column Name="UID_PersonHead" Display="Manager"><Value /></Column><Column Name="UID_PersonMasterIdentity" Display="Hauptidentität"><Value /></Column><Column Name="UID_ProfitCenter" Display="Primäre Kostenstelle"><Value /></Column><Column Name="UID_RealPerson" Display="Wirkliche Person"><Value /></Column><Column Name="UID_X500Person" Display="X500-Person"><Value /></Column><Column Name="UserIDTSO" Display="Benutzerkontoname (Mainframe)"><Value /></Column><Column Name="UsidSecond" Display="Helpdesk Bearbeitergruppe"><Value /></Column><Column Name="VI_Consistent" Display="Konsistenzschalter"><Value /></Column><Column Name="XDateInserted" Display="Angelegt am"><Value /></Column><Column Name="XDateUpdated" Display="Geändert am"><Value /></Column><Column Name="XObjectKey" Display="Objektschlüssel"><Value /></Column><Column Name="XTouched" Display="Bearbeitungsstatus"><Value /></Column><Column Name="XUserInserted" Display="Angelegt von"><Value /></Column><Column Name="XUserUpdated" Display="Geändert von"><Value /></Column><Column Name="ZIPCode" Display="Postleitzahl"><Value /></Column></Columns></DbObject>

I tried GetfromXML(select OrderDetail1 from Personwantsorg) but this does not work for XML-Data representing DB-Objects. As there is a way to Insert, Update, Delete such data through the ImportSingleXML-HandleObject-JobComponent there should be a way to load this data in the Webdesigner to.

Best regards and thx in advance,

Martin