Hi,

Is there an possibility to show filtered data to Community Builder users (different users, differt data)?

Hello,

Do you want to display data from database and use ID of logged user into SQL query or you mean something another?

Regards,
ARI Soft

I want to show certain sql data to certain users. For example: user ID 2 can only see data concerning his own scores, user ID 3 etc.

The module provides ability to user ID of logged user into SQL query. One note, currently it can be shown in module position or in an article.

Regards,
ARI Soft

Specifically, how do I filter the data or query by logged in user? Here is what I have and it works great. However, I need to filter by logged in user. Any help will be appreciated.

Code
------------------------------------------------------------------------------------
SELECT jos_facileforms_subrecords.name, jos_facileforms_subrecords.value, jos_facileforms_records.id
FROM jos_facileforms_subrecords
LEFT JOIN jos_facileforms_records ON jos_facileforms_subrecords.record = jos_facileforms_records.id
WHERE jos_facileforms_subrecords.title IN ('Project Title')
ORDER BY jos_facileforms_subrecords.id

-------------------------------------------------------------------------------------

thank you in advance for your help!

Hello,

You can use {$UserId} predefined variable in SQL query. {$UserId} contains ID of logged user.

Regards,
ARI Soft