itel  Family

 Forgot password?
 Register
Search
Hot search: itel ifamily
View: 50|Reply: 0

[Other] iBase Query Not Working Correctly?

[Copy link]

150

Threads

150

Posts

310

Xpoints

Full Member

Rank: 3Rank: 3

Xpoints
310
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
https://www.ibm.com/developerwor ... c0967a0ec&ps=50
product marketing ads

Reply

Use magic Report

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

Points Rules

Archiver|Mobile|Dark room|itel Inc.

2017-12-15 19:47 GMT+8 , Processed in 0.587633 second(s), 20 queries .

Copyright @ 2016 Itel Inc. All rights reserved.

Quick Reply To Top Return to the list