SELECT Saved_Searches.* ; FROM mmviscollect!saved_searches ; WHERE Saved_searches.cusgrlink_fk == ( ?vp_cusgrlink_fk ); OR (Saved_searches.cusgrlink_fk == ( ?vp_vcam_fk ) ; AND NOT EXISTS(SELECT * FROM mmviscollect!saved_searches ; WHERE Saved_searches.cusgrlink_fk == ( ?vp_cusgrlink_fk ))); ORDER BY Saved_searches.isequence_numberYour first query produced an error message "QUERY of this sort is not supported" (I'm running 8.0)
>>CREATE SQL VIEW LV_SAVED_SEARCHES AS ; >>SELECT Saved_searches.* ; >> FROM mmviscollect!saved_searches ; >> WHERE Saved_searches.cusgrlink_fk = ( ?vp_cusgrlink_fk ) ; >> OR Saved_searches.cusgrlink_fk = ( ?vp_vcam_fk ) ; >> ORDER BY Saved_searches.isequence_number>>
>CREATE SQL VIEW LV_SAVED_SEARCHES AS ; >SELECT Saved_Searches.* ; > FROM mmviscollect!saved_searches ; > WHERE Saved_searches.cusgrlink_fk = ( ?vp_cusgrlink_fk ); > OR Saved_searches.cusgrlink_fk = ( ?vp_vcam_fk ) ; > AND ?vp_cusgrlink_fk NOT IN (SELECT * FROM mmviscollect!saved_searches); > ORDER BY Saved_searches.isequence_number >