I am using a remote table to temporarily grab records from GLM.
GLM is where they currently store clients location, some of their locations are in ServiceNow, some are not because its missing a specific code - when the code gets generated it creates a record from ServiceNow.
The goal is to grab all child (SL) from a specific parent (PL) location
Were using this function to update an Order Line location. Below is the UX we have for updating Location.
If the Location (ServiceNow) doesnt exist, then they can grab a location from GLM Location (Remote)
fig.1
I am passing the Locations PL to the GLM Location
Master site id (PL) is a field in the GLM Location table
u_glm_id = is a number for SL0001 or PL0001
For this test, I am using a parent location = this is not the final code for ref qual.
fig.2
Line 12 I mainly use to test if I can grab the records.
Line 3 where I grab the condition from fig.2
Test 1 = Line 12 is working, if I navigate directly to the remote table - It populates the remote table
Test 2 = Line 12 doesnt work if I navigate from Reference table - It does not populate the remote table
- For it to work in Reference table, I have to remove the condition in fig.2
- I have to comment out line 3
I need to make Test2 work - I need it as a reference field.
fig.3
Any ideas?
Thank you,
Jamie
