Apologies if this is documented somewhere but despite searching I cannot find it.
Is there support through the API, such as getRecordsByFilter(), where you can filter using the SQL equivalent of LIKE?
e.g. SELECT * FROM Mockpatients WHERE Surname LIKE ‘S%’;
At the moment it seems you are limited to: SELECT * FROM Mockpatients WHERE Surname=“Smith”
In essence what I want to be able to do is be able to return records beginning with “S” or “Sm*” etc. from a Surname field. As far as I can tell at the moment you have to put in the exact match.
If it is not supported, has anyone implemented something like this (pardon the pun) and if so can point me in the right direction.
Grant D. VAllance