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.287 seconds

Real time saver and great Component Builder tool ! I have been developing with J-Cook Pro Component Builder for several months now and can say with all honesty that this product/service is second to none. The product is feature rich and is being improved and added to all the time. Do yourself a favor if you need to build a Joomla! Component then you can do no wrong in trying the product. You will save on time and effort while being able to deliver your project on time. J-Cook pro does the hard work for you you then have the freedom to fully customise the end result for your own needs. 

One word: Awesome.
Edwardcox (JED)
         

Get Started