Changing a field's value on the database from boolean to string value

[S_T14 (Shaun)]

The below display field “Inactive” is a true/false format inside the AC_SegAccom table.

This value is displayed once the below checkbox is clicked or not clicked and displayed on the below dashboard.

I have tried to convert the value from a boolean to a string inside the “Extended Properties” screen however it’s greyed out and I cannot access it.

I have approached this problem by trying to convert the boolean value to a string value and displaying the options as a dropdown that allows the user to select true/false OR yes/no (depending on whatever the client wants) and the dashboard will display a text value rather than a ticked or not ticked checkbox, refer to the below attempt (the default value is false) plus I also get this error if I try to select the dropdown:

Is this the right approach? This is being done all in a BAQ and I’m also wondering if I can potentially put a calculated value field filtering if the inactive status is equal to true or false then display a text value displaying yes/no (true/false)

Any help is greatly appreciated!

[Mark_Wonsil]

@S_T14

I’m also wondering if I can potentially put a calculated value field filtering if the inactive status is equal to true or false then display a text value displaying yes/no (true/false)

Yes you don’t want to and frankly can’t change any of the schema types, length, etc of standard fields.

You can use the Sub Query Criteria on the BAQ to filter by calculated fields.

[S_T14 (Shaun)]

Sorry, so you’re saying the calculated value field for example:

case
when [AC_SegAccom][Inactive] = false
display ‘false’
when [AC_SegAccom[inactive] = true
display ‘true’

Would work in a sub query? Even though it’s a string value not a Boolean value? Would this display a string value in place of a checkbox?

Apologies for the syntax errors I’m on a phone.

[Mark_Wonsil]

Maybe we can step back and describe what you’re trying to do from a business (not technical) perspective. For example:

As an accountant
I want to report all inactive segments
So I can remove them from the budget.

But yes, you can filter a subquery by a calculated field:

[S_T14 (Shaun)]

Okay, from a business stand point an employee goes into the accommodation segment form and fills out the details. Ticking the box means a room is inactive.

I have created the below calculated field.

I’m unsure what to do in relation to the subquery. I currently have this sub query criteria in place howveer I’m new to this sub query stuff. This is also in the Main BAQ reflected below.