Joomla 6 Notice

We are pleased to announce that all our Joomla extensions have been compatible with Joomla 6 since October 14th, 2025.

For those currently upgrading from Joomla 3 to 4: Instructions for Joomla 4 migration can be found here:

There are standalone documentations Visforms Joomla 4, Visforms Joomla 5 and Visforms Joomla 6.

Forum

Visforms Subscription user can ask questions in our forum. Please log in with the relevant user first.
Everybody can access the forum for reading.

Please only ask 1 question per topic.

Important information for almost every question:
V1: Which Visforms version is running?
V2: Which Joomla version is running?
V3: Which PHP version is running?

SQL SELECT Statement für eigene Daten

More
1 year 10 months ago #10430 by prffrost
SQL SELECT Statement für eigene Daten was created by prffrost
gibt es eigendlich ein SQL SELECT Statement für eigene Daten?

SELECT
    F9300 as value,
    CASE
        WHEN created_by IN ('891', '948') THEN F9300
        ELSE NULL
    END as label
FROM
    urwsg_visforms_23
WHERE
    created_by IN ('891', '948')
ORDER BY
    F9300 ASC;
   
created_by sollte dabei der User sein der die Daten eingereicht hat .. und auch nur er sieht..

 

More
1 year 10 months ago #10431 by prffrost
Replied by prffrost on topic SQL SELECT Statement für eigene Daten
so klappt das...

SELECT F9300 AS value, F9300 AS label
FROM urwsg_visforms_23
WHERE created_by = ${user:id}
ORDER BY F9300 ASC;
The following user(s) said Thank You: Administrator IV

More
1 year 10 months ago #10432 by prffrost
Replied by prffrost on topic SQL SELECT Statement für eigene Daten
und so klappt das auch für Benutzer Gruppen..

SELECT F9300 AS value, F9300 AS label
FROM urwsg_visforms_23
WHERE
(`published` = 1 AND `created_by` = '${user:id}')
OR (
'${user:id}' = 891
OR (
EXISTS (
SELECT 1
FROM #__user_usergroup_map AS um
JOIN #__usergroups AS ug ON um.group_id = ug.id
WHERE um.user_id = '${user:id}'
AND (ug.title = 'Service' OR ug.title = 'Super Administrators')
)
)
)
ORDER BY F9300 ASC;
The following user(s) said Thank You: Administrator IV

Moderators: Administrator AVAdministrator IV
Powered by Kunena Forum