Query filter cannot be specified on a query that are split into multiple queries dues to 1:n fetch mode.

(0) Share

Report

Posted on by On-Hand Inventory I...

120

Hi,

I would like to add this field (ProdTable).modSalesIdRef to this Report InventTransferReceive.report , I have added those two tables InventTransferLine , and ProdTable to the query as the following in the shots :

And the Fetch Mode 1:n has been set in both tables ,and I am getting this error

"Query filter cannot be specified on a query that are split into multiple queries dues to 1:n fetch mode."

after adding those tables to the Query Report.

Best regards

Jamil

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Mea_ 60,284 on at

Like (1)

Report

So why not to set fetch mode 1:1 ?

Was this reply helpful? Yes No
On-Hand Inventory I... 120 on at

Like (0)

Report

Hi ievgen,

I have changed set fetch mode 1:1

the same result I am getting

Best Regards

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi,

I tried in my system. its not giving any error!

Was this reply helpful? Yes No
On-Hand Inventory I... 120 on at

Like (0)

Report

Hi Suresh,

What is the set fetchmode in all the tables in my system it is set to 1:n

but this error is not occur in when I compile the query, it is occur when I run the report of the transfer order that is InventTransferReceive.Report

Best regards

Jamil

Was this reply helpful? Yes No
Zain Bokhari 3,208 Moderator on at

Like (0)

Report

That is because you have added a parallel datasource in Query, you have added InventTransferLine besides InventDim under inventTransferJourLine.

That means the query will be divided into two branches from this point so it will not allow you to add all of the filters.

Please discuss with someone for what you actually need this query to do.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

Still you are facing the error?

Was this reply helpful? Yes No
On-Hand Inventory I... 120 on at

Like (0)

Report

Hi Zain,

Actually I would like to retrieve and display sales order that is   (ProdTable).modSalesIdRef field which is present in the prodTable

and the link between InventTransferLine table    And the InventTransferJourLine.TransferId as the following InventTransferJourLine.TransferId == InventTransferLine.TransferId

and the like between InventTransferLine table    and the ProdTable as the following:

ProdTable.ProdId == InventTransferLine.ProdId

That is why I have to use InventTransferLine Can I use the InventDim table with ProdTable and the relation between them as the following

ProdTable.InventDimId==InventDim.inventDimId do you think it will work as I want it.

Best Regards

Jamil

Was this reply helpful? Yes No
On-Hand Inventory I... 120 on at

Like (0)

Report

Good morrning Suresh,

Yes still the report is giving error

Thanks

Jamil

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

Can you please explain some more about your question, if possible with screen shots. It will be easy to analyze. In my case it is not showing any error.

Was this reply helpful? Yes No
On-Hand Inventory I... 120 on at

Like (0)

Report

Hi Suresh

I want to add Sales Order field from ProdTable to this Report InventTransferReceive.report as I have explain to Mr. Zain Bokhari's, when I add those two tables InventTransferLine , ProdTable to the relation of the report I am getting this error

Best regards

Jamil

Was this reply helpful? Yes No