Welcome, Guest
Username: Password: Remember me

TOPIC: Fork to filter grid query by current user_id?

Fork to filter grid query by current user_id? 02 Oct 2013 17:31 #11279

  • Collins
  • Collins's Avatar
  • Offline
  • Junior Member
  • Posts: 22
  • Karma: 0
How do I access the query that feeds the grid?

I have one table. I want to add something like:

WHERE USER_ID = CURRENT_USER_ID

So that each user can only see their own records on the front end.

Where do I put this in a fork ?
What do I use for CURRENT_USER_ID?

or username if that is easier?
The administrator has disabled public write access.

Fork to filter grid query by current user_id? 02 Oct 2013 18:15 #11281

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 987
  • Karma: 140
I guess you have seen my previous post answering for your publish problem.

The query construction is in only ONE place for each model. -> prepareQuery()
Coding is now a piece of cake
The administrator has disabled public write access.

Fork to filter grid query by current user_id? 03 Oct 2013 03:23 #11288

  • Collins
  • Collins's Avatar
  • Offline
  • Junior Member
  • Posts: 22
  • Karma: 0
Yes,
it is working now by using un-publish.

That will work for now.

Thank you.
The administrator has disabled public write access.
Time to create page: 0.070 seconds

Get Started