Re: Cakephp 3.0 Get and Modify Query conditions in beforeFind function

2015-02-27 Thread Cake Developer
Hi, Ok I managed solution. Thanks On Thursday, January 29, 2015 at 8:26:57 PM UTC+5:30, Cake Developer wrote: Hi Mark Story, any help please? thanks On Friday, January 23, 2015 at 6:02:46 PM UTC+5:30, Cake Developer wrote: Hi Josh, I tried both PlumSearch and Search Plugin in my

Re: Cakephp 3.0 Get and Modify Query conditions in beforeFind function

2015-01-29 Thread Cake Developer
Hi Mark Story, any help please? thanks On Friday, January 23, 2015 at 6:02:46 PM UTC+5:30, Cake Developer wrote: Hi Josh, I tried both PlumSearch and Search Plugin in my application and they are not working as expected. They are adding search arguments in existing conditions in query

Re: Cakephp 3.0 Get and Modify Query conditions in beforeFind function

2015-01-23 Thread Cake Developer
Hi Experts, Can anyone solve my problem please? -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups CakePHP group. To unsubscribe from this group and stop receiving

Re: Cakephp 3.0 Get and Modify Query conditions in beforeFind function

2015-01-23 Thread Cake Developer
Hi Josh, I tried both PlumSearch and Search Plugin in my application and they are not working as expected. They are adding search arguments in existing conditions in query object. Failing Situation. Existing condition has Users.active = 1 and If new condition array has Users.active = 0 so

Re: Cakephp 3.0 Get and Modify Query conditions in beforeFind function

2015-01-23 Thread José Lorenzo
What have you tried so far? On Friday, January 23, 2015 at 9:25:21 AM UTC+1, Cake Developer wrote: Hi Experts, Can anyone solve my problem please? -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because

Re: Cakephp 3.0 Get and Modify Query conditions in beforeFind function

2015-01-20 Thread Cake Developer
Hi Josh, Thanks for your answer. I tried both PlumSearch and Search Plugin in my application and they are not working as expected. They are adding search argumentsin existing conditions in query object. Failing Situation. Existing condition has Users.active = 1 and If new condition array has

Re: Cakephp 3.0 Get and Modify Query conditions in beforeFind function

2015-01-19 Thread José Lorenzo
Sorry, I forgot to answer... What you are doing sounds similar to what some plugins are doing as well. Please try these: https://github.com/skie/plum_search https://github.com/FriendsOfCake/search As for the second case. I suggest doing as I suggested at the beginning, use the query options

Re: Cakephp 3.0 Get and Modify Query conditions in beforeFind function

2015-01-19 Thread Cake Developer
Hi Experts, any help? Thanks in advance. On Friday, January 16, 2015 at 12:47:39 AM UTC+5:30, José Lorenzo wrote: Even though that is possible you are tying to do it the hard way. The easiest way you can implement the same is by using the query as a command object, thus instructing the

Re: Cakephp 3.0 Get and Modify Query conditions in beforeFind function

2015-01-19 Thread God bless
Hi Jose, I gone through both of the plugin links you provided, It seems they are complicated and do not meet my requirements. I am trying to write a generic solution to filter records with less code. Is there any way to get original conditions from query object as an array format. For e.g.

Re: Cakephp 3.0 Get and Modify Query conditions in beforeFind function

2015-01-19 Thread José Lorenzo
I don't think it is possible in an easy way, I also think you are trying to complicate the problem, given the existence of other clean solutions that already work. There are two methods that clause('where') object has that can be used to traverse the query. They are iterateParts() and

Re: Cakephp 3.0 Get and Modify Query conditions in beforeFind function

2015-01-16 Thread Cake Developer
Hi Josh, Thanks for the answer. Let me explain what I am trying to achieve. I am working on filter records based on data entered on search form. ---Controller code $this-paginate = ['searchFilter'=true, 'limit'=10, 'order'=['Users.id'='DESC'], 'conditions'=['Users.active'=1]]; $users =

Re: Cakephp 3.0 Get and Modify Query conditions in beforeFind function

2015-01-15 Thread José Lorenzo
Even though that is possible you are tying to do it the hard way. The easiest way you can implement the same is by using the query as a command object, thus instructing the custom finders to do stuff based on the passed options. An example $table-find('forUser', ['user' =