[MarkLogic Dev General] date scalar type error in SQL view

Rajesh Kumar rajava543 at gmail.com
Wed Jan 10 04:31:57 PST 2018


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://developer.marklogic.com/pipermail/general/attachments/20180110/e5e38ba2/attachment-0001.html 


More information about the General mailing list