Pega Robotics Studio 8: case sensitive key lookups with LookupTable
When using GetRecord on a Lookup Table, matching of the key appears to be case insensitive.
Is there a way to use LookupTable with case sensitive keys?
***Updated by moderator: Lochan to add Categories***
Accepted Solution
Pegasystems Inc.
JP
Hi Jeff,
thanks for the reply - I managed to get the desired behaviour with the following automation.
That said, I never figured out what the "chkCase" controls you had in your automation meant, nor where they came from. Would you be able to enlighten me? Furthermore, what does dataTableProxy actually do - I had thought it created a copy of the original table with a different scope but this does not appear to be the case?
Pegasystems Inc.
US
By default the underlying data table in the Lookup Table is not case sensitive. If you do a GetTable and then change the CaseSensitive property you can change this behavior. It will persist through the life of your project.
Accepted Solution
Pegasystems Inc.
JP
Hi Jeff,
thanks for the reply - I managed to get the desired behaviour with the following automation.
That said, I never figured out what the "chkCase" controls you had in your automation meant, nor where they came from. Would you be able to enlighten me? Furthermore, what does dataTableProxy actually do - I had thought it created a copy of the original table with a different scope but this does not appear to be the case?
Pegasystems Inc.
US
I should have explained better. To solve your issue I created a windows form with a checkbox. The sample automation is just changing the case sensitivity of the lookup table based on the CheckChanged event in the automation. What you have here is exactly correct.
A proxy provides you access on the design surface to the underlying object. In this case, the LookupTable component wraps a DataTable. By extracting a proxy from the GetTable method you get access to the DataTable that is inside of the LookupTable. Once you have access to the DataTable you can then change basic properties such as CaseSensitive.