Perform a find through a portal
I have an customer order database where I want to find all orders with the field orderStatus marked 'quoted' but have payment information. The payment information is stored in a serparate table and shown using a portal.
If I do a search for quoted and omit anything in the payment field I get a lot of records I do not want because it returns records with no payment information.
Any help on this would be great.