Hi,
I want to check the Filter is working correctly in the Web Page
In the Serial We can Enter the Combination of Value
Ex:
Enter Like This
The Results of DataTable Values are
The (Asteric ) is the Give the Values Before (1G)
In This Case I Create a Test Cases for Verfiy the Filter DT only the Values of before(1G)
And Also In the Serial Type Box We can also Enter the Values like
For Ex:
Prefix Value(ZS(Asteric Sysmbol)) Its Filters The DT Values
(
ZS2932ids
ZS9fjo333
) Like That
I Try this Expression
But its Fails,
Im Using Matches Activity First Time
Can u Suggested the Correct Pattern In ths Matchs For My WorkFlow?
Yoichi
(Yoichi)
January 1, 2022, 10:35am
2
Hi,
Can you share an expression at Input property of Matches?
I suppose it should be as the following. Can you try this?
String.Join(vbCrLf,ExtractDataTable.AsEnumerable.Select(Function(r) r(0).ToString()))
Or we can also check it using FilterDataTable activity as the following.
Regards,
Hi @Yoichi ,
In the web page In the Serial Tab Enters the Value its Filter the Data Table
I just want to Verify the DT is equals as per the Serial Table Values
I modify few thing in the workflow
The IsMatch Full Expression
verfiy the DT with the IsMatch activity the results is True or False
But i Run this the results was False
Can u plz tell about my workflows are Correct And Suggests a Correct Expression for ISMatch Activity
HI @Rajiduraikannu_Santhosh_G
As $ at last of ZS
Regards
Sudharsan
HI @Sudharsan_Ka ,
thanks you for ur correction,
But i run the workflow the Results was False but the Check the DataTable Filter was Correct.
If I change the verify activity into the for each loop its work correct or not? Can u plz suggestion the correct step for this?
Regards,
Santhosh
Yoichi
(Yoichi)
January 3, 2022, 1:26pm
8
Hi,
Can you share your workflow as file, if possible?
Regards,
arivu96
(Arivazhagan A)
January 3, 2022, 1:32pm
9
Hi @Rajiduraikannu_Santhosh_G
use below query to filter only start with ZS in the datatable column
dt.select("ColumnName like 'ZS%'").CopyToDataTable()
If you want to dynamic use below
string variable Val=β*1Gβ
dt.select("ColumnName like '"+Val.ToString().Replace("*","%")+"'").CopyToDataTable()
Regards,
Arivu
Thanks for ur suggestion @arivu96 ,
I want dynamic its so useful for me,
I Try this method
I got this Error
arivu96
(Arivazhagan A)
January 3, 2022, 2:13pm
11
Hi ,
Like keyword is missing in the syntax.
DT.Select("Serial like '"+GetSerial.ToString().Replace("*","%")+"'").CopyToDataTable()
Regards,
Arivu
Hi @arivu96 ,
I correct the code and run the workflow
In the Log Message No Values Display?
arivu96
(Arivazhagan A)
January 3, 2022, 3:46pm
13
In log message what you have given.
Regards,
Arivu
This code i set in the log message fo check the values
arivu96
(Arivazhagan A)
January 3, 2022, 3:50pm
15
The above code will return the datatable as output. if you want to print the table, use output datatable activity and print the output in log message
Regards,
Arivu
Can u explain about this, how can i verify with the datatable?
arivu96
(Arivazhagan A)
January 3, 2022, 5:04pm
17
Hi @Rajiduraikannu_Santhosh_G ,
Use output data table activity
Regards,
Arivu
1 Like
Hi @arivu96 ,
Can u plz suggested that this format is correct or not?
hi @arivu96 ,
can u rply for this?
arivu96
(Arivazhagan A)
January 4, 2022, 11:03am
20
Why are you using Regex pattern here.