$pages->get("/features")->find("field1<field2") possible?

[dotnetic]

Hi,

is there a solution to get all pages from my folder "features" where "field1" is smaller than "field2"?

Is this possible with the find API? I tried it, with

echo $pages->get("/features")->find("field1<field2");

but it did not work. Any suggestions how i can achieve this?

Thanks in advance.

Jens

[isellsoap]

Hi there.

I guess

$pages->get("/features")->find("field1<=field2");

should be enough. Check out the selectors section in the API reference.

Edit: Sorry, didn’t read your post right. Hm, it should also work with "<" of course.  Strange.

[dotnetic]

Hi there.

I guess

$pages->get("/features")->find("field1<=field2");

should be enough. Check out the selectors section in the API reference.

Edit: Sorry, didn’t read your post right. Hm, it should also work with "<" of course.  Strange.

Unfortunatly this doesn´t work.

[isellsoap]

Here is explained a solution that should fit your needs.

[dotnetic]

Thanks. That is a solution

[adrian]

It is also very easy to use SQL in these sorts of situations. Have a read of this thread:

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

[nik]

The post isellsoap linked to above has Ryan's explanation on why it's not straightforward to compare two fields - and yes, there's a solution also. But I'd like to propose another solution as well in case you'd need better performance or native pagination (lots of pages for example).

You could add a helper field "f1_f2_difference" and populate it on page save with the difference of field1 and field2 (field2-field1). Then you'd be able to do this:

echo $pages->find("has_parent=/features/, f1_f2_difference>0");

 

There's an example of pretty much the same thing in the final post of this thread and for some more information read also this thread.

But you've got a working solution already so there's probably no need to take this route .

--

@adrian: your suggestion would be fine when the fields are in the same database table (like created and modified are). Here field1 and field2 are presumably custom fields and thus in their own tables. An SQL JOIN would still do it, but using selectors gives the advantage of grants and visibility being taken care of.

[adrian]

nik - true - I should maybe have explained the need for an SQL JOIN. I actually hadn't considered the other benefits of using a selector - good to note, thanks!