Hi - I am wanting to query in real time in my app and provide a list of results from that query based on the inputs.
The system will need to take into account synonyms, and filter based on relationship values between terms (same table relating them).
Should I use separate APIs? One?
Right now I am doing a lot of for loops and it's time intensive. Is this the best / only way?
I tried the 'find array' but I've put the data into an object... but not sure if I should do it directly from the 'relationships' table?
The input is multiple field IDs that need to search through synoym lists. When I use the 'query' database it only allows for a single input. How can I have it check multiple inputs without a loop? A join table? Will this still allow me to do this in real time?
The output is multiple outputs with matches to the input that are re-sorted and categorized.