Trouble with Editor fieds select
Trouble with Editor fieds select
jquijado
Posts: 24Questions: 6Answers: 0
I'm using the Datatables Editor with a field select for two tables with the data of the examples. I've built a seletc field with the name of the city. Cities are in a different table from the one with staff names, In the staff table I have a field which is id_ciudad (the id of the city in the cities table).
The trouble is that I can't get the right city seleceted. It aways appears selected Edimburgh, even if that is not the city o the member of the staff I'm editing. The Editor object has been created in the following way:
var objetoEditor = new $.fn.dataTable.Editor({
ajax: 'crud_editor_04.php',
table: '#tabla_de_personal',
idSrc: 'id',
i18n: {
create: {
button: "Nuevo",
title: "Crear nuevo registro",
submit: "Grabar"
},
edit: {
button: "Editar",
title: "Editar registro",
submit: "Actualizar"
},
remove: {
button: "Borrar",
title: "Borrar registro",
submit: "Borrar",
confirm: {
_: "¿Estás seguro de eliminar estos %d registros?",
1: "¿Estás seguro de eliminar este registro?"
}
},
multi: {
title: "Múltiples valores",
info: "Los registros seleccionados contienen diversos valores para este campo. Para editar este campo con el mismo valor en los registros seleccionados, pulsa aquí. En caso conterario, los registros mantendrán sus valores individuales en este campo.",
restore: "Restaurar los valores múltiples",
noMulti: "Esta entrada puede ser modificada individualmente, pero no como parte de un grupo."
},
datetime: {
previous: 'Anterior',
next: 'Siguiente',
months: ['Enero', 'Febrero', 'Marzo', 'Abril', 'Mayo', 'Junio', 'Julio', 'Agosto', 'Septiembre', 'Octubre', 'Noviembre', 'Diciembre'],
weekdays: ['Dom', 'Lun', 'Mar', 'Mié', 'Jue', 'Vie', 'Sáb']
}
},
fields: [
{label: 'Nombre:', name: 'personal.nombre', attr: {class:'form-control'}},
{label: 'Apellido:', name: 'personal.apellido', attr: {class:'form-control'}},
{label: 'Cargo:', name: 'personal.cargo', attr: {class:'form-control'}},
``` {```
``` label: 'Ciudad:', ```
``` name: 'personal.id_ciudad',```
``` attr: {class:'form-control'}, ```
``` type: "select", ```
``` options: [```
``` {label:'Edinburgh', value:'1'},```
``` {label:'London', value:'2'},```
``` {label:'New York', value:'3'},```
``` {label:'San Francisco', value:'4'},```
``` {label:'Sidney', value:'5'},```
``` {label:'Singapore', value:'6'},```
``` {label:'Tokyo', value:'7'}```
``` ]```
``` },```
{
label: 'F. Ingreso:',
name: 'personal.fecha_de_ingreso',
type: 'date',
def: function(){return new Date();},
dateFormat: 'dd-mm-yy',
attr: {readonly:true, class:'form-control', style:'display:inline'},
opts:{
buttonImage:'editor/images/calendar.png',
buttonImageOnly: true,
buttonText: 'Elegir fecha',
dayNames: ['Domingo', 'Lunes', 'Martes', 'Miércoles', 'Jueves', 'Viernes', 'Sábado'],
dayNamesMin: ['Do', 'Lu', 'Ma', 'Mi', 'Ju', 'Vi', 'Sá'],
dayNamesShort: ['Dom', 'Lun', 'Mar', 'Mié', 'Jue', 'Vie', 'Sáb'],
firstDay: 1,
monthNames: ['Enero', 'Febrero', 'Marzo', 'Abril', 'Mayo', 'Junio', 'Julio', 'Agosto', 'Septiembre', 'Octubre', 'Noviembre', 'Diciembre'],
monthNamesShort: ['Ene', 'Feb', 'Mar', 'Abr', 'May', 'Jun', 'Jul', 'Ago', 'Sep', 'Oct', 'Nov', 'Dic'],
changeMonth: true,
changeYear: true,
prevText: "Anterior",
nextText: "Siguiente"
}
},
{
label: 'Salario anual:',
name: 'personal.salario_bruto_anual',
attr: {class:'form-control'},
fieldInfo: 'El salario debe ir como valor numérico, con dos decimales (incluso si son 00), separados por un punto.'
},
]
});
How can I mark an option of the select field as selected? I've tried def: 'personal.id_ciudad', def:'ciudades.id' and def:'ciudades.id' but nothing works. No preselected option in my select.
I've bought a single developer License today, for the case it is a trial limitation, but it does not work all the same.
Can someone help me?
Thanks a lot everyone.
Edited by Allan - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.
This question has accepted answers - jump to:
Answers
The error suggests that the values to be edited don't match the values that have been configured as options. Possibly in this case that might be because the data is numbers, while the values you have given are strings? I'd need a link to the page to be sure.
Allan
Dear Allan.
There's no link to the page, since I'm actually trying the editor in localhost. I could, instead of that, send you a copy of the files I'm using, if you give me an address mail for sending them.
All the same, the id in the database is numeric but, when converted to JSON is processed as atring, and ím trying to use it as a string.
By the way, I,ve finally bougth the license, since I'm sure it's a great product (in spite of I'm slow to learn), and i've recommended some other colleagues to buy it too.
Thanks for your helpful. You have really created a great product.
Thank you
.
Could you show me the JSON returned from the server and also your DataTables initialisation? That will hopefully let me identify what is happening.
Allan
Of course. Datatables object is defined like this:
When Datatatables is loaded, my php script returns a JSON like this (copied from Chrome console):
It continues on next comment...
Comes from previous comment...
The Editor object, since I need it to get up to date data on "cargo" (position) and "ciudad" (city), has been rewritten like this:
The JSON's for positions and cities, as they appear in the Chrome console, are the following:
AND
The trouble is that the select fields are properly loaded with the lists, but it always appears the first item selected, instead of the real one. I see JSON's as the ones in the examples pages of your site, so I've tried a lot of combinations, but I can't do it works properly. If I'm putting my foot in it, I can see it.
Once else, thanks a lot. This type of helpful makes a tool like this more interesting for users.
That is using a private parameter. I would suggest you use the API instead:
I would also point out that
evalis evil. UseJSON.parse( listaDeCiudades );if it is a string, although given that you setdataType: "JSON",I'd be surprised if it was needed, but its impossible to say for sure without access to the page.Allan
Dear Allan:
First of all, I thank you for your advice about field().update().
I've put de whole test which makes me crazy in http://datatables-test.000webhostapp.com/
As you can see, if you select a row and press the edit button, the select fields don't show the real option, but just the first one.
The whole code is downloadable from http://datatables-test.000webhostapp.com/datatables_test.zip
I've read the manual in your site, but I can't find the reason this doesn't work.
Once again, thank you very much.
Dear Allan:
About the touble with select fields, I've seen that, unlike your example, when I select more than one row and press the edit button, it doesn't show "Multiple values" in the select fields, but just in the text ones.
That´s so obvious for me that I'm doing something bad, but I can´t see what is my mistake. I've viewed your examples, reference, manual... everything in your page.
Are there any docs else I can review? What can I to do about this type of fieds?. It's a real big problem if I can't do they work properly.
Thanks a lot and Merry Christmas to you.
Regards.
It looks like the select values have been configured to be numbers - see attached screenshot.
But the value being edited doesn't match, so it always just shows the first item in the select list.
If you have a look in my join example you will see that it uses two fields in the data source - the label that is shown in the DataTable and the value that is edited in Editor. I would recommend taking a similar approach.
Allan
Hi again, Allan:
I've seen your example. It was my starting point when I began trying to use joined tables. The problem is I can't see any difference from the response in your example with the one of mine.
I attach a picture with the data of both examples (yours and mine). As you can see, the select options are properly created. In the picture you can see a JSON in Chrome console too. As you can see, it looks to be right.
So, there are several trouble with the select fields:
* It doesn't select the right option
* It doesn't show Multiple Values if there are more than one row selected when press Edit.
* The placeholderDisabled property doesn't work (I've found about this just a few minutes ago).
Might it be a bug in my copy of Editor? I really have no idea of what is hapenning. If JSON data are correct, my code should work the same way as yours, shouldn't?
Can this be caused by the version? I really don't know what else to look at.
Please, help me about this. Your tool is really powerful, and could save a lot of hours of work for me, but I need to know why this kind of fieds don't work for my code.
PD. It seems I can´t attach an image to this comment, so the screenshot is in http://datatables-test.000webhostapp.com/screenshot.png
Please help me. If I need an older version of the editor, please let me know the right link. The one I've downloaded when I purchased it is 1.6 I think. Could it be any kind of bug or incompatibilty with this version?
Thanks again
I don't believe so, no.
Let's take the Ciudad field:
However, in the data set returned from the server, there is no
personal.id_ciudadproperty. This is what thepersonalobject looks like:If you want to be able to edit that property you would need to include it in the data set so Editor knows what the current value is..
Allan
Gosh, Allan:
You are REALLY right. When I read the information in the page, I never understood the direct relationship between the columns in Datatables object and the source of data in the editor object. So there's really a bug, not in the editor, but in my mind.
Now I'm thinking about it, this working way is absolutely logic. Even I haven't found about it in the manual, I should have understood it. I'm not used to a so powerful tool, and some of its functions require more attention from me.
Really thanks for your helpful. You are really a good professional, and so kindful.
I wish you a happy new year.
I had the same issue....