{"id":207,"date":"2022-06-09T19:39:09","date_gmt":"2022-06-09T19:39:09","guid":{"rendered":"https:\/\/docs.xlreport.com\/docs\/admin-user\/convert-field-type-expression\/"},"modified":"2022-06-09T19:39:43","modified_gmt":"2022-06-09T19:39:43","slug":"convert-field-type-expression","status":"publish","type":"docs","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/expression-and-formulas\/convert-field-type-expression\/","title":{"rendered":"Convert Field Type Expression"},"content":{"rendered":"<p>If you need to convert a field type to another one then you can use the Convert Expression builder.<\/p>\n<p class=\"note\">Note! This functionality only applies for Data Connections to MS SQL Server, MS Access, MySQL and Oracle databases.<\/p>\n<h2>Add a new expression<\/h2>\n<ul>\n<li value=\"1\">Select the table and field.<\/li>\n<li value=\"2\"><span class=\"DoIt\">Click Convert Expression<\/span> .<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/38.png\" \/><\/p>\n<ul>\n<li value=\"1\">Select a field type to convert the expression to.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/40.png\" \/><\/p>\n<ul>\n<li value=\"1\"><span class=\"DoIt\">Click Ok<\/span> to insert the expression.<\/li>\n<\/ul>\n","protected":false},"featured_media":0,"parent":203,"menu_order":6,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"_links":{"self":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/207"}],"collection":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/comments?post=207"}],"version-history":[{"count":1,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/207\/revisions"}],"predecessor-version":[{"id":208,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/207\/revisions\/208"}],"up":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/203"}],"prev":[{"title":"Date Expressions","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/expression-and-formulas\/date-expressions\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/205"}],"wp:attachment":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/media?parent=207"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/doc_tag?post=207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}