Does anyone know how to customize (resize) the column widths in the PV Window in SL 7?
*This post is locked for comments
I assume you're talking about setting the size of a field in a grid.
The trick is to change the size of the field in customization manager. By default, customization manager come up in "Field View"; you can get to field view on a grid using the toggle key using the F4 key.
As a business practice, we make all of our customizations at the "All user" level so that we don't have to set up customizations for every single user.
Also, be sure that you don't have any customizations from a third party vendor that also set field lengths as they will take priority over an "All User" customization.
Hope this helps.
Gail J-N
Hi Gail,
Thanks for the response; however i don't believe customization manager can be used to resize the pv dialog box columns. In SL7, when you bring up the pv list dialog box, you do not have the option to launch customization manager. In older version of SL (i.e. SL6.5) if you try to launch customization manager with the pv dialog box open, you receive a system message advising you that you need to close the dialog box before customization manager will open.
I found an older KB article that specified that you could not resize pv window in old versions (SL 5.5 and prior), but was hoping there was a way now in SL7.
i wasn't sure if there was a way manipulate the column size in the pvrec.csv file and then reimport the possible value list.
I'm sorry for misunderstanding your question. After some experimentation this morning, I've concluded that the size of a column in a PV window is dependent on the field size of the column of data passed into the PVRec.
So I took one of our custom PVRec's and altered the data field size in an underlying view. (That way I didn't actually have to change the PVRec to test).
In my example, I took the field length of ItemxRef.AlternateID from 30 to 20, and updated the formatting on the Inventory ID field to include dashes for each segment. After altering just the view that fed the data into the PV lookup window, the column sizes did change. My formatting on the Inventory ID showed up as well - my inventory ID now has dashes.
Sample code follows.My assumption is that if your Stored Proc & related PVRec were to designate the field size in the query, then the column size would reflect that field size in the column width of the PV.
SELECT
PS My programmer tells me that the trick really is to use the view instad of a table in the PVRec query. The view can be updated to control the field lengths. He said that PVRec won't allow the use of "Left" and "Substring" and that's why you have to update to use a view.
I tried creating a view extending the vendid field and adding the view into the Possible Value. There was no difference in the Vendor ID size on the possible value screen.
view:
create view VWVendor as
Select CAST(vendid +' ' as CHAR(25)) as VendID, NAME, S4Future12, Phone,Zip, ClassID from Vendor
updated Possible value to:
"Vendor_All","0327000","","Select VendID, NAME, S4Future12, Phone,Zip, ClassID from vwVendor Where VendId like @parm1 order by VendId","Vendor","VWVendor.VendId;Vendor ID;004;Vendor0","vwVendor.Name;Name;110;Vendor1","vwVendor.S4Future12;Master Co.;004;Vendor5","vwVendor.Phone;Phone;0;Vendor2","vwVendor.Zip;Zip;0;Vendor3"
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
