topic Re: how to write expression based on status in two tables in App Development

how to write expression based on status in two tables

Sra1bandi — Thu, 08 Jun 2023 10:21:30 GMT

Hi Team,

I have two tables with different data with one primary key

TABLE1:-

load* ,inline[

Id , Wf_Status

1, Closed

1, open]

Table2:-

load* ,inline[

Id , TK_Status

1, Completed

1, Started

1, ready

1, Committed]

My required table is

in 1st table when i filter with Wf_status='Open'

in 2nd table i need to exclude TK_Status='Completed' need to show other three values.

Output data====>

Table1:

Id Wf_Status

1 open

TBLE2:

id TK_Status

1 Started

1 ready

1 Committed

Regards,

Sravan.

Re: how to write expression based on status in two tables

BrunPierre — Fri, 09 Jun 2023 22:25:10 GMT

@Sra1bandi As below.

Table2:
load * inline[
Id , Wf_Status
1, Closed
1, Open ]
Where Match(Wf_Status,'Open');

Table2:
load * inline[
Id , TK_Status
1, Completed
1, Completed
1, Started
1, ready
1, Committed ]
Where Match(TK_Status,'Completed') = 0;

Re: how to write expression based on status in two tables

sidhiq91 — Sat, 10 Jun 2023 03:48:21 GMT

@Sra1bandi You can try something like below too:

NoConcatenate
Table2:
load * inline [
Id , Wf_Status
1, Closed
1, Open ]
Where Match(Wf_Status,'Open');

NoConcatenate
Table2:
load * inline [
Id , TK_Status
1, Completed
1, Completed
1, Started
1, ready
1, Committed ]
Where not Match(TK_Status,'Completed');

Exit Script;

Re: how to write expression based on status in two tables

Sra1bandi — Tue, 13 Jun 2023 09:48:23 GMT

Hi Both

Thanks for reply but i need in front end not in back end

i have two tables

i need to show all data

when i select open cases in table then only i need to apply above mentioned conditions

Reagrds,

Sravan.

Re: how to write expression based on status in two tables

BrunPierre — Tue, 13 Jun 2023 10:26:08 GMT

In that case, use Wf_Status and TK_Status fields as filter panes/list boxes?