virtualgadjo Posted July 15, 2022 Share Posted July 15, 2022 Hi, i confess, i have very baaaad habits and being a db freak doens't help getting rid of them but i try hard, i swear ? so, i'm working on a website with around 60, say, debates there are around 200 speakers in each debate template there is a field (deb_inter) to assign its speakers, more often several than one then, as you can guess, the field is a multiple page reference field, so far, full pw ? now, on each speaker page i need to display the debate(s) he/she is assigned to and if i try something like this $pages->find('template=adebate, deb_inter*=' . $page->id); guess, i get an error saying that *= is not implemented for fieldtypepage, i knew it but i couldn't help trying once more... ? i've searched the docs once more (i think, i'll end knowing them by heart :)), searched the forum too but couldn't find a simple and pw way to do this, well say as simple as this $qi = $database->query("select pages_id from field_deb_inters where data = $page->id"); which does exactly what i'm looking for (even if returning only pages id instead of a pw array), baaad habits, told you ? but, as i'd like to die a little less dumb every day, i'm wondering, is there a more pw way to do this kind of selection with pw selectors and for any kind of field containing a pw array instead of a string/number thanks in advance for your ideas helping an old guy getting a little less dumb ? have a nice day Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now