1. A system comprising: a computing device comprising: a memory storing processor-executable program code; and a processor to execute the processor-executable program code in order to cause the computing device to: receive a request conforming to a modeled query and join filter criteria associated with join conditions, the request comprising a first subrequest associated with a text search result item list and a second subrequest associated with an analytical view and a table for data of the analytical view; receive, via a get service, a query ID associated with the modeled query; retrieve metadata associated with the query ID to be transmitted to a user, the metadata generated by a database administrator; transmit the modeled query based on the metadata to the user; receive an additional join filter from the user wherein the additional join filter comprises additional join filter criteria and is based on the received modeled query; define a join between the text search result item list and the table, the join associating one or more attributes of the text search result item list with one or more facets of the table, wherein definition of the join comprises embedding of the text search result item list into the table; receive search results corresponding to the text search result item list; and filter the search results and a result set of data of the analytical view based on the join, the join filter criteria and on the additional join filter criteria.