SQL syntax in TM1

[Dimitri]

Hi,

I have a problem of having two elements in SQL query in TM1 when sourcing from ODBC:

Here is the code of query

SELECT
UD_BOM_TICKET.USERS_ID,
..........................
FROM UD_BOM_TICKET, .....

WHERE
TICKET_TYPE.TICKET_TYPE_ID = UD_BOM_TICKET.TICKET_TYPE_ID
.......
AND
SUBSTR(ISSUE_DATE,4,6) = IN ( '?pUploadPeriodPrev?' , '?pUploadPeriodPrevPrev?' )

It says that statement failed.

If I include only SUBSTR(ISSUE_DATE,4,6) = '?pUploadPeriodPrev?' - it perfectly works

pUploadPeriodPrev and pUploadPeriodPrevPrev are defined in the prolog.

Please advise how to include two elements in sql query in TM1 ODBC query.

Thank you,

Dimitri

[LoadzaGrunt]

SUBSTR(ISSUE_DATE,4,6) = IN ( '?pUploadPeriodPrev?' , '?pUploadPeriodPrevPrev?' )

Lose the equals sign and try it again:

Code: Select all

SUBSTR(ISSUE_DATE,4,6) IN ( '?pUploadPeriodPrev?' , '?pUploadPeriodPrevPrev?' )

[Dimitri]

Grunt, you are the Legend.

It worked.

Thank you for the quick reply,

Dimitri