Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
you can use MapSubString('table_name',column_name)
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
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.