Views Reply Votes
Amanda Rose
Amanda
 1
How to limit a cross-domain browse to certain domains
83
4
0 (0 Votes)
Posted: May 03, 2019   
Votes
John Ruch
John
 62
Replied 

Yes that should work, assuming so_mstr is in your query.  Make sure the OR group is in parenthesis

(so_domain  = "domainname1" or so_domain = "domainname2")

 

0 (0 Votes)
Replied: May 07, 2019
Votes
Amanda Rose
Amanda
 1
Replied 

John, thanks for the reply.  But I had that and still not seeing any impact.  I had amended the main filter to be:

tr_type = "iss-so" and (so_domain = "USD60" or so_domain = "EUR50") - and still saw Sales Orders from other domains

And I had tried tr_type = "iss-so" and (so_domain <> "USD10" and so_domain <> "AUD40") and got a join error

Also, I have treid to add the filter expression within the so_domain column as a filter there like (so_domain = "EUR50" OR so_domain = "FREUR01")

I still see sales orders from all domains

 

0 (0 Votes)
Replied: May 07, 2019
Votes
Yun Han
Yun
 36
Replied 

Hi Amanda,

Could you please check the appserver log of mfg? You can find the file QADMFG_AS.server.xxx under the build/work/logs folder.

You should be able to see the query details.

0 (0 Votes)
Replied: May 08, 2019
Votes
John Ruch
John
 62
Replied 

Take a look at joins. In particular, look at the properties for the domain join between tr_hist and so_mstr. Is it set to only incldue records where both are equal?

It will likely run much faster if you filter on tr_domain.

If you are still having trouble, try a simple browse with only 1 table and build from there.

 

0 (0 Votes)
Replied: May 08, 2019
Forums
All
Forum Help
Help Using Forums