E10: Where are configurator values stored?

Yahoo Archive
1
Thank you Brenda!

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 10, 2015 2:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E10: Where are configurator values stored?


I use the values from one session to another. If you are just looking to see the values, the easiest way is probably via sql. See if this helps:

select
QD.QuoteNum
,QD.QuoteLine
,'' as InputName
,(SELECT SUBSTRING((SELECT LEFT((select cast((SELECT FieldValues.query('__QuoteBoxPage1Table/__QuoteBoxPage1Row/HPartDesc')
FROM Epicor10.Erp.PcValueSet where GroupSeq = (select distinct GroupSeq from Epicor10.Erp.QuoteDtl where QuoteNum = QD.QuoteNum and QuoteLine = QD.QuoteLine) and PageSeq = 1)as varchar(100))),CHARINDEX('</',(select cast((SELECT FieldValues.query('__QuoteBoxPage1Table/__QuoteBoxPage1Row/HPartDesc')
FROM Epicor10.Erp.PcValueSet where GroupSeq = (select distinct GroupSeq from Epicor10.Erp.QuoteDtl where QuoteNum = QD.QuoteNum and QuoteLine = QD.QuoteLine) and PageSeq = 1)as varchar(100))))-1)),(SELECT CHARINDEX('>',(SELECT LEFT((select cast((SELECT FieldValues.query('__QuoteBoxPage1Table/__QuoteBoxPage1Row/HPartDesc')
FROM Epicor10.Erp.PcValueSet where GroupSeq = (select distinct GroupSeq from Epicor10.Erp.QuoteDtl where QuoteNum = QD.QuoteNum and QuoteLine = QD.QuoteLine) and PageSeq = 1)as varchar(100))),CHARINDEX('</',(select cast((SELECT FieldValues.query('__QuoteBoxPage1Table/__QuoteBoxPage1Row/HPartDesc')
FROM Epicor10.Erp.PcValueSet where GroupSeq = (select distinct GroupSeq from Epicor10.Erp.QuoteDtl where QuoteNum = QD.QuoteNum and QuoteLine = QD.QuoteLine) and PageSeq = 1)as varchar(100))))-1))))+1,100)
)as NewPartDesc





from QuoteDtl QD with (NOLOCK)
JOIN QuoteHed QH with (NOLOCK) ON QH.Company = QD.Company and QH.QuoteNum = QD.QuoteNum
JOIN Customer C with (NOLOCK) ON C.Company = QH.Company and C.CustNum = QH.CustNum

where QD.QuoteNum = YourQuoteNumHere and QD.QuoteLine = YourQuoteLineHere


Brenda

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 10, 2015 1:57 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E10: Where are configurator values stored?



Thanks Brenda.
Can you elaborate a bit on what you mean by “We get to them via a sql query inside the configurator.”?
I’m trying to confirm the values that are stored in the database without having to go into the configurator


From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 10, 2015 1:51 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] RE: E10: Where are configurator values stored?


The new values are stored in an XML format in the PcValueSet table. We get to them via a sql query inside the configurator.

Brenda

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 10, 2015 1:47 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] E10: Where are configurator values stored?



Hi All,

In E9, values entered during a configurator session were stored in PcInValue.
It seems like in E10, they are stored in another table, but I can’t see to find it.

Anyone know what table these values are stored?

[cid:7a3312.png@cb414373.438ef46a]


Joe Rojas
Director of Information Technology
(781) 408-9278 Mobile
(781) 573-0291 Local
(781) 232-5191 Fax


