Williamhawk Publish time 2017-11-25 19:45:53

iBase Query Not Working Correctly?

Hi all,

I have a query in iBase 8.9 that is set to pull out all policy records connected to a person who has a date of birth set to certain dates. I would like this query to only show policy records where the person connects to only one policy.

I have tried amending the query to include Count = 1 however this brings back the same number of results as if the Count = 1 wasn't there, and some of them are still connected to more than one policy?

There are criteria on the policy entity, would that have an effect on it? If I put the count on the policy link, it still brings me back the same results?

Any help appreciated.

Thank You!!!

I didn't find the right solution from the Internet.
product marketing ads

Pages: [1]
View full version: iBase Query Not Working Correctly?