Skip to main content
Question

Lobby projection data source use of SYSDATE

  • April 19, 2024
  • 3 replies
  • 274 views
R
Do Gooder (Employee)
Forum|alt.badge.img+2

We have used SQL Views as data sources in Lobby Data source designer,  however in process of migrating them into projections, we need to replace “where” conditions to “filters” in new projection data sources and needs a solution to replace SYSDATE parameter used in SQL Views. Workaround tried to replace SYSDATE was unsuccessful.

Screenshot attached.

We could use a Query in the projection and could migrate the logic to projection yet this filter conditions are being used as in navigation links in Lobby Elements.

 

 

3 replies

R
Do Gooder (Employee)
Forum|alt.badge.img+2
  • Rohan Perera
  • Author
  • Do Gooder (Employee)
  • April 20, 2024

For SQL SYSDATE now() can be used, however still I did not get any option for advanced uses of SYSDATE such as SYSDATE+1 with now() function

D
G
Hero (Customer)
Forum|alt.badge.img+11
  • gianni.neves
  • Hero (Customer)
  • November 4, 2024

Hi @Rohan Perera,

 

I am trying to use SYSDATE on my filter and I am having the message below as error:

none>/<none> (server error)
Malformed Request.
Error details: [{"code":"TYPES_NOT_COMPATIBLE","message":"The types 'Edm.Boolean' and 'Edm.Date' are not compatible."}]

Any idea why this is happening? I am using exactly as other lobbies. The difference, this one is a projection data source.

DateEntered >= SYSDATE

Thanks,

E
PRODQ
Superhero (Customer)
Forum|alt.badge.img+18
  • PRODQ
  • Superhero (Customer)
  • January 21, 2025

Hi @Rohan Perera,

 

I am trying to use SYSDATE on my filter and I am having the message below as error:

none>/<none> (server error)
Malformed Request.
Error details: [{"code":"TYPES_NOT_COMPATIBLE","message":"The types 'Edm.Boolean' and 'Edm.Date' are not compatible."}]

Any idea why this is happening? I am using exactly as other lobbies. The difference, this one is a projection data source.

DateEntered >= SYSDATE

Thanks,

We had this same message on a Lobby we were working on - in our case the navigation syntax we entered was wrong.  We had inadvertently been using InvoiceDate = #TODAY# rather than eq #TODAY#.

 

I don’t know if this helps or not! 

 

Linda
E
Terms & ConditionsCookie settingsAccessibility statement