Im trying for so many days to usa the values stored in a field as values to search for in anoter subset of a multi search without any luck, I hope I am making myself understood.
What I want to do:
1) store the IDS from the first search and saved them in a field named START 2) use all the IDS I have in the field START to run another search which requires the field id_user
what Im doing:
[|search index="medi" AND bloodp="high" AND id_user=* AND facility=5 | eval START=id_user]
[|search index="medi" AND bloodp="high" AND id_user=START AND facility=6 AND trx=* | eval treatmentchose=trx]
I cannot seem to be using the ids in facility 5 to search for the medication that was giving to the patient in facilty 6 by using the IDS that I stored in the field START, can someone please please help me?