JSON filter on REST Param

[NeilT (Neil Taft)]

Hi Guys,

I am trying to limit certain territory codes that return on the Quote Landing page and have hit a bit of a wall.

I have tried using $in on the Rest Params but it doesn’t seem to work. More than likely something I am doing, I am not a definitive developer, but can stumble through a few things.

My working JSON with a single territory ID is

{"whereClause":"TerritoryID = 'BH1'"}

I have tried using the below with an $in clause but to no result

{
 "whereClause": {
				"TerritoryID": {"$in": ["BH1","BH2"]}
}

I am using the Erp.BO.QuoteSvc and the GetList Path

Thank you

[Mark_Wonsil]

You may want to do what @dcamlin did by replacing the the Landing Page with a BAQ, which is far easier to filter.

Adding a new Column to the Sales Order Landing page

I think of most “Landing Pages” as “Header Information”. So, in this case, Order Entry Landing Page provides information you find on the Sales Order Header (which includes the SalesRepList). The PartNum is a level down in OrderDtl. So it wouldn’t inherently show at the header level. One thing you can do is create a BAQ which includes both OrderHed and OrderDtl information, then customize the landing page with a new BAQ grid instead of the standard grid to show the new results. I did this fo…

[tkoch (Theodore Koch)]

@NeilT

{ "whereClause": { "TerritoryID": {"$in": ["BH1","BH2"]} }

Try this:

{"whereClause":"TerritoryID IN ('BH1','BH2')"}

[NeilT (Neil Taft)]

I mean come on now, that’s fantastic. I was trying all sorts of different angles and different approaches, this has done exactly what I needed.

Thank you