Skip to main content

Is it possible to view a lobby element in Aurena with the default parameters null?

I have created a lobby that opens with a parameter populated by default as the majority of the business needs to see the data with this particular filter. However,  there is one user who would like to view the lobby with no filters applied. The SQL conditions on the data source designer for the effected lobby elements are built so that a null value in the parameter would return the unfiltered data. 

In EE for IFS 10 and in Aurena, when I manually delete the default parameter value, it auto-populates when I hit return. I don’t seem to be able to delete the default value and leave it null. 

Is this possible, or do I need to redesign the SQL conditions so that the unfiltered data comes through when I change the parameter value to some other text?

 

Hello,

Did you find a solution for your issue? 

I’m trying to design an Element where if the user manually deletes the input value of the parameter (a date), it will return the unfiltered data. It seems like you managed to do it, from the Datasource Designer.

 

Could you please share your solution?

 

Thanks in advance!

Mihai

Hello,

Did you find a solution for your issue? 

I’m trying to design an Element where if the user manually deletes the input value of the parameter (a date), it will return the unfiltered data. It seems like you managed to do it, from the Datasource Designer.

 

Could you please share your solution?

 

Thanks in advance!

Mihai

I forgot to add my SQL conditions:

('$SPECIFIC_DATE$') >= allocation_start
and ('$SPECIFIC_DATE$') <= allocation_end

 

The query works, brings the desired results. I just want to add, if possible, when the user does not enter a date, to show up all the values.

 

TO_DATE(NVL( does not work unfortunately.

 

Thanks!

Reply


Terms & ConditionsCookie settings