Is there a trick to doing a search on a Date attribute, on a query, that is a shortcut to another BO?
Here is what I have...
Names BO that has a DOB shortcut that is coming from a Client File.
The attributes are:
AlsoKnownAs, Text
IsAka, Yes/No
parent_Client ---> ClientMaster
ClientDOB, shortcut to ClientMaster.DateOfBirth
ClientPhone shortcut to ClientMaster.PhoneNumber
ClientGender shortcut to ClientMaster.Gender
This is basically setup so that a Client can have any number of names that they might use.
Among numerous other fields the Client BO has ClientID, PrimaryName, DateOfBirth, child_Names (Multiple allowed), etc...
If I have a query for the Client BO, I can do a search on the DOB and it works just fine.
But, when I have the DOB shortcut on a Query for my Name BO, when I do a search on it I get nothing.
I can do searches on the Gender and Phone shortcuts just fine, it is just the date one that does not seem to work.
Is there something I am missing?