itel  Family

 Forgot password?
Hot search: itel ifamily
View: 371|Reply: 0

[Other] iBase Query Not Working Correctly?

[Copy link]







Full Member

Rank: 3Rank: 3

Post time 2017-11-25 19:45:53 | Show all posts |Read mode
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.
References ... c0967a0ec&ps=50
product marketing ads


Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Archiver|Mobile|Dark room|itel Inc.

2018-12-13 10:06 GMT+8 , Processed in 1.609837 second(s), 20 queries .

Copyright @ 2016 Itel Inc. All rights reserved.

Quick Reply To Top Return to the list