Adding A Dataview in a Quote Form -- Error on GetRows

[jdtrent (Joe D Trent)]

Hey folks,

I’m adding a new layer to the quote entry form. No other layers exist.

I need to display customer information on the quote header, so I’m adding a Customer dataview and trying to get the info after the GetByID. Getting an error when reading the data after the quote record is loaded, I think.

Here we go.

Add the dataview:

and select Guided Setup.

Source type: BO Service Call:

Set where clause to Binding (I have also tried Constant: CustNum = [QuoteHed.CustNum])

I’ve tried leaving all the other whereclauses either emtpy or Constant and an empty value.

Select the response parameters:

Attach the dataview:

Summary:

Set the GetRows event trigger:

Check the GetRows parameters:

I have tried editing in CustNum = [QuoteHed].[CustNum] but it doesn’t stick, and have tried making this a constant of CustNum = [QuoteHed.CustNum], among other things.

Save and preview. Load a record–the record displays and then an error message displays:

I have tried a bunch of variations on a theme here, but I must be missing something. Take a look and see anything (operator error) that stands out?

I can probably make a BAQ work here but would rather not have the extra component.

Thanks,

Joe

[jwphillips (Jonathan Phillips)]

@jdtrent

CustNum = [QuoteHed].[CustNum]

Your brackets are probably not helping the interpretation of your query filter. Try CustNum = {QuoteHed.CustNum} … or for good measure, "CustNum = '{QuoteHed.CustNum}'"

The curly braces are what tells the application to grab a value from the context, and you have to have the whole Where clause in your field value

[jdtrent (Joe D Trent)]

Sometimes you just gotta display your ignorance for all to see. That was it.

Thanks, Jonathan.

Joe

[jwphillips (Jonathan Phillips)]

Don’t you love it when you’re so close, but just can’t make it around the corner?

That’s what we’re here for

[Mark_Wonsil]

@jdtrent

Sometimes you just gotta display your ignorance for all to see