tracker issue : CF-4100819

select a category, or use search below
(searches all categories and all time range)
Title:

CFGRID

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/AsDesigned

Reporter/Name(from Bugbase): Robin Boudwin / Robin Boudwin (Robin Boudwin)

Created: 12/16/2015

Components: AJAX, UI Components

Versions: 11.0

Failure Type:

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Normal / All users will encounter

Locale/System: English / Windows 7 64-bit

Vote Count: 0

Problem Description:

I found another problem in cfgrid.  If a value is selected from a drop-down list, it correctly enters the display value, however, when another cell is clicked, that display value converts to the value id rather than still showing the display value. 
  
<cfgridcolumn name="CodeID" header="Rating" values="#variables.codeIDList#" valuesdisplay="#variables.codeList#" valuesdelimiter=","> 
  
Steps to Reproduce:

Actual Result:

Expected Result:

Any Workarounds:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	4100819

External Customer Info:
External Company:  
External Customer Name: Robin Boudwin
External Customer Email:  
External Test Config: CF11

Attachments:

Comments:

You're working on cfgridupdate, but Anit asked me to create a new bug for this issue. Thank you.
Comment by External U.
5050 | December 16, 2015 02:15:49 PM GMT
Hi Robin, The below code works at our end. Please try the code as it is and let us know the results. <cfset application.dsn = "cfartgallery"> <CFIF IsDefined("form.gridEntered") is True> <cfgridupdate grid="Artdisplay" tablename="ART" datasource="#application.dsn#" keyonly="true"> <cfdump var=#form#> </CFIF> <cfquery name="qArtdisplay" datasource="#application.dsn#" > Select ARTID, ARTNAME, MEDIAID from ART </cfquery> <cfform name="frm"> <cfgrid name="Artdisplay" query="qArtdisplay" format="html" insert="yes" delete="true" colHeaderBold = "Yes" selectMode = "EDIT" width="500" insertButton = "Insert a Row" deleteButton = "Delete selected row" font = "Tahoma" rowHeaders = "No" > <cfgridcolumn name="ARTID" width="100"> <cfgridcolumn name="ARTNAME" width="300"> <cfgridcolumn name="MEDIAID" header="MEDIAID" values="1,2,3" valuesdisplay="Excellent,Good,Fair" valuesdelimiter="," width="100"> </cfgrid> <cfinput type="submit" name="gridEntered"> </cfform>
Comment by Anit K.
5051 | December 21, 2015 12:07:05 PM GMT
The behavior is same with CF10 and CF9. Please let us know the result. (Comment added from ex-user id:prk)
Comment by Adobe D.
5052 | December 22, 2015 08:28:23 AM GMT
Hi Guys! I tried it with your code, and it had the same wrong results. When a value is selected from the drop-down list, it populates the cell with the text valuesdisplay. When another row is selected, what is displayed in the original cell converts to the value rather than the valuesdisplay.
Comment by External U.
5053 | January 04, 2016 10:29:38 AM GMT
CF11
Comment by External U.
5054 | January 04, 2016 10:42:50 AM GMT
Please let us know, whether you are able to repro this issue with CF10/ CF9. Thanks, Priya. (Comment added from ex-user id:prk)
Comment by Adobe D.
5055 | January 19, 2016 03:35:27 AM GMT
I only have versions 8 and 11
Comment by External U.
5056 | January 19, 2016 12:34:40 PM GMT
We checked on 801 and are seeing the same behavior. Can you confirm? . (Comment added from ex-user id:prk)
Comment by Adobe D.
5057 | January 20, 2016 06:03:53 AM GMT
Same issue on 8. Thank you for working on this!
Comment by External U.
5058 | January 20, 2016 08:47:14 AM GMT
There are two things we are observing here. One is the grid column as simple input type (in display mode) and other is the combo-box in edit mode. The scope of the combo box(drop down) is till we are in edit mode. This is expected behaviour because once you click outside or in another cell you are no longer in the gridcolumn dropdown scope and hence it changes to the value id. value display is not something which is sent back to the cfc/db once you submit the updated grid. It is just the display values for the dropdown
Comment by Deepraj J.
5059 | September 26, 2016 06:50:52 AM GMT
Has this been resolved? If so, what is the update?
Comment by External U.
5060 | October 27, 2016 12:24:23 PM GMT