Sounds good, and completely off topic, but whilst you are online.. did you get that contact from me through your website contact form or are you too busy to contemplate? There is a little configuration of a JCook project I needed heklp with that I was hoping you could assist with for proper dev payment

I didn't remember your mail. Guess I didn't received it.

I will be hirable after the release, and the stabililization of it.
Also I mean "releases" in plural : N:M and F0F (experimental) are the priorities and I work full time on that at the moment.
But it will not be that long.

Normally I accept this of course, but if you are in hurry, you can ask in the forum int this category (moved topic)

This is the copy for the mail your website sent me after I used the contact form... I have embellished a little more

==================
I was wonder what the chances were of getting you to assist me with after coding of a component.

I have asked for help on the forums with no replies from the usual JCook experts.

I will happily pay whatever hourly rate you require, but I suspect (hope) as this is using JCook code you will be able to do it in record time.

1) I need is a snippet of code so that when somebody adds or updates a record on one table (and several others) it will auto write an entry to a separate 'feed tables' ie

i,e if someone adds a new DEAL record on the deal table, the following will be added silently to the FEEDS table

So a save action of a new deal saves the deal as normal but then fires off a function which passes ('deal', new deal ID, 'add', JoomlaID) to the feeds table
An update actions will save the deal (again) but fire off a function that passes ('deal',DealID, 'update', JoomlaID) to the feeds table

This function could be reused for several other tables

etc.. so this be will a reusable helper function. On old Joomla, I could do this easily, but I would much rather do it using strict J3 / latest JCook standards which I am not yet totally familiar with

I do not want to say on the forums which project it is as the name is a brand, but its the project that begins with Pin... on my project area

The table I want to auto update is called FEEDS (so you can see the structure)

2) GROUP BY seems to have been depreciated but it is a very powerful SQL statement. i have need of GROUP BY in one of my models, but no matter how I try to force it in, I cant get the statement to appear.

Can you clarify how I can add a GROUP BY clause in perpareQuery (in the code as LEGACY)

I am happy to pay upfront if terms are agreeable if you can estimate the job.

Ok, I see more or less the idea.
I take note, I will tell you when I am back hirable.


Group By has been deprecated for GroupOrder. Because the REAL SQL statement has never been handled in component until component has a use for it.
So because Cook do not use this statement, is does not exist in the model.

It has been asked many times, I will create it.

The old groupBy, still works. It is only a prioritary order before all other order statements to group items on FK in the lists (grid).
So, I simply renamed it. And it is not the SQL group by.

Thanks, if you do fancy the change from upgrading the builder and can get to that custom helper (or anyone reading this can) sooner, it would be nice, but I understand what being busy and focused is all about

Thanks

addGroupBy() is now instancing a real GROUP BY (since 2.7)

and

addGroupOrder() is instancing a prioritary order for lists (unchanged)