I am trying to pull some data in a lookup table into a hidden value in my forms so that i can see those values in my reports but its not working. I have used the syntax found in the help site but i cannot seem to get it right. Help please anyone.
Help Site syntax: instance(‘project’)/project_list/project[id = /data/district ]/project_name
My syntax: instance(‘cohort_two_track_one_clients’)/cohort_two_track_one_clients_list/cohort_two_track_one_clients[gender_id = data/client_name]/gender_id