Text object Action

apthansh — Wed, 25 Nov 2020 16:16:04 GMT

I have 2 list boxes - Status and Type.

Status

Active

Inactive

Type

Rent

Non-Rent

When I click on the text object I want everything to be selected from Status and Type except Inactive.Is this doable ?

Thank you much.

Re: Text object Action

Kushal_Chawda — Thu, 15 Jun 2017 12:31:25 GMT

go to action tab of text object, add two actions like below

1) To select status

Add action-> Select in Field ->

field : Status

value : '(' & concat(DISTINCT chr(39) & if(Status<>'Inactive',Status) & chr(39),',') &')'

2) To select Type

Add action-> Select in Field ->

field : Type

value : '(' & concat(DISTINCT chr(39) & Type & chr(39),',') &')'