How can I access Communardo UserProfileField data directly in database?

[Christof Hurst _kreuzwerker_]

I can't find the stored values, can anyone provide some information or small SQL snippet please?

Thanks in advance.

Christof

[Zak Laughton · Accepted solution]

Hi Christof!

I don't know exactly where Communardo stores this data. But in case it helps, third party plugins often hold their data in "Active Objects" tables, which have table names that start with "AO_". You can also reach out to Communardo support, and they may be able to provide more info.

I hope this helps!
– Zak

[Christof Hurst _kreuzwerker_]

Hi Zak,

thanks for your answer. After long searches the dbView app helped me by displaying all tables. So I found the correct AO tables. I had (wrongly) in my mind that the values are stored in OS_PROPERTYENTRIES but this was the other user profiels app.

The tables are AO_EF453E_...

Best regards

Christof