Additional expression..

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.:

CREATE VIEW Something AS
SELECT id, ERP_INTERNAL_ID, name
FROM jos_users

id = @user_id

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