Categories
View Replies (5)

Resolved How to grab user's name associate with two different fields

  1. shawnhy
    shawnhy
  2. RO CSVI
  3. Wednesday, 12 December 2018
  4.  Subscribe via email
I am not sure how to describe My question clear... sorry I try my best.
I have a table named "paper" with field "user_id", which refers to Joomla core table "users". In the meantime, I have another table named "reviewer" with field "reviewer_id". My purpose is to output field "name" in table "users".
I have joined users->id with reviewer->reviewer_id, and it works. But when I added another join rule, out file is blank.

* Version of the extension you are using:
* CSVI version (Latest is not a version number): CSVI Pro 7.9.0
* A copy of the template you are using. http://paper.eyesome.tw/tmp/com_csvi/csvi_templates_paper.eyesome.tw_20181212.xml
* Collected debug information
0
Responses (5)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
From your screenshot i can see you are using three different columns of table jwepapersubmission_paper in Join condition. I am not sure how your tables are connected or about records in them but check if you are joining them with correct id fields. Are you sure that the ids you are trying to join match with values in other tables?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
shawnhy
shawnhy
Accepted Answer Pending Moderation
Hello.
While I have author_id and reviewer_id in my table, I am try to get their name, instead of just ID numbers. Any general guide to do?
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Both author_id and reviewer_id are id of users from Joomla Users table and you need the name of the user related to both these ids?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
shawnhy
shawnhy
Accepted Answer Pending Moderation
Yes, you understand my problem correctly. How should I do?
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
To get values of a column from a table by joining two columns in same table to one column of another is only possible using table alias. Currently CSVI custom table export does not support table aliases. if you know how to use PhpMyAdmin, you can run the below query in PhpMyAdmin and export the values to csv from there. I have assumed the table name having author_id and reviewer_id as #__reviewers, you need to use the name as per your database. In the meantime we will see what we can do with table alias with CSVI custom table export.



SELECT users.name AS name1, users1.name AS name2

FROM #__reviewers reviewers

LEFT JOIN #__users users ON users.id = reviewers.author_id

LEFT JOIN #__users users1 ON users1.id = reviewers.reviewer_id
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!