# Strange problem with filtered cloned source

**URL:** https://talk.remobjects.com/t/strange-problem-with-filtered-cloned-source/28160
**Category:** Data Abstract
**Tags:** delphi
**Created:** [April 4, 2023, 5:02am UTC](https://talk.remobjects.com/t/strange-problem-with-filtered-cloned-source/28160 "2023-04-04T05:02:05Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![mijndesign](https://talk.remobjects.com/letter_avatar_proxy/v4/letter/m/97f17d/32.png) [@mijndesign](https://talk.remobjects.com/u/mijndesign)
#### Post date: [April 4, 2023, 5:02am UTC](https://talk.remobjects.com/t/strange-problem-with-filtered-cloned-source/28160/1 "2023-04-04T05:02:05Z")

</div>

I’m working on transforming FireDac based queries to DA.

First I added a TDAMemDataTable “qry\_rights\_user” and set a filter, with Codesite the result set was tested, all ok.

Another table "qry\_right"was added with cloned source set to “qry\_rights\_user” and a method used this  
table to filter by field “df\_id”.  
It seemed to work but realized that one filter failed although a record exists with the df\_id it says qry\_right.isEmpty = true.

I am lost … but I try to setup a minimal example for testing.

---

<div class="post-metadata">

### Author: ![EvgenyK](https://talk.remobjects.com/user_avatar/talk.remobjects.com/evgenyk/32/16_2.png) [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [April 4, 2023, 6:25am UTC](https://talk.remobjects.com/t/strange-problem-with-filtered-cloned-source/28160/2 "2023-04-04T06:25:50Z")

</div>

Hi,

Can you review the [Cloned Source sample (desktop) (Delphi)](https://docs.dataabstract.com/Delphi/Samples/ClonedSource/Desktop/) , pls?

---

<div class="post-metadata">

### Author: ![mijndesign](https://talk.remobjects.com/letter_avatar_proxy/v4/letter/m/97f17d/32.png) [@mijndesign](https://talk.remobjects.com/u/mijndesign)
#### Post date: [April 4, 2023, 10:39am UTC](https://talk.remobjects.com/t/strange-problem-with-filtered-cloned-source/28160/3 "2023-04-04T10:39:47Z")

</div>

I worked through that sample weeks ago before starting to use cloned sources.

Everything works fine, just this one table with one record showing wrong data and I have no clue yet why but am working on it.

---

<div class="post-metadata">

### Author: ![EvgenyK](https://talk.remobjects.com/user_avatar/talk.remobjects.com/evgenyk/32/16_2.png) [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [April 5, 2023, 12:34pm UTC](https://talk.remobjects.com/t/strange-problem-with-filtered-cloned-source/28160/4 "2023-04-05T12:34:21Z")

</div>

Hi,

I need a simple testcase that reproduced this case …

you can drop it to support@ for keeping privacy

---

<div class="post-metadata">

### Author: ![mijndesign](https://talk.remobjects.com/letter_avatar_proxy/v4/letter/m/97f17d/32.png) [@mijndesign](https://talk.remobjects.com/u/mijndesign)
#### Post date: [April 8, 2023, 6:37pm UTC](https://talk.remobjects.com/t/strange-problem-with-filtered-cloned-source/28160/5 "2023-04-08T18:37:57Z")

</div>

I’m working on it.
