Migrate from retrieveQuery to asQuery - object type returned from asQuery not accepted where object type returned from retrieveQuery is accepted.

[davidAtInleague]

quick 6.2.1

The following example demonstrates a pattern of using Quick to build some (arbitrarily complicated and reusable) where clause, and then using that clause to drive a QB whereIn.

The result of retrieveQuery has been (and remains) fine here, but using the result of asQuery throws an exception.

getInstance("QueryBuilder@qb")
	.from("some_other_table")
	// ok
	.whereIn("ID", getInstance("User").someFilterScope().retrieveQuery().reselect("ID") )

	// fails with:
	// Invalid call of the function [compileSelect],
	// first Argument [query] is of invalid type,
	// Cannot cast Object type [Component quick.models.QuickBuilder] to a value of type [QueryBuilder]
	.whereIn("ID", getInstance("User").someFilterScope().asQuery().reselect("ID") )
	.get()

[elpete]

Ah. I see why. You are passing a QuickBuilder instance into a QueryBuilder instance. It would work if they were both QuickBuilder instances.

I’m not sure how possible it will be to support passing in a QuickBuilder to a QueryBuilder. This seems like a place where retrieveQuery is probably the right option, but I’ll keep this issue open in case inspiration strikes.