topic Re: Editing DN URIs via SQL in Management

Editing DN URIs via SQL

Gordon Ross — Wed, 15 Jul 2015 07:32:50 GMT

I want to manipulate a directory number's URIs via SQL. I've found the table and understand the schema fine. My problem is the primary URI field.

According to the database schema docs, you can't change which URI is the primary one (the isprimary column is listed as "Not Modifiable")

If the isprimary column values can't be changed, how can you change the primary URI on a DN? Is the only way, to delete all the existing URIs and add them back, with the new primary one being the first one to be added back in?

GTG

Re: Editing DN URIs via SQL

npetrele — Wed, 15 Jul 2015 21:42:56 GMT

Why wouldn't you simply use the getLine and updateLine AXL APIs? updateLine has a "isPrimary" tag:

</directoryUri>

</directoryURIs>