Getting field elements of another none-core field

More
13 years 2 months ago #18840 by ggppdk
Maybe the field A was not calculated before B.

Please do this:
1. Filter the fields by type and select the type of your item.
2. Then order the fields and place A before B

Regards


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

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

More
13 years 2 months ago #18842 by fesghel
The ordering was alright already, but it's not working. You sure it must be the name and not the id?

Thanks

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

More
13 years 2 months ago #18843 by ggppdk
You must order by type

Did you do that?


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

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

More
13 years 2 months ago #18846 by fesghel
Yes, I did.

Thanks

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

More
13 years 2 months ago #18847 by ggppdk
mmm, ok, then i will test the solution i proposed ...


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

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

More
13 years 2 months ago #18853 by fesghel
And another q. I used this code to run the query:

$db =& JFactory::getDBO();
$field_elements= 'SELECT DISTINCT i.id as value, i.title as text, i.catid as catid,'
.' FROM #__content as i'
.' LEFT JOIN #__flexicontent_fields_item_relations AS fi_rel ON i.id=fi_rel.value'
.' LEFT JOIN #__flexicontent_cats_item_relations AS rel ON rel.itemid = i.id AND rel.catid=i.catid'
.' LEFT JOIN #__categories AS c ON c.id = rel.catid'
.' WHERE fi_rel.field_id='.$field_id
.' AND fi_rel.item_id='.$item->id
;
$query = preg_match('#^select#i', $field_elements) ? $field_elements : '';
$db->setQuery($query);

$results =$db>loadObjectList();

but in the end $results is empty, while it's working on the original plugin(The one I linked in the first post of the topic). What is the problem?

Thanks

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.685 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline