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