Hello Dojo,
We are encountering an issue on a table where both the Primary Key and Display Key are both numeric and there are instances where a row's DK is another rows PK. I.E.
- PK | DK
- 100 | 200
- 300 | 100
When using the Param placeholder to find row 300/100 using 100 as the row key, we are getting the information for row 100/200. Is there a way to force the param placeholder to only find the row using the DK?
A quick investigation found that Dataminer finds the row using the ^pkordisp^ search, so does that mean that it will return the first row where the value matches the PK or DK? Or does the filter first try and find any rows where the PK match and then tries to find any rows where the DK match?
Many thanks in advance.
The param placeholder supports having a SubscriptionFilter shape data entry on the same shape. With those, you can pretty much subscribe on anything, including explicitly looking for a DK match.