>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