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

TOPIC:

Joomla xxx_users file - handling profile.key 03 Nov 2012 18:29 #4969

I have three tables I am trying to create a report from.
Two of them use "profile_key" matched with a "user_id" to get the value in "profile_value"

"profile_value" is the data I want to show based on the user_id and the profile_key.

How do I put that in the fields?

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

Re: Joomla xxx_users file - handling profile.key 15 Nov 2012 22:42 #5396

  • JoomGuy
  • JoomGuy's Avatar
  • Offline
  • Moderator
  • Moderator
  • Joomla Enthusiast, Lover of Cooking
  • Posts: 1115
  • Thank you received: 195
Hi @mfisher99,

Please could you further explain your tables?

Do you mean that one of them is the core joomla users table when you refer to:

Two of them use "profile_key" matched with a "user_id"

AND
What is

profile_value

and which table is it from?

Thanks,

Gez
Need help with your Cook/Joomla Project? . PM me to find out what I can help with. NO time wasters please!!!

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

Re: Joomla xxx_users file - handling profile.key 21 Nov 2012 10:33 #5554

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
Welcome to the community.

Did you understood how Cook deals with Foreign Tables ?

If you want to create a chart, or a report, the simpliest thing to do is to create a grid list containing (preparing) all the foreign values that you will want to use to compose your report or chart or anything else... (map, pdf, ...)

If you deal with an item, do the same with a 'Fly' brick (read only item page)
Coding is now a piece of cake

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

Re: Joomla xxx_users file - handling profile.key 22 Dec 2012 14:50 #6238

  • JoomGuy
  • JoomGuy's Avatar
  • Offline
  • Moderator
  • Moderator
  • Joomla Enthusiast, Lover of Cooking
  • Posts: 1115
  • Thank you received: 195
OK, on reading this having come across it again when looking for another post, I think I understand better what you are trying to do...

You are referring to getting info from a profile plugin, right?

Please see www.j-cook.pro/forum/12-new-functionalit...er-profile-data#6217

G
Need help with your Cook/Joomla Project? . PM me to find out what I can help with. NO time wasters please!!!

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

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

Although I found this tool some time ago I just started learning experimenting and building this first component on Monday and now on Thursday afternoon it's already online. Although I already had a working version done with another tool this is much easier to build and at the end you have the freedom to own your own component. Once you know how to use Cook you will boost your productivity as the learning curve is really moderate compared to many other tools.
Giori (Forum)

Get Started