Hi @alex_colombo
Below you can find the code I am using in Python to get all the unlocked combinations of 3 fields inside an Application. The problem is that I get 60% more that the actual number of valid combinations.
Would appreciate your guidance on what are the methods and what the proper sequence of requests is to get all the combinations of unlocked values. I should mention that the number of valid options for one field changes according to a selection made in the previous one.
To get the field values, inside the get_field_values() function, I use 2 Methods: "GetField" and "GetFieldAndColumnSamples" which correctly return all the possible options for a specific field (locked and unlocked).
Thanks a lot for your help
-------------------------------------------------------------------------------------------
def send_request(ws, request_id, method, params=None, handle=-1):
if params is None:
params = {}
request = {
"jsonrpc": "2.0",
"id": request_id,
"method": method,
"handle": handle,
"params": params
}
ws.send(json.dumps(request))
response = ws.recv()
return json.loads(response)
ws = websocket.create_connection(url,
sslopt=certs,
header={"X-Qlik-User": "UserDirectory=...; UserId=..."})
#define the fields to be selected
selection_fields = ['field_name_01', 'field_name_02', 'field_name_03']
# get the list of applications
send_request(ws, request_id, "GetDocList")
app_list_response = ws.recv()
request_id += 1
# sift through the list of apps to find the target app
doc_list = output_doc_list(app_list_response)
app_id = [doc[1] for doc in doc_list if compare_strings(doc[0], "Application Name")]
# Open the app
app_handle_response = send_request(ws, request_id, 'OpenDoc', {'qDocName': app_id[0]})
app_handle = app_handle_response['result']['qReturn']['qHandle']
request_id += 1
# create a list containing a tuple made of the name, handle and available values for each field
fields_list = []
for field_name in selection_fields:
field_handle, field_values = get_field_values(field_name, request_id)
fields_list.append((field_name, field_handle, field_values))
field_name_01, field_handle_01, field_values_01 = fields_list[0]
field_name_02, field_handle_02, field_values_02 = fields_list[1]
field_name_03, field_handle_03, field_values_03 = fields_list[2]
# find out all valid combinations of the 3 selection fields
for field_value_01 in field_values_01:
clear_field = send_request(ws,
request_id,
"Clear",
[],
field_handle_01)
request_id += 1
select_field_response_01 = send_request(ws,
request_id,
"Select",
{"qMatch": field_value_01,
"qSoftLock": False
},
field_handle_01
)
request_id += 1
select_valid_01 = select_field_response_01['result']['qReturn']
if select_valid_01:
combination.append(field_value_01)
for field_value_02 in field_values_02:
clear_field = send_request(ws,
request_id,
"Clear",
[],
field_handle_02)
request_id += 1
select_field_response_02 = send_request(ws,
request_id,
"Select",
{"qMatch": field_value_02,
"qSoftLock": False
},
field_handle_02
)
request_id += 1
select_valid_02 = select_field_response_02['result']['qReturn']
if select_valid_02:
combination.append(field_value_02)
for field_value_03 in field_values_03:
clear_field = send_request(ws,
request_id,
"Clear",
[],
field_handle_03)
request_id += 1
select_field_response_03 = send_request(ws,
request_id,
"Select",
{"qMatch": field_value_03,
"qSoftLock": False
},
field_handle_03
)
request_id += 1
select_valid_03 = select_field_response_03['result']['qReturn']
if select_valid_03:
combination.append(field_value_03)
unlocked_combinations.append(combination.copy())
combination.pop()
request_id += 1
combination.pop()
request_id += 1
combination.pop()
[print(f"{comb}\n") for comb in unlocked_combinations]
ws.close()
