|
Re:Starting ARI Data 11 Years, 10 Months ago
|
Karma: 748
|
|
Currently tutorial is available only in "Description" field on module settings page. If you click by "Detailed help here" link it appears into a lightbox. We are working on new version of the documentation, it will be ready soon.
Could you explain what "quotation marks" do you mean?
Regards,
ARI Soft
|
|
|
|
|
|
|
Re:Starting ARI Data 11 Years, 10 Months ago
|
Karma: 0
|
|
Sorry, I still have a problem that probabely already has been solved by others. Users are stored in the two tables "franc_user" and "franc_user_profiles". Thy are structured once vertically and once horizontally. The connector is "ID" in "franc_user" and "user_ID" in "franc_user_profiles". I can't find any connecting table. I want a table that shows name, email, adress1, adress2, city and fonenumbers. I made a SQL query in access, but this does not work in Ari. Do you hav a solution? I sent you the dumos to the mail adress you gave me.
Thanks a lot Thomas
|
|
|
|
|
|
|
Re:Starting ARI Data 11 Years, 10 Months ago
|
Karma: 748
|
Use the next SQL query:
| Code: |
(SELECT
user_id,
profile_key,
profile_value
FROM
#__user_profiles
WHERE
profile_key IN ('profile.address1', 'profile.address2', 'profile.city', 'profile.phone')
ORDER BY
user_id,ordering
)
UNION
(
SELECT
id AS user_id,
'profile.email' AS profile_key,
email AS profile_value
FROM
#__users
)
UNION
(
SELECT
id AS user_id,
'profile.name' AS profile_key,
name AS profile_value
FROM
#__users
)
|
and set "SQL -> Graph transformation -> Default" parameter to value.
Regards,
ARI Soft |
|
|
|
|
|
|
Re:Starting ARI Data 11 Years, 10 Months ago
|
Karma: 0
|
|
Thanks a lot, it almost works. But I still get a table, that shows the name in the last colummn instead as first. I dont understand completely how to set *Refert Data" (actually no) and "Graph transformation/Enable" (actually yes). How to fill in x-axis, y-axis and value (actually profile_key, user_id, provile_value).
Thanks a lot again, there was a slight difference to my SQL query - I learned a lot!
|
|
|
|
|
|
|
Re:Starting ARI Data 11 Years, 10 Months ago
|
Karma: 748
|
If you want to show name at first position, use the next SQL query:
| Code: |
(
SELECT
id AS user_id,
'profile.email' AS profile_key,
email AS profile_value
FROM
#__users
)
UNION
(SELECT
user_id,
profile_key,
profile_value
FROM
#__user_profiles
WHERE
profile_key IN ('profile.address1', 'profile.address2', 'profile.city', 'profile.phone')
ORDER BY
user_id,ordering
)
UNION
(
SELECT
id AS user_id,
'profile.name' AS profile_key,
name AS profile_value
FROM
#__users
)
|
Regards,
ARI Soft |
|
|
|
|
|
|
Re:Starting ARI Data 11 Years, 10 Months ago
|
Karma: 0
|
|
Thanks a lot,I learned about sql statments I didn't know well!
I'll try to change the range of columms myself.
Do you know a method to get rid of the quotation marks?
Thomas
|
|
|
|
|
|
|
