Hello,
I have tried this WHERE Clause in the Event `Create_User` = `Mark`
to show only events created by the user `Mark` BUT when I save it, no events displayed on the calendar !!
Any clue
Where Clause NOT Working `Create_User` = `Mark`
Where Clause NOT Working `Create_User` = `Mark`
- Attachments
-
- Where Clause
- Calendar - Where Clause Problem.PNG (8.18 KiB) Viewed 2867 times
THANK YOU...
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course
- D Oliveira
- AppGini Super Hero
- Posts: 348
- Joined: 2018-03-04 09:30
- Location: David
Re: Where Clause NOT Working `Create_User` = `Mark`
you can try changing the quotes for " or ` or '
hope it helps
hope it helps
Re: Where Clause NOT Working `Create_User` = `Mark`
D Oliveira
Thanks but it did not help - I have tried all but still the same
Thanks but it did not help - I have tried all but still the same
THANK YOU...
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course
Re: Where Clause NOT Working `Create_User` = `Mark`
Hi,
try
(first quotes leaning left,
quotes around Mark are not leaning)
Does it work?
Olaf
try
Code: Select all
WHERE `Create_User`= 'Mark'
quotes around Mark are not leaning)
Does it work?
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
Re: Where Clause NOT Working `Create_User` = `Mark`
Actually, I have found the cause of the problem, that I was missing the Table Name and Field Name:
`TableName`.`Create_User`= 'Mark'
that I must add the Table Name.
`TableName`.`Create_User`= 'Mark'
that I must add the Table Name.
THANK YOU...
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course
Re: Where Clause NOT Working `Create_User` = `Mark`
Hi,
well, you should probably have provided the full SQL statement in the first place: If you pull data from only one table, you do not need to have the tablename in the WHERE clause. So next time ...
Olaf
well, you should probably have provided the full SQL statement in the first place: If you pull data from only one table, you do not need to have the tablename in the WHERE clause. So next time ...
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
Re: Where Clause NOT Working `Create_User` = `Mark`
Hi,
Thanks ..
No, I did not use full SQL statement and I have a single table in this database!
Thanks ..
No, I did not use full SQL statement and I have a single table in this database!
THANK YOU...
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course
Re: Where Clause NOT Working `Create_User` = `Mark`
Hi,
if you have only one table, SQL does not need the name of the table to work.
I did suggest different quotaion marks - maybe this made it work? Do you mind testing - just for my own peace of mind Thanks
Olaf
if you have only one table, SQL does not need the name of the table to work.
I did suggest different quotaion marks - maybe this made it work? Do you mind testing - just for my own peace of mind Thanks
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
Re: Where Clause NOT Working `Create_User` = `Mark`
Hi,
Sure, I did the test...
it worked fine as you suggested but without using or adding the WHERE clause WHERE `Create_User`= 'Mark'
I mean it should be entered this:
`Create_User`= 'Mark'
You are the man
Sure, I did the test...
it worked fine as you suggested but without using or adding the WHERE clause WHERE `Create_User`= 'Mark'
I mean it should be entered this:
`Create_User`= 'Mark'
You are the man
THANK YOU...
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course
Re: Where Clause NOT Working `Create_User` = `Mark`
Hi Mohamed,
my pleasure.
Thank you for testing and reporting back.
Olaf
my pleasure.
Thank you for testing and reporting back.
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view