Exporting Custom Workflow and States

Frappe Framework App Development
1

I’m trying export a custom Workflow from a Quotation doctype, like this:

fixtures =  {"dt": "Workflow", "filters": [[
      "dt", "in", ("Quotation")
      ]]
}

error:
pymysql.err.InternalError: (1054, u"Unknown column 'tabWorkflow.dt' in 'where clause'")

2

hi

try this

fixtures =  {"dt": "Workflow", "filters": [[
      "document_type", "in", ("Quotation")
      ]]
}
2 Likes
3

nice, thank you!
how can you knewed about that?

4

nice, thank you!
how can you knewed about that?

Hi I guess. I see your error. Unknown column 'tabWorkflow.dt is must is col name. I check database tabWorkflow.document_type is name of Doctype

pymysql.err.InternalError: (1054, u"Unknown column 'tabWorkflow.dt' in 'where clause'")

5

Sorry, hi.
Hum see… so frappe recognized that I’m was appointing a column, not a table name, huh!
But my doubt is difference between “dt” and “document_type”, anyway, thank you

1 Like