Community Tip - You can change your system assigned username to something more personal in your community settings. X
Hi All,
Solved! Go to Solution.
Hello @cbaurand,
Unfortunately there are no JOINs in ThingWorx data model, so you can't do something like what you would do in SQL: "SELECT * FROM A LEFT JOIN B ..." The things are "linked" together via their names, which are simple strings. ThingWorx doesn't ensure referential integrity and/or simplify queries for you in this case.
So if you need to find an object A based on B's property, you need first to run a query to find B's thing name, and then do another query to find A, which uses this name.
Regards,
Constantine
Hello @cbaurand,
Unfortunately there are no JOINs in ThingWorx data model, so you can't do something like what you would do in SQL: "SELECT * FROM A LEFT JOIN B ..." The things are "linked" together via their names, which are simple strings. ThingWorx doesn't ensure referential integrity and/or simplify queries for you in this case.
So if you need to find an object A based on B's property, you need first to run a query to find B's thing name, and then do another query to find A, which uses this name.
Regards,
Constantine
Hi @cbaurand.
If the previous response answered your question, please mark it as the Accepted Solution for the benefit of others with the same question.
Regards.
--Sharon