Is it possible to have the same ID on diferent modules?

[leowolff]

Hello, is it possible that an ID of a custom module could be the same as an ID from account module?
I am asking this because I have to merge the info from this custom module with account module to be accessed in a third system, and I will use the ID from both modules to identify the data. By the way, the merge will be outside of Sugar.

[Angel]

There was a post on this topic some months back and it was essentially a warning to not do that. Apparently some of the JavaScript code in different areas of Sugar gets confused if the same ID value exists as an ID value in more than one table.

[leowolff]

Thanks Angel for your reply, but I am not worried if Sugar will get confused if the same ID value exists as an ID value in more than one table. Both modules will be exported and merge outside, and a third program will read this single table on another database, so nothing to do with Sugar about reading registers.

What I am asking is if the ID code generator can create the same ID for diferent register in diferent modules?

[mvngti]

Apart from the concern stated by Angel re Javascript code there should be no reason why two records in two different modules/tables can not have the same ID.

But the "generator" will not generate them like that, you will have to set the ID of the second module in the save method or a before_save logic hook. (Remember to set new_with_id if you set the id on a new record).

May I suggest you rather use a derivative of the ID in your second module. A simple solution is to md5 it. Then you have two different ID's (for js and whatever sake) but you can always easily generate the 2nd one from the 1st for your outside linking. You can just add a column to the 1st module that also contain the md5 of the ID and then join on that column.

M

[mvngti]

Thinking about it a bit more a better solution would be to create a relate field on the second module that contain the id of the first.

Then you have two records with distinct, sugar generated, ID's but you can link them on the ID on the left and the relate_id on the right.

M