Lost fields in sidebar

Scriptcase 8 Discussion
#1

Hello, I can not find the columns in the sidebar’s fields list. What is happening?. Where is ap1 field? Thank you in advance.

PS: the application has been rebuilt a ton of times, regenerated, and it works, but I can not access the ap1 field to be edited.

Select segment:

SELECT DISTINCT a.PERIODO as periodo, b.CEDULA as cedula, c.COD_PERFIL as perfil, b.NBR_EMPLEADO as nombre, b.APE_1 as ap1, b.puesto, b.ubicacion, f.nombre as competencia, d.esperado_cualitativo, d.OBTENIDO_CUALITATIVO, d.BRECHA
fROM

Overview:

#2

The problem persists, I have deal with it for hours, now I am absolutely sure that this is a bug due to session context. I will still keeping an eye on how exactly reproduce the error.

#3

The sidebar fields list will show only visible fields.
In the “Edit Fields” right pane I can see AP1 in the “Page: fields not shown” list.
Did you try to drag it to the above block “AREA_EVALUACION_COMPETENCIA”?

#4

If you have issues with dragging, you can accomplish the same result by using “Fields Positioning”.
Same logic but in this case fields not show are on the left: just move them on the right pane if you want them to show up in the sidebar’s fields list.

Note that sidebar “Fields” list showing only fields that are set as visible in “Edit Fields” or “Fields Positioning” is by design, not a bug.
It’s always been this way, at least since SC 8.0, I don’t know with earlier versions as I never used SC before version 8.

#5

Yeah, I tried that. The things are getting worse. Take a look how I drag and drop the columns and after press save button the changes do not take effect :

#6

I think you’re not supposed to drag fields above “Page: Pag1.”
All fields should be beneath it.

If that won’t work I’d check the blocks situation.
It appears you don’t have any block defined (what happened to your “AREA_EVALUACION_COMPETENCIA” block?)
I don’t know if a grid can have no blocks.
I checked a couple of my grids and they all have:


Page: Pag1
   Block: [block_name]
      Field1
      Field2
      Field3
 Page: Fields not shown

As I wrote earlier, you can also rearrange fields using Fields Positioning

#7

I was tired of battling with this situation. I created a new grid, copied the same sql query from old grid to new one. The issue is only presented in the grid above, no config, not blocks, just sql.