I have a field F1 under Project Detail section .It's auto compelete list. It's Multi select too.
I create a request from the Project WF step..This request has another Field F2(Multi select , ACL) .F2 is dependent on F1 ...I want F2 should not show values those are selected in F1 field on project detail section. I tried using the Token of F1 in the query of F2..it's fine for single select..however it is not working for Multi select..We need muti select F1 and F2 both...
F1 and F2 has value for example A, B , C.if A, and B are selected in F1..then it F2 should have only C value to select for example....
Hello Phani, you will need to create a custom SQL validation in the second request type that filters for you. This could something like this:
SELECT lookup_code , meaning , lookup_code FROM knta_lookups WHERE lookup_type = ORIGINAL_VALIDATION' and enabled_flag = 'Y' and UPPER(meaning) like UPPER('?%') and (meaning like upper(substr('?',1,1)) || '%' or meaning like lower(substr('?',1,1)) || '%') and lookup_code not in (select parameterXX from kcrt_request_details/kcrt_req_header_details where request_id = REQUEST_ID_FROM_PROJECT)
I am trying for fields on the same request type then my query is :
SELECT lookup_code, meaning FROM knta_lookups WHERE lookup_type = 'CATO - Impacted Theater List' and enabled_flag = 'Y' AND meaning not in ( '[REQD.VP.IMPACTED_THEATERS.TO_STRING]') and UPPER(meaning) like UPPER('?%') and (meaning like upper(substr('?',1,1)) || '%' or meaning like lower(substr('?',1,1)) || '%') order by seq..
I am getting token is not unparseable....
why to_sting is supporting if both fields are on same req type
You said the field was in the Project Detail section? If that's the case, you should use REQ.P. instead of REQD.P. The OOTB Project Detail is in the Request Header Type, not in the Request Type. This may be why your token is not parsing.