Community Tip - Learn all about PTC Community Badges. Engage with PTC and see how many you can earn! X
Hi All,
I just want to list out those entities which are created by a a specific user. Is we have something in Thingworx?
Solved! Go to Solution.
If you have direct access to the TWX DB you could create a secondary JDBC connection to it and then write a query on your new DB thing that looks in the public.thing_model table to get you this information.
Hi,
There is no out of the box service for that.
I don't know if it helps, but you can see owner if you export entities in xml format.
Raluca Edu
If you have direct access to the TWX DB you could create a secondary JDBC connection to it and then write a query on your new DB thing that looks in the public.thing_model table to get you this information.
Hi @koushal.
If one of the previous responses answered your question, please mark the appropriate one as the Accepted Solution for the benefit of others with the same question.
Regards.
--Sharon
Hi,
If wan't be super speedy, but you can do as follow:
var result = Resources["SearchFunctions"].SearchAll().thingResults;
result.AddField({name: "owner", baseType: "STRING" });
var creator
for each(row in result.rows) {
try {
creator = eval(row.parentName)[row.name].GetConfigurationChangeHistory().Find({ changeAction: "CREATE" });
if (creator!==null) {
row.owner = creator.user;
}
} catch(error) {}
}
Sorry, this is to get all entities owner, you just need to filter by the desired user and you are done.