The extension doesn't provide ability to add, edit or delete data. If you want to show data as on provided screenshot, the next SQL query can be used in "ARI Data Tables" module:
| Code: |
SELECT
SI1.content AS `Name`,
SI2.content AS `Col2`,
SI3.content AS `Col3`,
SI4.content AS `Col4`,
SI5.content AS `Col5`,
SI6.content AS `Datum`,
SI7.content AS `Telefon`,
SI8.content AS `Ma-Nr`
FROM
#__m4j_storage_items SI1 INNER JOIN #__m4j_storage_items SI2
ON SI1.stid = SI2.stid
INNER JOIN #__m4j_storage_items SI3
ON SI1.stid = SI3.stid
INNER JOIN #__m4j_storage_items SI4
ON SI1.stid = SI4.stid
INNER JOIN #__m4j_storage_items SI5
ON SI1.stid = SI5.stid
INNER JOIN #__m4j_storage_items SI6
ON SI1.stid = SI6.stid
INNER JOIN #__m4j_storage_items SI7
ON SI1.stid = SI7.stid
INNER JOIN #__m4j_storage_items SI8
ON SI1.stid = SI8.stid
WHERE
SI1.cid = 1
AND
SI2.cid = 2
AND
SI3.cid = 3
AND
SI4.cid = 4
AND
SI5.cid = 5
AND
SI6.cid = 6
AND
SI7.cid = 7
AND
SI8.cid = 8
ORDER BY
SI1.stid
|
Regards,
ARI Soft
