How can we able to Search record from List of records - ATF

chanikya
Tera Guru

Hi,

is it possible to search a particular record from List of total records 

Usually what we do for particular record  in Number Column search we will mention Record number so then it will displays record if that record was available in list  , as the same way can we able to search a record from ATF .

 

is it Possible to search by ATF

find_real_file.png

1 ACCEPTED SOLUTION

georgimavrodiev
Mega Guru

Hello Chanikya,



In order to achieve exactly what you explained: finding a record by record number if it exists in the respective table -> you may use 'Record Query' step by selecting the appropriate table and then adding a 'Condition' such as: Number | is | PRB0040029 (taken from your screenshot example).
Make a short test to check this out by creating 3 steps:
- Impersonate to an itil user;
- Run Record Query against Problem (problem) table by adding the condition I mentioned above;
- use Open an Existing Record step against Problem (problem) table and selecting Steps 2: Record Query > First record;

You may also use Form step 'Open an Existing Record' and specify the record there by number and selecting the respective table first. For references in regards to this approach (Open an Existing Record, without 'Record Query') please review the OOB ATF test, called: "Open an Existing Record".



Cheers, Chanikya!



Best Regards,
Georgi Mavordiev

IT Consultant
Do IT Wise Bulgaria

You may visit us in our Web Site: www.doitwise.com


View solution in original post

3 REPLIES 3

georgimavrodiev
Mega Guru

Hello Chanikya,



In order to achieve exactly what you explained: finding a record by record number if it exists in the respective table -> you may use 'Record Query' step by selecting the appropriate table and then adding a 'Condition' such as: Number | is | PRB0040029 (taken from your screenshot example).
Make a short test to check this out by creating 3 steps:
- Impersonate to an itil user;
- Run Record Query against Problem (problem) table by adding the condition I mentioned above;
- use Open an Existing Record step against Problem (problem) table and selecting Steps 2: Record Query > First record;

You may also use Form step 'Open an Existing Record' and specify the record there by number and selecting the respective table first. For references in regards to this approach (Open an Existing Record, without 'Record Query') please review the OOB ATF test, called: "Open an Existing Record".



Cheers, Chanikya!



Best Regards,
Georgi Mavordiev

IT Consultant
Do IT Wise Bulgaria

You may visit us in our Web Site: www.doitwise.com


Hello Chanikya,



Hope you had a relaxing weekend!


Could you please let me know if you reviewed the above approaches I offered and did you have chance to perform testing on them?

Let me know if something is unclear and also if the information was of use to you. Thank you!


Best Regards,
Georgi Mavrodiev

IT Consultant
Do IT Wise Bulgaria

You may visit us in our Web Site: www.doitwise.com

it is great help for me from your end

 

Thanks a lot! Really thankful to you