IN query self reference issue?

swiftinitpvtltd

I have below process query
FIND ProductBO WHERE ProductBO.ID IN (another BO multiple ProductBOID's....

Is there any sample of IN query in guide or forum?

PointsWell

You are mixing objects and attributes in your query

Should be

FIND ProductBO where ProductBO in AnotherBO.pmProducts

swiftinitpvtltd

Thanks! It kind of worked but it started doing infinite loop like behavior. The In will have 100+ records.

tford

Thanks! It kind of worked but it started doing infinite loop like behavior. The In will have 100+ records.

If you post the details of what you have + explanation of the BO / attribute relationships, we might be able to help.

swiftinitpvtltd

Thanks tford.
I have a BO
BO1
BO1 contains ProductName and I also have multiselector in the same BO edit form to select same BO names multiple times(discounted products for this product for example). So if I add one products other 3 products are discounted.
Now The IN query is like
FIND BO1 WHERE BO1 IN ThisBO1.ob_DiscountedProducts (ob_DiscountedProducts is multiselector to select discounted products for same BO)

DISPLAY MESSAGE COUNT BO1 WHERE BO1 IN ThisBO1.ob_DiscountedProducts

returns blank.
I do see 3 multichoice values in log if user selects 3 discounted products but above query returns 0

similar issue mentined here-
https://awareim.com/forum/https://www.awareim.com/forum/d/10851>

for me
FIND OrderLines WHERE OrderLines IN ThisOrderLines.ps_LinkToContractorOrderLine
DISPLAY MESSAGE SEARCH_COUNT

swiftinitpvtltd

Now I do see 3 products in batches of 1 FIND query which is good!

But now when I do insert(create) action for another purpose(to insert these 3 in another transaction BO) on this its inserting current(4th) product thrice instead of adding these 3 multiselected products of current product.
I tried
ThisProduct, ThatProduct and Product but its doing it thrice meaning its almost working but not getting those 3 in create.

FIND BO1 WHERE BO1 IN ThisBO1.ob_DiscountedProducts in batches of 1(finds 3 as I have selected 3 in that item edit)
Create BOTrans with (this inserts same current product thrice instead of 3 different products from above query)

customaware

Amit, if you are using the ob_ prefix properly then there is ONLY 1 record.

Very hard to understand what you are trying to achieve......

How about a small diagram or a sample bsv and we might be able to assist

swiftinitpvtltd

Thank Mark. Its now almost working except out of 3 one item is showing blank as I am selecting same product in discounted products list. This is little weird issue.
For now I found a good workaround but there is a issue for sure with self reference BO FIND query(in case you refer same item in multiselector column the find query only finds 2 other items in batch query except the current item-3 items selected in multiselector with one of them as current item).
I will create a BSV in next week to show the issue.