Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/11/2024 03:39 AM
Hello,
i need to get the phone number with two filters from workday, first i want to filter on :
Communication_Usage_Type_ID">WORK & "Phone_Device_Type_ID">Landline
Example :
Solved! Go to Solution.
06/11/2024 05:11 AM
"PHONENUMBER": "Worker_Data.Personal_Data.Contact_Data.Phone_Data[(Usage_Data->Type_Data->Type_Reference->ID=='WORK') and (Phone_Device_Type_Reference->ID=='Landline')].@E164_Formatted_Phone"
06/12/2024 12:04 AM
Hello,
i tried those two they didn't work :
"SECONDARYPHONE": "Worker_Data.Personal_Data.Contact_Data.Phone_Data[(Usage_Data->Type_Data->Type_Reference->ID=='WORK') and (Phone_Device_Type_Reference->ID=='Landline')].@E164_Formatted_Phone"
"SECONDARYPHONE": "Worker_Data.Personal_Data.Contact_Data.Phone_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK' and Phone_Device_Type_Reference->ID=='Landline').@E164_Formatted_Phone"
Any other ideas please? @rushikeshvartak
Regards,
Ray
06/12/2024 10:37 AM
@ray try below
"SECONDARYPHONE": "Worker_Data.Personal_Data.Contact_Data.Phone_Data[Usage_Data.Type_Data.Type_Reference.ID=='WORK' and Phone_Device_Type_Reference.ID=='Landline'].@E164_Formatted_Phone"
06/14/2024 02:37 AM
@Raghu it didn't work, i think the operator and is not understood by saviynt
08/28/2024 06:59 AM
This issue resolved or still persistent?
08/28/2024 08:24 AM
Hello Raghu, no it was not resolved, they didn't work
08/28/2024 07:34 PM - edited 08/28/2024 07:35 PM
@ray
Can you try the below.
"PHONENUMBER": "Worker_Data.Personal_Data.Contact_Data.Phone_Data(Usage_Data->Type_Data->Type_Reference->ID=='WORK' && Phone_Device_Type_Reference->ID=='Landline').@E164_Formatted_Phone"
"PHONENUMBER": "Worker_Data.Personal_Data.Contact_Data.Phone_Data[Usage_Data/Type_Data/Type_Reference/ID='WORK' and Phone_Device_Type_Reference/ID='Landline'].@E164_Formatted_Phone"