Searching a thing via another thing

[dbenade]

Hi,

I have two things, Quote and Quote_Items. These things has many fields but of importance is the following that relate:
Quote: quote_id, user (user is type User)
Quote_Items: quote_id, number-value (quote_id is type Quote)

I would like to search the total sum value of all number-values, of the quotes created by current user.

I’ve tried to use a searches within more searches but expected result is a single quote and not lists of quotes.
How do I approach this differently?

[adamhholmes]

one option: Do a search for Quote_Items who’s Quote is in a search for Quotes who’s User is the Current User

or 2

Do a Search For Quote_Items created by the Current User (assuming thy are the creator - if not, add a User field to the Quote_Item)

[dbenade]

Thanks for the quick response @adamhholmes
I would prefer not to change the things by adding new fields. So option one.

However it evaluates to a list of quotes:

[adamhholmes]

You’re using quote_id = Search for Quotes (which means you must define a single quote.)

you need to use quote_id is in Search for Quotes