Mar 18 2021 12:54 PM - edited Mar 18 2021 12:56 PM
Hello,
I have
- a table of PROJECTS
- a table of PROJECTMEMBERS
Each PROJECT has a key (PKEY) and a status (STATUS)
Each PROJECT can have one or more PROJECTMEMBERS.
This is done in the table of PROJECTMEMBERS, having a field PKEY containing the value of to the PKEY of the PROJECT in PROJECTS
Each MEMBER has a name (NAME) and company (COMPANY) and city (CITY)
I can configure search so that craweld and managed properties are pointing to the corresponding columns:
PKEY
STATUS
NAME
COMPANY
In dbase terms, it is fairly easy to do a JOIN to show the COMPANIES with PROJECTS with STATUS="done" that have their residence in CITY="myCity"
Can this be done by using search?
The only thing I can think of is
- do a search query STATUS="done"--> gives all PKEYS for those PROJECTS
- do a search query CITY="mycity" --> gives all PKEYS for those PROJECTMEMBERS in that live in mycity
- find the PKEYS that exist in both queries
- do search query PKEY is member of PKEYS --> gives the desired result.
Can this be achieved with KQL (Keyword Query Language)?
I want to make an intelligent search center where the user can use refiners (STATUS, CITY) to find all the PROJECTS that are combining both properties.
any suggestion?
Kind regards,
Bart