Text object Action

[apthansh]

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.

[Kushal_Chawda]

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),',') &')'