Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

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

  • Collins
  • Collins's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 22
  • Thank you received: 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?

Please Log in or Create an account to join the conversation.

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

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
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

Please Log in or Create an account to join the conversation.

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

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

That will work for now.

Thank you.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.057 seconds

I must say that I'm leaps and bounds ahead of where I would have other been with J2.5 with full thanks to the folks on this forum and specifically to Cook so you'll never hear me complaining.
gdpodesta (Forum)  

Get Started