How to do the below requirement?

[gkcchowdary]

Hi

I have two tables like table1 and table2.

Table1 having workflowname field  and table2 having workflow name and Alis name field.

My requirement is which workflow name having alias name need show alias name or if alias name not available it showing workflow name only.

Like below

Work flowname.     Aliasname

Wk100                      wk100

Wk200                      Wk200

Wk300                      ABC

Wk400.                     DDD

Above table wk100 and wk200 not having aliasname .So aliasname also display workflow name.

Wk300 and wk400 having aliasname .so it displays aliasname.

How to do this chart level and script level.

Thanks

[poojashribanger]

you can use MapSubString('table_name',column_name)

[Anonymous]

in the back end use the following code,

if(isnull(Aliasname), [Work flowname], Aliasname) as [Aliasname]

What its doing is checking if Aliasname is blank or null and then replacing the null with Work flowname if its not null then dont change in field Aliasname

[gkcchowdary]

Hi Alexander if get any idea on below requirement please help on this.

I want do in back end level(script)

target date changed count the ID's.

I have table fields

table:

Issu_ID

date_upload

Taget_date

-> KPI chart if the user selects any two dates compare those two dates.if maximum date and maximum previous dates in the Taget_date field are different then caluclate the count id's.

Example:

Issue_ID      Date_upload      Target_date

01                01-01-2018           10-05-2018

01                03-01-2018           15-05-2018

02                01-01-2018           10-05-2018

02                03-01-2018           10-05-2018

03                01-01-2018           10-05-2018

03                03-01-2018           16-05-2018

In the above table if we select dates in the date upload field i.e., 01-01-2018 and 03-01-2018 then count is 2 because id 01,03 target dates are changed and id 02 target dates are not changed.

so just count the Issues_ID when user select any two dates(ex:01-01-2018 is min date and 03-01-2018 is max date)compare those two dates if min date targetdate is onedate and max date targetdate is change to another date than caliculate the Issues_ID count.

I need quires for the above requirements in the back-end level.and write the expression front end level also if any simple way.

I have written quires in the front end level but the performance is slow and it is showing an error in the chart i.e., time out.

Thanking you.