Skip to main content
Solved

Lobby - Data Source = Info Source - Can't pass condition


Forum|alt.badge.img+9
  • Sidekick (Customer)
  • 66 replies

Hello experts,

Please see screenshots below. We are able to use conditions in a Data Source type SQL. (first screenshot). We are on IFS10 UPD13.

Could you please confirm that this is not possible in a Data Source type Info Source (second screenshot) ?

I wanted to insert a new Lobby Element using the Info Source BUT I cannot pass the parameters in the Lobby page (Project ID and Sub-Project ID) because I cannot setup a condition in the new info source.

I hope this makes sense.

Many thanks

Miguel

 

 

 

 

 

Best answer by Miguel

@Link , I have solved this, as I was guessing it was the syntax at the filter level. The syntax below has worked like a gem ;-)

 

$PROJECT_ID$

$SUB_PROJECT_ID$

View original
Did this topic help you find an answer to your question?

9 replies

Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1169 replies
  • June 16, 2022

Hi @Miguel 

conditions are also possible in a information source.

You have to put the columns by drag and drop in the field “Filters”.

SQL statements are not possible there.


Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 66 replies
  • June 16, 2022

Hi @Link 

Many thanks, that makes sense.

Could you please let me know if you see anything wrong with my syntax for the condition/filter below?

UPPER('$PROJECT_ID$')

UPPER('$SUB_PROJECT_ID$')

At the moment this syntax is not working for me in the lobby where these parameters are passed to the lobby element linked to this info source

Miguel

 

 


Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1169 replies
  • June 16, 2022

Hi @Miguel 

i think this approach won’t work. Because the column “Value” expect a value from data base.

Did you test it? Click on the button “Preview” on the same screen to test it.


Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 66 replies
  • June 16, 2022

Hi @Link 

Thank you, yes I tested and it does not return any values.

I would be surprise if there is no way to pass parameters from the Lobby header to a Lobby Element that uses a Data Source type Info Source. Surely this is possible somehow.

I think your suggestion is a good one, and I think the syntax is just not right. I don’t get an error message so I don’t think we are barking to the wrong tree ;-)

Miguel


Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1169 replies
  • June 16, 2022

Hi @Miguel 

to be hones I wouldn’t be suprised if there isn’t way to pass it. :-)

You don’t get an error message? Even if you type a value for the parameter?

 


Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 66 replies
  • June 16, 2022

@Link 

if I type values for the parameter, keeping the filters, I just get an empty table, please see screenshot.

So no error message

Miguel

 

 


Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 66 replies
  • Answer
  • June 16, 2022

@Link , I have solved this, as I was guessing it was the syntax at the filter level. The syntax below has worked like a gem ;-)

 

$PROJECT_ID$

$SUB_PROJECT_ID$


Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1169 replies
  • June 16, 2022

And what happen if you type the values directly in the column “Value”?

Does it show something?


Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 66 replies
  • June 16, 2022

@Link hardcoding values in the column value is standard functionality and yes that works, but been able to pass a parameter is more interesting. As I said changing the syntaxes of the parameterised value has worked for me. Many thanks for your initial input.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings