Hello community,
I have some trouble finding a solution for my current problem, maybe somebody can point me into the right direction?
The current situation (names changed):
At the moment I use a CMS_INPUT_COMBOBOX to select a category.
<CMS_INPUT_COMBOBOX name="st_cat" hFill="yes" useLanguages="no">
<CMS_INCLUDE_OPTIONS type="database">
<LABELS>
<LABEL lang="*">#item.name</LABEL>
</LABELS>
<TABLE>scheme.cat</TABLE>
</CMS_INCLUDE_OPTIONS>
<LANGINFOS>
<LANGINFO lang="*" label="Category"/>
</LANGINFOS>
</CMS_INPUT_COMBOBOX>
This category serves as a filter for the selectable options in a CMS_INPUT_LIST.
<CMS_INPUT_LIST name="st_prod" hFill="yes" sortOrder="keep_order" useLanguages="no">
<CMS_INCLUDE_OPTIONS type="database">
<LABELS>
<LABEL lang="*">#item.name</LABEL>
</LABELS>
<QUERY name="scheme.prod_filter">
<PARAM name="catId">0</PARAM>
</QUERY>
<TABLE>scheme.product</TABLE>
</CMS_INCLUDE_OPTIONS>
<LANGINFOS>
<LANGINFO lang="*" label="Product"/>
</LANGINFOS>
</CMS_INPUT_LIST>
The PARAM for the QUERY is set dynamically via rules.
<RULE>
<IF>
<NOT>
<PROPERTY name="EMPTY" source="st_cat"/>
</NOT>
</IF>
<WITH>
<PROPERTY name="VALUE" source="st_cat"/>
</WITH>
<DO>
<PROPERTY name="query.catId" source="st_prod"/>
</DO>
</RULE>
This works fine at the moment.
The desired change:
The products selected now need to be ordered manually for the output.
While CMS_INPUT_LIST allows rearranging of the selected items via Drag&Drop, this order is reset once the template is closed (is this a bug?). See:
Re: Anzeige (Sortierung) in CMS_INPUT_LIST
FS_INDEX doesn't allow manual ordering and I also didn't get the dynamic query to work. See:
FS_INDEX dynamisch query param setzen
FS_INDEX-Sortierung (für DatasetDataAccessPlugin) ermöglichen
FS_LIST (I am aware that it will be deprecated) allows manual ordering, but does not accept a dynamic query. See:
Dynamische Befüllung eines Querys über eine Regel
Re: Formular Comboxbox Database Query Param setzen
So my question is: is there no way to
- prefilter datasets based on a category
- select some of the remaining datasets
- manually change the order of the selected datasets?
Sorry for the long post and thanks for any help.
Cheers,
Andreas
