Case sensitive query in Wakanda db

Question

I am working with an external system that uses case sensitive keys. To simplify, lets say ID 'a1' and 'A1' represent two different entities. I need to find the entity by external ID but query and find methods are not case sensitive in Wakanda so it finds both (or possibly wrong) entities when I query/find. Any Ideas?

ds[dataClassName].query("externalID == :1","a1");

I want to find one (correct) entity not two as this code does.

score 1 · Answer 1 · answered Apr 24 '17 at 14:20

1

Unfortunately in the current implementation of Wakanda, queries are NOT case sensitive.

Fred

answered Apr 24 '17 at 14:20

FrédéricG

66
5

ScottE · Answer 2 · 2017-04-25T15:24:26.523

0

I found that the indexOf() method is case sensitive and I have an auto sequenced ID and external ID for each prospect so the following will find the correct entity. Probably very inefficient. Any improvements?

var x = ds.Prospect.query('externalID == a1');
var i = x.externalID.indexOf('A1');
x[i];

edited Apr 25 '17 at 15:24

answered Apr 25 '17 at 05:57

ScottE

31
6

score 0 · Accepted Answer · answered Apr 25 '17 at 15:23

0

You could create a sensitiveQuery() dataclass method that does a query() inside and then filter the query result with an indexOf and returns the correct entity. A ds.Prospect.sensitiveQuery() would do the trick.

answered Apr 25 '17 at 15:23

Yann

478
5
10

Case sensitive query in Wakanda db

3 Answers3