node.js

wm1111

in node.js,preRemove can't use return false,why?TypeError: Cannot read property 'push' of undefine

allan

Thank you for letting me know about that. Fixed here and I'll have it in 1.9.1 which I'm working on.

Allan

wm1111

Thank you,Allan! My question is resolved.

wm1111

By the way. would you got Webpage a return message,tell user can't delete row,because the row was refered.

allan

On the client-side listen for postSubmit and check the cancelled array in the JSON data. Any rows that were rejected will be listed there. You can then use error() or alert() to show a message to the user.

Allan

wm1111

Thanx!
Allan

wm1111

Hi,Allan!
In Options().where(),how to use distinct or groupBy?

wm1111

this is my program ,but distinct not is effect
.options(
new Options()
.table('capsule_pp_capsuleproduct')
.value('id')
.label('BatchNO')
.where(

              (q) => {

                q.distinct('BatchNO').where('ProduceDate', '>', new Date((new Date).getTime() - 2400 * 3600 * 1000));

             }
             )

allan

In Options().where(),how to use distinct or groupBy?

There is no option for either at this time. I figured that you would always want to be showing all options in the list, since each will be unique.

If you wanted to use distinct or groupBy you could either define a VIEW with them, and then read the results from that view, or use a custom function to get the options from the database and query it directly (i.e. with Knex, giving you the full list of options it has available).

Allan

wm1111

I still want to use distinct in Options,becasue my DB recorder the field not is unqiue.

wm1111

hi,Allan.
I have a problem again. in bubble edit,if use leftJoin to link another table,click the linked table cell,console display error above.
dataTables.editor.min.js:66 Uncaught Unable to automatically determine field from source. Please specify the field name. For more information, please refer to https://datatables.net/tn/11

allan

Hi,

The page the error links to provides a detailed describe of the problem and how to resolve it. Basically the columns.data for the DataTable column and field.name for the Editor field don't match, so you need to tell DataTables which field you want to edit when that column is activated.

Allan

wm1111

Thanx.Allan

wm1111

web page:

editor.fields: [
                     {
                        label: "批次:",
                        name: "capsule_pp_capsuleproductsub.BatchNO",
                        type: "select",
                        placeholder: "选择批次"

                    },

table. columns: [
                    { data: "capsule_pp_capsuleproduct.BatchNO" },

server :

     editor.Field('capsule_pp_capsuleproductsub.BatchNO')
            .options(
                new Options()
                .table('capsule_pp_capsuleproduct')
                .value('id')
                .label('BatchNO')
            ),
.leftJoin('capsule_pp_capsuleproduct', 'capsule_pp_capsuleproduct.id', '=', 'capsule_pp_capsuleproductsub.BatchNO')

namly, editor have not field"capsule_pp_capsuleproduct.BatchNO",then can't use bubble edit method on the field,isn't?

Edited by Colin - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.

wm1111

Hi,Allen
How to only update edited field , other can't edited field not update?

wm1111

How to display to upload image as thumbnail in the table cell

colin

Hi @wm111 ,

Does this example here help?

Cheers,

Colin

wm1111

thanx,Colin.
But my image is too big,display it will to occupy almost totall webpage.

colin

Hi @wm1111 ,

Ah, I see. This thread here (and here) talks about how to create a thumbnail, you need to create an action to do it. Then this section of the manual explains how to display it.

Cheers,

Colin