GetRows - Erp.BO.QuoteSvc

Kinetic ERP
1

Hi

Has anyone seen this issue? I’ve tried multiple ways.

Base

{
	"whereClauseQuoteHed": "BY QuoteNum DESC",
	"whereClauseQuoteHedAttch": "1=0",
	"whereClauseQSalesRP": "1=0",
	"whereClauseQuoteCnt": "1=0",
	"whereClauseQuoteCom": "1=0",
	"whereClauseQuoteDtl": "1=0",
	"whereClauseQuoteDtlAttch": "1=0",
	"whereClauseQuoteCoPart": "1=0",
	"whereClauseQuoteDtlAttrValueSet": "1=0",
	"whereClauseQuoteDtlTax": "1=0",
	"whereClauseQuoteMsc": "1=0",
	"whereClauseQuoteQty": "1=0",
	"whereClauseQtmmkup": "1=0",
	"whereClauseQtQtyMsc": "1=0",
	"whereClauseQuoteHedMsc": "1=0",
	"whereClauseQuoteHedTax": "1=0",
	"whereClauseHedTaxSum": "1=0",
	"whereClausePartSubs": "1=0",
	"whereClauseTaxConnectStatus": "1=0",
	"whereClauseWhatIfScheduling": "1=0"
}

Tested 1

{
	"whereClauseQuoteHed": "BY QuoteNum DESC",
	"whereClauseQuoteHedAttch": "1=0",
	"whereClauseQSalesRP": "SalesRepCode='?{Constant.CurrentUserID}'",
	"whereClauseQuoteCnt": "1=0",
	"whereClauseQuoteCom": "1=0",
	"whereClauseQuoteDtl": "1=0",
	"whereClauseQuoteDtlAttch": "1=0",
	"whereClauseQuoteCoPart": "1=0",
	"whereClauseQuoteDtlAttrValueSet": "1=0",
	"whereClauseQuoteDtlTax": "1=0",
	"whereClauseQuoteMsc": "1=0",
	"whereClauseQuoteQty": "1=0",
	"whereClauseQtmmkup": "1=0",
	"whereClauseQtQtyMsc": "1=0",
	"whereClauseQuoteHedMsc": "1=0",
	"whereClauseQuoteHedTax": "1=0",
	"whereClauseHedTaxSum": "1=0",
	"whereClausePartSubs": "1=0",
	"whereClauseTaxConnectStatus": "1=0",
	"whereClauseWhatIfScheduling": "1=0"
}

Doesn’t filter…

Tested 2

{
	"whereClauseQuoteHed": "SalesRepCode='?{Constant.CurrentUserID}' AND BY QuoteNum DESC",
	"whereClauseQuoteHedAttch": "1=0",
	"whereClauseQSalesRP": "1=0",
	"whereClauseQuoteCnt": "1=0",
	"whereClauseQuoteCom": "1=0",
	"whereClauseQuoteDtl": "1=0",
	"whereClauseQuoteDtlAttch": "1=0",
	"whereClauseQuoteCoPart": "1=0",
	"whereClauseQuoteDtlAttrValueSet": "1=0",
	"whereClauseQuoteDtlTax": "1=0",
	"whereClauseQuoteMsc": "1=0",
	"whereClauseQuoteQty": "1=0",
	"whereClauseQtmmkup": "1=0",
	"whereClauseQtQtyMsc": "1=0",
	"whereClauseQuoteHedMsc": "1=0",
	"whereClauseQuoteHedTax": "1=0",
	"whereClauseHedTaxSum": "1=0",
	"whereClausePartSubs": "1=0",
	"whereClauseTaxConnectStatus": "1=0",
	"whereClauseWhatIfScheduling": "1=0"
}

500 Error

Any ideas?

2

Don’t worry everyone. I replaced the Landing Page grid with a BAQ…