Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

How to get to catalog request using ATF

Troy25
Kilo Contributor

Hey guys,

I am trying to test a catalog request using the Automated Test Framework (ATF).  I would like to validate some fields in the sc_request table after ordering a Catalog Item.  So I am wondering how to I open an existing request that I just created.

Steps used in ATF:

Impersonate User

Open a Catalog Item

Set Variable Values

Order Catalog Item

I can query the request item using the following:

find_real_file.png

I can also query the catalog task using

find_real_file.png

However, how do I query the request in the sc_request table so that I can then open up the form?

Thanks in advance

Troy

1 ACCEPTED SOLUTION

Community Alums
Not applicable

Oh Okay got it. Can you try this to get the REQ and open the REQ form-

 

Give Sys ID instead of Request in the Conditions-

 

find_real_file.png

 

Data pill chosen is-

find_real_file.png

View solution in original post

10 REPLIES 10

Community Alums
Not applicable

After Order Catalog Item Step-

 

1. Create 'Record Query' Step with below conditions

find_real_file.png2. Create 'Open an Existing Record' Step with below conditions

 

find_real_file.png

Thanks Shruthiub, however in the screenshots you are opening the request item (sc_req_item) not the request (sc_request).

If I use the same for the sc_request table, I get an error:

FAILURE: No records matching query:
Request = (empty)

Community Alums
Not applicable

Oh Okay got it. Can you try this to get the REQ and open the REQ form-

 

Give Sys ID instead of Request in the Conditions-

 

find_real_file.png

 

Data pill chosen is-

find_real_file.png

Thanks for the reply shruthiub.  I tried that and unfortunately received an error:

find_real_file.png

find_real_file.png

 

find_real_file.png

 

Would you have any other suggestions?

 

Cheers

Troy