easy access to id values

[jasonsot]

is there somewhere that all the values for ids are stored? ex: assigned_user_id, campaign_id, etc?

[Angel]

Don't believe so.

[kbrill]

You can just export the modules in question and ge the ID from there.

[jasonsot]

yeah, i know... but i have about 20 users, 10 campaigns, and 5 teams. I cant generate one report to export that will contain all of them without exporting 1000s of records.

I was hoping there might be a file those are stored in. aw well... ya win some... lol

thanks!!!

Jason

[Angel]

You could also try something like this:

select id from contacts
union all
select id from accounts
union all
select id from calls

and so on for all the tables...

That one query would return all the ID values for all the given tables.