This is more than likely easy for most ListX users! but for some reason I'm having trouble getting it to work. I simply have 2 ListX mods 1.) To filter by artist and 2.) to display gallery/All by default and by artist when selected in dropdown.
I have included the XML files for both,
The Filter Module is as follows:
<?xml version="1.0" encoding="utf-16"?>
<xListSettings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<recordsPerPage>0</recordsPerPage>
<enableAlphaFilter>false</enableAlphaFilter>
<enablePageSelection>false</enablePageSelection>
<enableRecordsPerPage>false</enableRecordsPerPage>
<enableCustomPaging>false</enableCustomPaging>
<enableExcelExport>false</enableExcelExport>
<enableHide_OnNoQuery>false</enableHide_OnNoQuery>
<enableHide_OnNoResults>false</enableHide_OnNoResults>
<enableAdvancedParsing>true</enableAdvancedParsing>
<enableCompoundIIFConditions>true</enableCompoundIIFConditions>
<enableQueryDebug>false</enableQueryDebug>
<enableQueryDebug_Edit>false</enableQueryDebug_Edit>
<enableQueryDebug_Admin>false</enableQueryDebug_Admin>
<enableQueryDebug_Super>true</enableQueryDebug_Super>
<enableQueryDebug_Log>false</enableQueryDebug_Log>
<enableQueryDebug_ErrorLog>false</enableQueryDebug_ErrorLog>
<autoRefreshInterval />
<skipRedirectActions>false</skipRedirectActions>
<skipSubqueryDebugging>false</skipSubqueryDebugging>
<enableAdmin_Edit>true</enableAdmin_Edit>
<enableAdmin_Admin>false</enableAdmin_Admin>
<enableAdmin_Super>false</enableAdmin_Super>
<enableAJAX>false</enableAJAX>
<enableAJAXCustomPaging>false</enableAJAXCustomPaging>
<enableAJAXCustomStatus>false</enableAJAXCustomStatus>
<enableAJAXManual>false</enableAJAXManual>
<includeJavascriptUtilities>false</includeJavascriptUtilities>
<includeJavascriptValidation>false</includeJavascriptValidation>
<javascriptOnComplete />
<enableMultipleColumnSorting>false</enableMultipleColumnSorting>
<ModuleCommunicationMessageType />
<showAll>false</showAll>
<useExplicitSystemVariables>false</useExplicitSystemVariables>
<enabledForcedQuerySplit>false</enabledForcedQuerySplit>
<searchItems />
<queryItems>
<anyType xsi:type="QueryOptionItem">
<Index>0</Index>
<VariableType><form>></VariableType>
<QuerySource>fltArtistName</QuerySource>
<QueryTarget>@ArtistName_Filter</QueryTarget>
<QueryTargetLeft>cArtist'</QueryTargetLeft>
<QueryTargetRight>%'</QueryTargetRight>
<QueryTargetEmpty>1=1</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>1</EscapeListX>
</anyType>
</queryItems>
<listItems />
<messageItems />
<query />
<filter />
<customConnection>Provider=sqloledb; Data Source=10.234.73.68; Initial Catalog=parkwest; User Id=parkwestadmin; Password=08parkwest08</customConnection>
<listItem />
<listAItem />
<defaultItem />
<noqueryItem><table>
<tr>
<td>
<select name="lstflt_cArtist" id="lstflt_cArtist" onchange="lxFetch([ModuleId,System],0,'');">
<option value=''>Select </option>
{SUBQUERY,
name="lstflt_cArtist",
Query="SELECT DISTINCT cArtist from Inventories I
INNER JOIN Inventory_Event_Links L On L.iInventories_id = I.iid
where iEVents_id = 97",
FORMAT="<option value='[cArtist]'>[cArtist]</option>",
SELECTEDFORMAT="<option value='[cAtrist]' selected="selected">[cArtist]</option>",
SELECTEDFIELD="cArtist", SELECTEDITEMS="[FORMAT,[fltArtistName,Form],{ISEMPTY:0}]",UseCache=False"}</select>
</td>
</tr>
</table>
</noqueryItem>
<SearchQuery />
<SearchTitle />
<SearchLink />
<SearchAuthor />
<SearchDate />
<SearchKey />
<SearchContent />
<SearchDescription />
<Version>17</Version>
</xListSettings>
and the Gallery Module is as follows:
<?xml version="1.0" encoding="utf-16"?>
<xListSettings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<recordsPerPage>12</recordsPerPage>
<enableAlphaFilter>false</enableAlphaFilter>
<enablePageSelection>false</enablePageSelection>
<enableRecordsPerPage>false</enableRecordsPerPage>
<enableCustomPaging>false</enableCustomPaging>
<enableExcelExport>false</enableExcelExport>
<enableHide_OnNoQuery>false</enableHide_OnNoQuery>
<enableHide_OnNoResults>false</enableHide_OnNoResults>
<enableAdvancedParsing>true</enableAdvancedParsing>
<enableCompoundIIFConditions>false</enableCompoundIIFConditions>
<enableQueryDebug>false</enableQueryDebug>
<enableQueryDebug_Edit>false</enableQueryDebug_Edit>
<enableQueryDebug_Admin>false</enableQueryDebug_Admin>
<enableQueryDebug_Super>true</enableQueryDebug_Super>
<enableQueryDebug_Log>false</enableQueryDebug_Log>
<enableQueryDebug_ErrorLog>false</enableQueryDebug_ErrorLog>
<autoRefreshInterval />
<skipRedirectActions>false</skipRedirectActions>
<skipSubqueryDebugging>false</skipSubqueryDebugging>
<enableAdmin_Edit>true</enableAdmin_Edit>
<enableAdmin_Admin>false</enableAdmin_Admin>
<enableAdmin_Super>false</enableAdmin_Super>
<enableAJAX>true</enableAJAX>
<enableAJAXCustomPaging>false</enableAJAXCustomPaging>
<enableAJAXCustomStatus>false</enableAJAXCustomStatus>
<enableAJAXManual>false</enableAJAXManual>
<includeJavascriptUtilities>false</includeJavascriptUtilities>
<includeJavascriptValidation>false</includeJavascriptValidation>
<javascriptOnComplete />
<enableMultipleColumnSorting>false</enableMultipleColumnSorting>
<ModuleCommunicationMessageType />
<showAll>false</showAll>
<useExplicitSystemVariables>true</useExplicitSystemVariables>
<enabledForcedQuerySplit>false</enabledForcedQuerySplit>
<searchItems />
<queryItems>
<anyType xsi:type="QueryOptionItem">
<Index>0</Index>
<VariableType><form>></VariableType>
<QuerySource>lstflt_cArtist</QuerySource>
<QueryTarget>@cArtist_Filter</QueryTarget>
<QueryTargetLeft>'%</QueryTargetLeft>
<QueryTargetRight>%'</QueryTargetRight>
<QueryTargetEmpty>1=1</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>1</EscapeListX>
</anyType>
</queryItems>
<listItems>
<anyType xsi:type="ListFormatItem">
<Index>0</Index>
<GroupStatement />
<ListHeader><table align="center" width="800px" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
</ListHeader>
<ListFooter>{ALTERNATE,”quadRowsEnd”,,,,}
</td>
</tr>
</table></ListFooter>
</anyType>
</listItems>
<messageItems>
<anyType xsi:type="MessageActionItem">
<Index>0</Index>
<ActionType />
<ActionInformation />
<Level>0</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>1</Index>
<ActionType>Condition-If</ActionType>
<ActionInformation>7:22;1;8;'[Action,QueryString]'='Filter'</ActionInformation>
<Level>0</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>2</Index>
<ActionType>Action-Execute</ActionType>
<ActionInformation>9:6;23;5;0;DeleteDELETE FROM WHERE =@ False</ActionInformation>
<Level>1</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>3</Index>
<ActionType>Action-Assignment</ActionType>
<ActionInformation>12:9;28;21;5;1;<Session>filter[TABID,SYSTEM]_cArtist[lstflt_cArtist,Form]False0</ActionInformation>
<Level>1</Level>
</anyType>
</messageItems>
<query>select I.* from Inventories I
INNER JOIN Inventory_Event_Links L On L.iInventories_id = I.iid
where iEVents_id = 97</query>
<filter />
<customConnection>Provider=sqloledb; Data Source=10.234.73.68; Initial Catalog=parkwest; User Id=parkwestadmin; Password=08parkwest08</customConnection>
<listItem>{ALTERNATE,”quadRowsStart”,<tr>,,,}
<td><table align="center" border="0" cellspacing="5" cellpadding="5" width="100%"><tr>
<td nowrap><center><img src="http://sales.parkwestgallery.com/user_area/art/thumb/[cImage]"></center><br>
<font size='2' face='Arial, Helvetica, sans-serif'><b>[cTitle]</b></font><br>
<font size='2' face='Arial, Helvetica, sans-serif'><em>[cArtist]</em></font><br>
<font size='2' face='Arial, Helvetica, sans-serif'>[cSize]</font><br>
<font size='2' face='Arial, Helvetica, sans-serif'>[cLot_Num]</font><br>
<font size='2' face='Arial, Helvetica, sans-serif'>[cReg_Num]</font><br>
</td></tr></table></td>
{ALTERNATE,”quadRowsEnd”,,,,</tr>}
</listItem>
<listAItem />
<defaultItem />
<noqueryItem />
<SearchQuery />
<SearchTitle />
<SearchLink />
<SearchAuthor />
<SearchDate />
<SearchKey />
<SearchContent />
<SearchDescription />
<Version>17</Version>
</xListSettings>
any assistance with this matter would truely be appreciated.