Dashboard 2 CRUD node

[Cyprien]

I've give it to you this screenshot this afternoon

Is there a problem with it ?

[Cyprien]

Thanks Steve,
I will read it carefully...
Do you think that it's better to scope it with @flowfuse (for easier search) or with @cyprien ?

[Cyprien]

The json keys are not the same. Perhaps you can use sql directive "AS" to change the keys ? Could you post me your query ?

[rafasimple]

sure
msg.topic = SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '${msg.tableName}' AND ( (COLUMN_NAME = 'Schedule' AND DATA_TYPE = 'varchar') OR (COLUMN_NAME = 'Lines' AND DATA_TYPE = 'varchar') OR (COLUMN_NAME = 'Scrap' AND DATA_TYPE = 'int') OR (COLUMN_NAME = 'Rework' AND DATA_TYPE = 'int') OR (COLUMN_NAME = 'Duration' AND DATA_TYPE = 'int') OR (COLUMN_NAME = 'Countermeasure' AND DATA_TYPE = 'varchar') ) ;
msg.action = 'pragma';
return msg;

[Cyprien]

Could you test by changing the begining of your query ?
Not sure that your WHERE clause is correct, why don't you return all your fields ?

SELECT COLUMN_NAME AS name, DATA_TYPE AS type, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE FROM

[rafasimple]

@Cyprien

Could you test by changing the begining of your query ?
Not sure that your WHERE clause is correct, why don't you return all your fields ?

msg.topic = SELECT COLUMN_NAME AS name, DATA_TYPE AS type, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '${msg.tableName}' AND ( (COLUMN_NAME = 'Schedule' AND DATA_TYPE = 'varchar') OR (COLUMN_NAME = 'Lines' AND DATA_TYPE = 'varchar') OR (COLUMN_NAME = 'Scrap' AND DATA_TYPE = 'int') OR (COLUMN_NAME = 'Rework' AND DATA_TYPE = 'int') OR (COLUMN_NAME = 'Duration' AND DATA_TYPE = 'int') OR (COLUMN_NAME = 'Countermeasure' AND DATA_TYPE = 'varchar') );
msg.action = 'pragma';
return msg;
like this?

[Cyprien]

Yes ! like this !

[rafasimple]

@rafasimple

SELECT COLUMN_NAME AS name, DATA_TYPE AS type, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE FROM INFORMATION_SCHEMA.COLUMNS

i obtain this,

but in the dashbord ii have this:

[Steve-Mcl]

I think best start off on the right path & use scope but Not FlowFuse. That's our company name

Use you're own scope (whatever you chose).

[joepavitt]

+1 here, the idea of the scoping is to link it to the author. Anything we build, we use @flowfuse, any third-party/community pieces should be scoped to the relevant author.

[Cyprien]

Are you on MS SQL ? On sqlite, i use INSERT INTO query and it auto increment the ID, so, i don't specify it.
I think that it's the same on MS SQL, but i'm not sure... Anyway, it's a database configuration problem.