Selector Question: Price!=Retailprice, Is This Possible?

[joer80]

I want to get pages where the price is not empty, and not the same as retail.  So it needs to act on a value I give, and compare itself to another field.  

ie.  Price!=, Price!=RetailPrice

So far, my tests show that the second one does not do anything!

Is this possible?

Thanks!

[diogo]

Not possible, you can only have field names on the left of the operand.

Alternatively you could either find all the pages where price is not empty, and then remove the ones where retail price is the same inside a foreach:

// not tested

$result = $pages->find('Price!=');

foreach ($result as $r) {
    $result->remove($result->get("RetailPrice=$r->Price"));
}

or create a new field that holds the diference of those two fields by hooking on page save to populate it.

[adrian]

Or you can use SQL directly as per Ryan's suggestion to a similar question I had:

https://processwire.com/talk/topic/3053-possible-to-select-modifiedcreated/?p=30093

It always feels dirty to me to query and then truncate

[diogo]

Eheh, I give an example for my second suggestion on that thread, thanks Adrian

Hey diogo - cool idea and a great example of how easy it is to create a module. Looking forward to finding a little time to start creating my own soon.

http://modules.processwire.com/authors/adrian/