Get Resources Filtering

15 Posts

glenwith1n Reply #1, 15 years, 10 months ago

I have the below ditto call in evolution and want to use getResources in Revolution to do the same but can’t get it to work to filter my results for products priced between price a & price b.

[[Ditto? &startID=`18` &depth=`3` &tpl=`product_list` &display=`all` &hideFolders=`2` &filter=`product_price,10.00,6|product_price,19.99,5` &sortBy=`product_price` &sortDir=`ASC`&noResults=`product_empty` &summarize=`15` &paginate=`1` &paginateAlwaysShowLinks=`1` ]]

Or if anyone has another way of doing it please let me know.

390 Posts

odeclas Reply #2, 15 years, 10 months ago

I think you’d have to use the &where parameter - but I’m afraid I don’t know how to query a tv in that kind of structure (presumably a join on id to the tvs table). Have a look at the last two examples:

http://rtfm.modx.com/display/ADDON/getResources#getResources-Examples

Writer > E-consultant > MODx developer || Salesforce || modx 2.x || PHP 5.2.13 || MySQL client 5.0.86

☆ A M B ☆
3,141 Posts

Mark Hamstra Reply #3, 15 years, 10 months ago

I think &tvFilters actually comes closer in this case.

But I think that only supports matching with strings. (foo==bar||bar==foo)

Perhaps worth a feature request?

Mark Hamstra • Developer spending his days working on Premium Extras and a MODX Site Dashboard with the ability to remotely upgrade MODX and extras to make the MODX world a little better.

Tweet me @mark_hamstra, check my infrequent blog at markhamstra.com, my slightly more frequent ramblings at MODX.today or see code at Github.