Configurator related BAQ not outputting entire string

Kinetic ERP
,
1

I made a BAQ to take information from PCInputValue to get configurator data from a quote. I am having an issue where the value PCInputValue_InputValue is not showing the entirety of a string, it only shows about 50 characters. The display fields shows that the format is in x(1000), so that should be plenty of space.

Here is an example of what I mean:
image

This is supposed to show “Direction of Die: 16.876” from 54" width, 8" from 600" length" but it is only showing everything up to the word “from”. This happens with all longer strings that are displayed in the BAQ.

I checked the configurator, and it is storing the entirety of the text.

2

If you open Developer tools in the browser, does the relevant call to server returns all data? Or also truncated?

1 Like
3

Where in the chrome developer tools would I find that?

4

Is this what you mean? It looks like only the first 50 characters are being pulled based on the development tools.

image
image666×292 15.6 KB

5

No, network tab, select service call that returns the data. For BAQ it is probably Execute*.
You can check in Response tab what is returned

1 Like
6

I just happened to look there right as you sent this.

image
image571×129 5.27 KB

7

PCInputValue is a view that only shows nvarchar(50) in InputValue field

image
image1023×688 53.1 KB

1 Like
8

That is strange. The BAQ shows that PCInputValue has a format of x(1000).
image

In configurator designer, I looked at the PCInputValue view and saw that it also had a format of x(1000)

image
image1524×571 25.5 KB

Is it possible for me to change the PCInputValue view to have InputValue have 1000 instead of only 50? If so, how would I do that?

9

Since PCInputValue has a limit of 50 characters, I think I will just make a new UD field for what I need and make a document rule connecting the value from configurator to the new UD field.

10

BAQ format is just a string, it does not change underlined data.
You cannot change system view yourself, you have to report it if you think it should be different.

Right now you can probably create BAQ based on underline table with XML data and try to retrieve node from it using calc field for example.

It is Erp.PCValueSet table, column FieldValues.
I am not familar with configurator data, but XML seems simple.
Here is how I can get values for some control
PCValueSet.FieldValues.value(‘(/_BoatPage1Table/_BoatPage1Row/epiPcTextBox1)[1]’, ‘VARCHAR(100)’)

2 Likes
11

Thanks for this! What would be the best place to request a change for the view? The ideas forum or somewhere else?