atom feed2 messages in com.marklogic.developer.general[MarkLogic Dev General] date scalar t...
FromSent OnAttachments
Rajesh KumarJan 10, 2018 4:31 am 
Harry BakkenJan 17, 2018 11:07 am 
Subject:[MarkLogic Dev General] date scalar type error in SQL view
From:Rajesh Kumar (
Date:Jan 10, 2018 4:31:57 am

Hi Team,

I'm trying on TDE concept of MarkLogic by connecting MarkLogic with Tableau. Created a template and facing an issue while viewing the schema. When scalar-type is defined as date , MarkLogic is returning error.

Sample Column defined:

<column> <name>createdOn</name> <scalar-type>date</scalar-type> <val>createdOn</val> </column>

SQL generated: SELECT 1 AS "Number of Records", Date("mtable"."createdOn") AS "createdOn", "mtable"."type" AS "type" FROM "matchTable"."mtable" "mtable" LIMIT 1000

error: [SQL] XDMP-UNDFUN: (err:XPST0017) Undefined function date()

Trying with MarkLogic version 9.0-3.1 and Tableau v10.4.2

Please help here.

Thanks, Rajesh