Joomla 5 Notice

We are pleased to announce that as of January 29, 2024, all of our Joomla extensions are compatible with Joomla 5.

For all who are still updateing from Joomla 3 to Joomla 4: Joomla 4 Migration instructions are available here:

There is now a separate Documentation for Visforms for Joomla 4 and for Visforms for Joomla 5!

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
5 months 3 weeks 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
5 months 3 weeks 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
5 months 3 weeks 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