https://antibiotiqueaugmentin.com/surdosage-augmentin-bebe/

Forum

  2. Home
  3. Forum
  4. Table JX
  5. Installation
  6. Additional Condition not working
× Welcome to the ToolsJX forum!


Additional Condition not working

  • bet009
  • bet009's Avatar Topic Author
  • Visitor
  • Visitor
11 years 9 months ago #2166

I am trying to get the additional condition working but I keep getting no records found, and I know there are records tied to the user.

In the external database table i have a field CUSTNMBR, and this is tied to joomla username.

CUSTNMBR=@users_username

I have tried
CUSTNMBR=@user_username also

Can you help me out please? Why isn't this working?

Please Log in or Create an account to join the conversation.

More
11 years 9 months ago #2167

Hi,

You can only use the parameters described in the backend or constants. I think that what you need is the @user_id parameter.

CUSTNMBR=@user_id

should work if you have ids of joomla users in the CUSTNMBR field. Otherwise you will have to create some kind of database view which will join your data in a way that it will include ids of joomla users (from table yourprefix_users).

Please Log in or Create an account to join the conversation.

  • bet009
  • bet009's Avatar Topic Author
  • Visitor
  • Visitor
11 years 9 months ago #2168

THANK YOU! I did have to export the ID from the joomla user table. Thank you!

Please Log in or Create an account to join the conversation.

Moderators: tomaz
Time to create page: 0.140 seconds

Contact Us

Contact us on Discord

Contact us on Facebook