Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Forum
Support forum
Coding inside your component
Fork to filter grid query by current user_id?
  • 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
Forum
Support forum
Coding inside your component
Fork to filter grid query by current user_id?
Time to create page: 0.089 seconds
“
”

This is what you call a component builder. I was able to master using this in a very short time and the resulting component works like a charm. Not just a basic component builder but a fully working component builder with forms fields tables all ready to go. You can make the list and item views to display in the front and back end. Also there is a great forum just starting to evolve and I'm sure this will grow very rapidly when you all realise how good this tool is.
Kevin (JED)

         

Get Started

Log In Sign In