Hello,

Is it possible to define some others expression than :
'@article_id'
'@category_id'
'@section_id'
'@user_id'
'@group_id'

To create custom condition ?

Actually I need to create a condition based on a field manually added to the Joomla's users table.

This ID is different for every users as the user_id is, in my case it is an internal customer ID.



In example :
Aditional Condition:
WHERE ERP_INTERNAL_ID = '@erp_id'


Congratulations for this excellent extension and thank in advance !!!

Hi,

where are you going to get @erp_id?

If you have added the field in jos_users table, then you have one sort of mapping between id of joomla users and your erp system.

All you need to create is sql view:

e.g.:


and create in WHERE section:
WHERE

When someone enters registered area, you can display only his/her erp_internal_id and name to him/her.

Or you need something else?

Best regards,
Viljem

First of all I just want to thank the developing team for this truly amazing extension. Two thumps up!

Im struggling with the same problem.

in the jos_users table I have a field "idcor"
I need to use a where expression according to this field of the logged in user in order to show data only related to this variable/ logged in user.

I however only have a basic understanding of SQL and I dont quite understand the explanation given in this thread.

If possible, please expand the explanation a bit?

Thank you very much

If I got you right, you added a new column to table jos_users.
If you are displaying the same table the sintax would be:



But I am afraid you were not specific enough for me to give you the correct answer. Which which table do you want to display and how is the data in this table connected to the users?