The CreatorCon Call for Content is officially open! Get started here.

Query a table from a UI page

Jon23
Mega Sage

I would like to create a form that will allow users to enter some information (name) which will then be used to query a table and return the results.

 

Looking at the wiki/forum it appears that a UI Page is a good option for this (correct me if i'm wrong).


Not being familiar with UI Pages and Jelly I am looking for some pointers/sample code on how to achieve this.

7 REPLIES 7

Michael Kaufman
Giga Guru

You can always use filters in ServiceNow to allow users to search. This works for a majority of customers.




You can create a module with the Link Type of Search Screen.   However that functionality is not used much anymore.




I also have an collection of blogs about ui pages you can check out too.   However that is probably not needed in this situation.   UI pages can get complicated to create.



mkaufman, Thanks for the reply.



I am looking at creating this for users (non ITIL) who have no experience with ServiceNow except for opening an incident or request.



Users would access the form to check if they are eligible for a hardware upgrade.



I will take a look at your blog and see if I can get a better understanding on how to create the UI page with the desired functionality.


I would also check out dynamic and scripted filters.



Dynamic Filters — ServiceNow ELITE.com



You could create a module that had a dynamic filter:



Assigned to Me AND Eligible is true


I'm actually in the process of implementing a very similar process, except for mobile phones. What did you ever find and how did you proceed on this item?



Thanks!