This is driving me crazy:
Link::Manager
$results= $class->get_useraccount_link(
with_objects=> [ 'privacy_override__subordinates'],
query=> [
useraccount_id=> $args{'useraccount_id'}, #get
all the links for
this user
is_deleted=> 0, # of course, it can't be deleted
id=> { ne=> $args{'item_id'} }, # but don't get
the one we're
looking at right now
],
db=> $args{'db'},
);
that SQL is fine, but I need to expand the WHERE to include:
AND (
( privacy_override__subordinates.link_id__viewed <> ? )
OR
( privacy_override__subordinates.link_id__viewed IS
NULL )
)
% ( $args{'link_id'} )
I can't seem to figure out how to structure the OR into the where, or
test for is null
every time i use the or=> keyword , i get a WHERE ( ) , which kills
the query
the only rose info i found concerning null is not_null=> bool , in
the table definitions
anyone have a pointer?
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/rose-db-object
