03-29-2017 01:24 AM
I don't think this is possible but thought I would just check.I want to remove a DN from associated line groups.
However I don't want to care what line groups its a member off or know .I just want to remove it from all of them.
Is there away of doing this , it looks like you need to know the line group name using "updateLineGroup"
Solved! Go to Solution.
03-29-2017 09:48 AM
It looks like the relationships between lineGroups and DNs is held in the table "linegroupnumplanmap". You should be able to construct a DELETE SQL query via <executeSqlUpdate> to delete any records where the fknumplan matches the pkid of the DN you want to remove from all groups.
03-29-2017 09:48 AM
It looks like the relationships between lineGroups and DNs is held in the table "linegroupnumplanmap". You should be able to construct a DELETE SQL query via <executeSqlUpdate> to delete any records where the fknumplan matches the pkid of the DN you want to remove from all groups.
03-31-2017 04:52 AM
Thanks , I hadn't thought of that , will have a look
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide