Complex Field Queries [SOLVED]

This is included (and debugged) in flexicontent v1.5.6beta1

Regards

The queries work excellently. Thanks to this, I have made huge progress in my project. Just marked as SOLVED.

brat it possible to do a quick tutoriel ?
thanks

Yes you can use replacements in the sql query to get information for current item:

{item->created_by} (userid of owner)
{item->modified_by} (userid of last modifier)
{item->catid} (main category of the item)
{item->...}

to see available columns to a :
echo "<pre>"; print_r($item); exit();

e.g. in your template file item.php of the item view, or inside the select and selectmultiple plugin

Regards

same for category view ?

My post was confusing , i just meant to provide a way to see what is available for an item.

The replacement e.g. {item->created_by} etc is meant to be used in the sql code of select and selectmultiple , and it will work anywhere , any view.

The replacement occurs inside the plugin code of the select & selectmultiple field.

To use replacement do this:

1. You create a new selectmultiple (or select) field

2. You set the options of the field to be created by by setting to YES the option "Use Sql Query"

3. Inside the textarea 'Field Elements', you write:

(a) e.g. to create a select field that contains all items of the owner of the current item: (b) e.g. to create a select field that contains all items of the same main category as the current item: Regards