AppGini Community Forums

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

you can try changing the quotes for " or ` or '

hope it helps

D Oliveira

Thanks but it did not help - I have tried all but still the same

Hi,

try (first quotes leaning left,
quotes around Mark are not leaning)

Does it work?

Olaf

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.

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

Hi,
Thanks ..

No, I did not use full SQL statement and I have a single table in this database!

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

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

Hi Mohamed,

my pleasure.
Thank you for testing and reporting back.

Olaf