[http://matsinc.com/images/e-mail-signatures/tagline.jpg%5d
[http://matsinc.com/images/e-mail-signatures/graphics/logo_matsinc.png%5d<http://matsinc.com> [http://matsinc.com/images/e-mail-signatures/graphics/icon_twitter.png%5d <http://twitter.com/Mats_Inc> [http://matsinc.com/images/e-mail-signatures/graphics/icon_facebook.png%5d <http://www.facebook.com/commercial.flooring> [http://matsinc.com/images/e-mail-signatures/graphics/icon_youtube.png%5d <http://www.youtube.com/user/MatsIncTV> [http://matsinc.com/images/e-mail-signatures/graphics/icon_pinterest.png%5d <http://www.pinterest.com/contractfloors/> [http://matsinc.com/images/e-mail-signatures/graphics/icon_blog.png%5d <http://matsinc.com/blog>


[Non-text portions of this message have been removed]


[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
2
Hi All,

In E9, values entered during a configurator session were stored in PcInValue.
It seems like in E10, they are stored in another table, but I can’t see to find it.

Anyone know what table these values are stored?

[cid:7a3312.png@cb414373.438ef46a]


Joe Rojas
Director of Information Technology
(781) 408-9278 Mobile
(781) 573-0291 Local
(781) 232-5191 Fax


[http://matsinc.com/images/e-mail-signatures/tagline.jpg%5d
[http://matsinc.com/images/e-mail-signatures/graphics/logo_matsinc.png%5d<http://matsinc.com> [http://matsinc.com/images/e-mail-signatures/graphics/icon_twitter.png%5d <http://twitter.com/Mats_Inc> [http://matsinc.com/images/e-mail-signatures/graphics/icon_facebook.png%5d <http://www.facebook.com/commercial.flooring> [http://matsinc.com/images/e-mail-signatures/graphics/icon_youtube.png%5d <http://www.youtube.com/user/MatsIncTV> [http://matsinc.com/images/e-mail-signatures/graphics/icon_pinterest.png%5d <http://www.pinterest.com/contractfloors/> [http://matsinc.com/images/e-mail-signatures/graphics/icon_blog.png%5d <http://matsinc.com/blog>



[Non-text portions of this message have been removed]
3

The new values are stored in an XML format in the PcValueSet table. We get to them via a sql query inside the configurator.

 

Brenda

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 10, 2015 1:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E10: Where are configurator values stored?

 

 

Hi All,

In E9, values entered during a configurator session were stored in PcInValue.
It seems like in E10, they are stored in another table, but I can’t see to find it.

Anyone know what table these values are stored?

[cid:7a3312.png@cb414373.438ef46a]


Joe Rojas
Director of Information Technology
(781) 408-9278 Mobile
(781) 573-0291 Local
(781) 232-5191 Fax


[http://matsinc.com/images/e-mail-signatures/tagline.jpg]
[http://matsinc.com/images/e-mail-signatures/graphics/logo_matsinc.png]<http://matsinc.com> [http://matsinc.com/images/e-mail-signatures/graphics/icon_twitter.png] <http://twitter.com/Mats_Inc> [http://matsinc.com/images/e-mail-signatures/graphics/icon_facebook.png] <http://www.facebook.com/commercial.flooring> [http://matsinc.com/images/e-mail-signatures/graphics/icon_youtube.png] <http://www.youtube.com/user/MatsIncTV> [http://matsinc.com/images/e-mail-signatures/graphics/icon_pinterest.png] <http://www.pinterest.com/contractfloors/> [http://matsinc.com/images/e-mail-signatures/graphics/icon_blog.png] <http://matsinc.com/blog>


[Non-text portions of this message have been removed]

4
Thanks Brenda.
Can you elaborate a bit on what you mean by “We get to them via a sql query inside the configurator.”?
I’m trying to confirm the values that are stored in the database without having to go into the configurator


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 10, 2015 1:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E10: Where are configurator values stored?


The new values are stored in an XML format in the PcValueSet table. We get to them via a sql query inside the configurator.

Brenda

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 10, 2015 1:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E10: Where are configurator values stored?



Hi All,

In E9, values entered during a configurator session were stored in PcInValue.
It seems like in E10, they are stored in another table, but I can’t see to find it.

Anyone know what table these values are stored?

[cid:7a3312.png@cb414373.438ef46a]


Joe Rojas
Director of Information Technology
(781) 408-9278 Mobile
(781) 573-0291 Local
(781) 232-5191 Fax


[http://matsinc.com/images/e-mail-signatures/tagline.jpg%5d
[http://matsinc.com/images/e-mail-signatures/graphics/logo_matsinc.png%5d<http://matsinc.com> [http://matsinc.com/images/e-mail-signatures/graphics/icon_twitter.png%5d <http://twitter.com/Mats_Inc> [http://matsinc.com/images/e-mail-signatures/graphics/icon_facebook.png%5d <http://www.facebook.com/commercial.flooring> [http://matsinc.com/images/e-mail-signatures/graphics/icon_youtube.png%5d <http://www.youtube.com/user/MatsIncTV> [http://matsinc.com/images/e-mail-signatures/graphics/icon_pinterest.png%5d <http://www.pinterest.com/contractfloors/> [http://matsinc.com/images/e-mail-signatures/graphics/icon_blog.png%5d <http://matsinc.com/blog>


[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
5

I use the values from one session to another.  If you are just looking to see the values, the easiest way is probably via sql.  See if this helps:

 

select

              QD.QuoteNum

              ,QD.QuoteLine

              ,'' as InputName

              ,(SELECT SUBSTRING((SELECT LEFT((select cast((SELECT FieldValues.query('__QuoteBoxPage1Table/__QuoteBoxPage1Row/HPartDesc')

                     FROM   Epicor10.Erp.PcValueSet where GroupSeq = (select distinct GroupSeq from Epicor10.Erp.QuoteDtl where QuoteNum = QD.QuoteNum and QuoteLine = QD.QuoteLine) and PageSeq = 1)as varchar(100))),CHARINDEX('</',(select cast((SELECT FieldValues.query('__QuoteBoxPage1Table/__QuoteBoxPage1Row/HPartDesc')

                     FROM   Epicor10.Erp.PcValueSet where GroupSeq = (select distinct GroupSeq from Epicor10.Erp.QuoteDtl where QuoteNum = QD.QuoteNum and QuoteLine = QD.QuoteLine) and PageSeq = 1)as varchar(100))))-1)),(SELECT CHARINDEX('>',(SELECT LEFT((select cast((SELECT FieldValues.query('__QuoteBoxPage1Table/__QuoteBoxPage1Row/HPartDesc')

                     FROM   Epicor10.Erp.PcValueSet where GroupSeq = (select distinct GroupSeq from Epicor10.Erp.QuoteDtl where QuoteNum = QD.QuoteNum and QuoteLine = QD.QuoteLine) and PageSeq = 1)as varchar(100))),CHARINDEX('</',(select cast((SELECT FieldValues.query('__QuoteBoxPage1Table/__QuoteBoxPage1Row/HPartDesc')

                     FROM   Epicor10.Erp.PcValueSet where GroupSeq = (select distinct GroupSeq from Epicor10.Erp.QuoteDtl where QuoteNum = QD.QuoteNum and QuoteLine = QD.QuoteLine) and PageSeq = 1)as varchar(100))))-1))))+1,100)

              )as NewPartDesc

 

 

 

 

 

from QuoteDtl QD with (NOLOCK)

       JOIN QuoteHed QH with (NOLOCK) ON QH.Company = QD.Company and QH.QuoteNum = QD.QuoteNum

       JOIN Customer C with (NOLOCK) ON C.Company = QH.Company and C.CustNum = QH.CustNum

      

where  QD.QuoteNum = YourQuoteNumHere    and QD.QuoteLine = YourQuoteLineHere

 

 

Brenda

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 10, 2015 1:57 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E10: Where are configurator values stored?

 

 

Thanks Brenda.
Can you elaborate a bit on what you mean by “We get to them via a sql query inside the configurator.”?
I’m trying to confirm the values that are stored in the database without having to go into the configurator


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 10, 2015 1:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E10: Where are configurator values stored?


The new values are stored in an XML format in the PcValueSet table. We get to them via a sql query inside the configurator.

Brenda

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 10, 2015 1:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E10: Where are configurator values stored?



Hi All,

In E9, values entered during a configurator session were stored in PcInValue.
It seems like in E10, they are stored in another table, but I can’t see to find it.

Anyone know what table these values are stored?

[cid:7a3312.png@cb414373.438ef46a]


Joe Rojas
Director of Information Technology
(781) 408-9278 Mobile
(781) 573-0291 Local
(781) 232-5191 Fax


[http://matsinc.com/images/e-mail-signatures/tagline.jpg]
[http://matsinc.com/images/e-mail-signatures/graphics/logo_matsinc.png]<http://matsinc.com> [http://matsinc.com/images/e-mail-signatures/graphics/icon_twitter.png] <http://twitter.com/Mats_Inc> [http://matsinc.com/images/e-mail-signatures/graphics/icon_facebook.png] <http://www.facebook.com/commercial.flooring> [http://matsinc.com/images/e-mail-signatures/graphics/icon_youtube.png] <http://www.youtube.com/user/MatsIncTV> [http://matsinc.com/images/e-mail-signatures/graphics/icon_pinterest.png] <http://www.pinterest.com/contractfloors/> [http://matsinc.com/images/e-mail-signatures/graphics/icon_blog.png] <http://matsinc.com/blog>


[Non-text portions of this message have been removed]


[Non-text portions of this message have been removed]