Import/Export Working set?

[adepreter]

Hello,
Does anybody know how to export and import working sets?
Or, as an alternative, do you know where this data is stored?

I can't find this in "Export reference data"
Nor in AppData
Nor in the registry

So I guess in must be somewhere in the database?

[Geert Bellekens]

Working sets are stored in the model in t_document

This code is how I get them out

Code: [Select]

        public List<WorkingSet> workingSets
        {
            get
            {
                List<WorkingSet> workingSetList = new List<WorkingSet>();
                string getWorkingSets = "select d.docid, d.DocName,d.Author from t_document d where d.DocType = 'WorkItem' order by d.Author, d.DocName";
                XmlDocument workingSets = this.SQLQuery(getWorkingSets);
                foreach (XmlNode workingSetNode in workingSets.SelectNodes("//Row"))
                {
                    string name = string.Empty;
                    string id = string.Empty;
                    string ownerFullName = string.Empty;
                    foreach (XmlNode subNode in workingSetNode.ChildNodes)
                    {
                        switch (subNode.Name.ToLower())
                        {
                            case "docid":
                                id = subNode.InnerText;
                                break;
                            case "docname":
                                name = subNode.InnerText;
                                break;
                            case "author":
                                ownerFullName = subNode.InnerText;
                                break;
                        }
                    }
                    User owner = this.users.Find(u => u.fullName.Equals(ownerFullName, StringComparison.InvariantCultureIgnoreCase));
                    workingSetList.Add(((Factory)this.factory).createWorkingSet(name, id, owner));
                }
                return workingSetList;
            }
        }
Geert

[adepreter]

Thank you Geert!

Very useful!

And you answered at 7:30 in the morning on a public holiday :-)

[Geert Bellekens]

Thank you Geert!

Very useful!

And you answered at 7:30 in the morning on a public holiday :-)

That must be some kind of forum server time. It was more like 11:15 CEST

Geert