Home News Contact Us Forum About Us Demos Products F.A.Q.
ARI Soft









Register   Lost Password?
Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin







e-mail: info@ari-soft.com
Shopping Cart
You currently have 0 items in your cart.
Show Cart


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.
    more...

  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.
    more...


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?
ARI Soft Forum
Joomla components
ARI Data Tables

Show filtered data to Community Builder users
(1 viewing) (1) Guest
Go to bottomPage: 123
TOPIC: Show filtered data to Community Builder users
#12837
Re:Show filtered data to Community Builder users 13 Years, 8 Months ago Karma: 0
Thanks for your response. However, could you give the exact code to place in my query so the data that my query is pulling will only provide it by the current user? I have tried but to no avail.

thanks
garyjoomla
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#12838
Re:Show filtered data to Community Builder users 13 Years, 8 Months ago Karma: 760
Provide structure jos_facileforms_records and jos_facileforms_subrecords tables please.

Regards,
ARI Soft
admin
User Online Now Click here to see the profile of this user
The administrator has disabled public write access.
 
#12839
Re:Show filtered data to Community Builder users 13 Years, 8 Months ago Karma: 0
Here ya go.

Code
------------------------------------------------------------------------------------
SELECT jos_facileforms_subrecords.name, jos_facileforms_subrecords.value, jos_facileforms_records.id
FROM jos_facileforms_subrecords
LEFT JOIN jos_facileforms_records ON jos_facileforms_subrecords.record = jos_facileforms_records.id
WHERE jos_facileforms_subrecords.title IN ('Project Title')
ORDER BY jos_facileforms_subrecords.id

-------------------------------------------------------------------------------------

thank you in advance for your help!
garyjoomla
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#12840
Re:Show filtered data to Community Builder users 13 Years, 8 Months ago Karma: 760
Provide structure of the tables, not your SQL query. We need to know what columns contains the tables.

Regards,
ARI Soft
admin
User Online Now Click here to see the profile of this user
The administrator has disabled public write access.
 
#12841
Re:Show filtered data to Community Builder users 13 Years, 8 Months ago Karma: 0
Hi,

I re-read your email requesting the structure. I have attached that information.
File Attachment:
File Name: Structure.zip
File Size: 760834
garyjoomla
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#12842
Re:Show filtered data to Community Builder users 13 Years, 8 Months ago Karma: 760
Thank you. Use the next SQL query:

Code:

SELECT 
  SR.name, 
  SR.value, 
  R.id
FROM 
  #__facileforms_subrecords SR LEFT JOIN jos_facileforms_records R 
    ON SR.record = R.id
WHERE 
  R.user_id = {$UserId}
  AND
  SR.title IN ('Project Title')
ORDER BY 
  SR.id


Regards,
ARI Soft
admin
User Online Now Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 123
ARI Soft Forum
Joomla components
ARI Data Tables
Powered by Kunenaget the latest posts directly to your desktop
Useful Links
Products
F.A.Q.
Discount
RSS
Top Products
ARI Data Tables
ARI Sexy Lightbox
ARI Quiz
ARI Stream Quiz - Personal
ARI Smart Content
Help
Forum
F.A.Q.
Home | News | Contact Us | Forum | About Us | Demos | Products | F.A.Q.
ARI Soft
License | Terms and Conditions | Copyright Info | Privacy Policy
 
ARI Soft
Copyright © 2009