If/ElseIf/Else & custom database fields.

[G. Brady]

Hello there!

I have been stuck on this issue for some time now.

On the pages application I have a database which displays open vacancies within my community, which looks like the following:

When the database record is 'Closed' (custom field key status2 === 1) I want the apply button to be disabled.

When the database record is 'Hiring' (custom field key status2 === 2) I want the apply button to be enabled.

Within Database templates i'm aware that if & else statements are usable, however I can't work out how to write the if expression. I've tried everything i can think of and can not get it to work. Does anyone know how I would get this to work?

Below is an example of what I have tried.

After hours of research myself, these are the only two articles that i could find.
https://invisioncommunity.com/4guides/themes-and-customizations/template-syntax/ifelseifelse-logic-r138/
https://invisioncommunity.com/forums/topic/408319-if-statement-for-custom-field/

If anyone could work out how to do this, I will love you forever! <3

 

[BattleKing]

please try the comparison with two = instead of three, maybe this solve your issue:

==	Equal	Returns true if $x is equal to $y
===	Identical	Returns true if $x is equal to $y, and they are of the same type

 

[G. Brady]

please try the comparison with two = instead of three, maybe this solve your issue:

==	Equal	Returns true if $x is equal to $y
===	Identical	Returns true if $x is equal to $y, and they are of the same type

BattleKingI have put:

{{if intval( $status2 ) == 1}}
<a style="margin: 5px;" class="ipsButton ipsButton_medium ipsButton_primary ipsButton_disabled" href="{$row->customFieldDisplayByKey('url', 'listing')|raw}" target="_self">Apply</a>
{{else}}
<a style="margin: 5px;" class="ipsButton ipsButton_medium ipsButton_primary" href="{$row->customFieldDisplayByKey('url', 'listing')|raw}" target="_self">Apply</a>   
{{endif}}

however both records have the second html snippet.

 

[BattleKing]

I have put:

{{if intval( $status2 ) == 1}}
<a style="margin: 5px;" class="ipsButton ipsButton_medium ipsButton_primary ipsButton_disabled" href="{$row->customFieldDisplayByKey('url', 'listing')|raw}" target="_self">Apply</a>
{{else}}
<a style="margin: 5px;" class="ipsButton ipsButton_medium ipsButton_primary" href="{$row->customFieldDisplayByKey('url', 'listing')|raw}" target="_self">Apply</a>   
{{endif}}

however both records have the second html snippet.

G. Bradytry to display the value of intval($status2) to see what is in there.

 

[G. Brady]

try to display the value of intval($status2) to see what is in there.

BattleKingHow do I display it?

Would $status2 give the key, or the value?

 

[BattleKing]

How do I display it?

Would $status2 give the key, or the value?

G. Bradytake a look into this one: https://invisioncommunity.com/4guides/themes-and-customizations/template-syntax/variables-r141/

try if that works:

{{var_dump( $variable );exit;}}
Not sure you need the EXIT; you need to try.

 

[G. Brady]

take a look into this one: https://invisioncommunity.com/4guides/themes-and-customizations/template-syntax/variables-r141/

BattleKingHere's what {$row->customFieldDisplayByKey('status2')} displays:

{$row->customFieldDisplayByKey('status2', 'listing')|raw}:

{$row->customFieldDisplayByKey('status2')|raw}:

 

[BattleKing]

Here's what {$row->customFieldDisplayByKey('status2')} displays:

{$row->customFieldDisplayByKey('status2', 'listing')|raw}:

{$row->customFieldDisplayByKey('status2')|raw}:

G. Bradytry {{if intval( $status2 ) == 'Closed'}}

and please could you show us how you have assigned the content to $status2

 

[G. Brady]

try {{if intval( $status2 ) == 'Closed'}}

and please could you show us how you have assigned the content to $status2

BattleKing

It does not accept the if statement you provided,

Here is the custom field settings:

 

[BattleKing]

It does not accept the if statement you provided,

Here is the custom field settings:

G. Brady{{if {$row->customFieldDisplayByKey('status2', 'listing')|raw} == 'Closed' }}
or with
{{if {$row->customFieldDisplayByKey('status2', 'listing')|raw} == "Closed" }}

 

[G. Brady]

{{if {$row->customFieldDisplayByKey('status2', 'listing')|raw} == 'Closed' }}
or with
{{if {$row->customFieldDisplayByKey('status2', 'listing')|raw} == "Closed" }}

BattleKingBoth of these make this error:
The syntax of tags or HTML logic is badly formatted.

 

[BattleKing]

Both of these make this error:
The syntax of tags or HTML logic is badly formatted.

G. BradySorry, I have no running IPS board where I can check it
What happened if you display
{intval($status2}
{($status2}

 

[G. Brady]

Sorry, I have no running IPS board where I can check it
What happened if you display
{intval($status2}
{($status2}

BattleKingWhat do you mean assigned to?

Here is the result:

 

[FNC1]

please try the comparison with two = instead of three, maybe this solve your issue:

==	Equal	Returns true if $x is equal to $y
===	Identical	Returns true if $x is equal to $y, and they are of the same type

BattleKingHe already put intval to his variable so both of them integer. "===" and "==" same on this expression.

 

[G. Brady]

So after some more messing around, I've found out I can use the 'display' setting to simply get a 'Closed' or 'Hiring' value. (instead of the 'listing' value which also includes all of the HTML snippet.

With this code:

{$row->customFieldDisplayByKey('status2', 'display')|raw}

I get:

and if the custom field is set to hiring:

So how do i get this {$row->customFieldDisplayByKey('status2', 'display')|raw} into an if statement?

 

[G. Brady]

I have achieved the impossible!

I managed to get it to work. To do this I used the code:
{{if $row->customFieldDisplayByKey('status2', 'display') == "Closed" }}

and in the custom field enabled: 'Show in display template' then set it to no formatting.

Thank you so much @BattleKing

 

[FNC1]

I don't know how are you calling the query but just use \IPS\Db::i()->select('selected','tablename',array('id=?', $id))->first(); to bring data.
'SELECT selected FROM `tablename` WHERE id IS $id'
Also, make sure the selected item exists. Otherwise it'll return 500.

$myVar = \IPS\Db::i()->select('selected','tablename',array('id=?', $id))
if (count($myVar) != 0) $myVar = $myVar->first(); else (do something because user waits for something.)