Skip to main content
Solved

Using SQL expressions in Aurena page advance search

  • June 2, 2021
  • 6 replies
  • 755 views
dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • dsj
  • Ultimate Hero (Partner)

Hi All,

 

We can use SQL expressions in IFS EE advanced option

 

Seems this type of search expression is invalid in Aurena and it doesn’t like the SQL part. Is there a way to use SQL expressions in Aurena queries?

 

Best answer by Xavier Fernando

Hi @sutekh137  and @dsj  i added web page as a zip file. 

Please note attachment is more details about Aurena search and requested functionality is not available at the moment. 

 

Hi @Xavier Fernando ,

 

Seems the images in the file are not included. Can you please reupload or perhaps convert page to pdf and upload?

 

Thanks a lot!

Damith

Hope this works.

DSJ - https://dsj23.me
X
Keerthie Maruthapillai
S
This topic has been closed for replies.

6 replies

S
Hero
Forum|alt.badge.img+12
  • sutekh137
  • Hero
  • June 2, 2021

Bump…  This is a big deal for us as well, would love to be able to use more advanced SQL expressions in Aurena searches.

 

Thanks,

JoeK

Just because something is part of a plan doesn't make it right.
X
X
Superhero (Employee)
Forum|alt.badge.img+20

Dear @dsj  and @sutekh137 

I believe SQL search is not possible on the current version and something for future development

Please refer below documentation for the more details about Aurena search.
http://techblogs/uxx/?cat=56


Hope this helps

dsj
D
S
S
Hero
Forum|alt.badge.img+12
  • sutekh137
  • Hero
  • June 2, 2021

Dear @dsj  and @sutekh137 

I believe SQL search is not possible on the current version and something for future development

Please refer below documentation for the more details about Aurena search.
http://techblogs/uxx/?cat=56


Hope this helps

 

 

Xavier, thanks for the response. However, the link you refer to did not come up with anything for me, just “This site cannot be reached”.

 

Thanks,

JoeK

Just because something is part of a plan doesn't make it right.
X
D
X
Superhero (Employee)
Forum|alt.badge.img+20

Hi @sutekh137  and @dsj  i added web page as a zip file. 

Please note attachment is more details about Aurena search and requested functionality is not available at the moment. 

1 Attachments
dsj
D
S
dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • dsj
  • Author
  • Ultimate Hero (Partner)
  • June 4, 2021

Hi @sutekh137  and @dsj  i added web page as a zip file. 

Please note attachment is more details about Aurena search and requested functionality is not available at the moment. 

 

Hi @Xavier Fernando ,

 

Seems the images in the file are not included. Can you please reupload or perhaps convert page to pdf and upload?

 

Thanks a lot!

Damith

DSJ - https://dsj23.me
B
X
Superhero (Employee)
Forum|alt.badge.img+20
  • Xavier Fernando
  • Superhero (Employee)
  • Answer
  • June 4, 2021

Hi @sutekh137  and @dsj  i added web page as a zip file. 

Please note attachment is more details about Aurena search and requested functionality is not available at the moment. 

 

Hi @Xavier Fernando ,

 

Seems the images in the file are not included. Can you please reupload or perhaps convert page to pdf and upload?

 

Thanks a lot!

Damith

Hope this works.

1 Attachments
D
dsj
D
Terms & ConditionsCookie settingsAccessibility statement