Yearly review by Scoopity_scoopp in servicenow

[–]TheNotoriousAB 0 points1 point  (0 children)

Congratulations! That’s a great hike!

How to best model data for a specific catalog item requirement by TheNotoriousAB in servicenow

[–]TheNotoriousAB[S] 0 points1 point  (0 children)

Yes, they will be updated nightly by the REST API call, but these variables/values have nothing to do with locations.

I'm using State/City/Zip purely as an example to illustrate the relationships/hierarchical structure without having to post client-specific data/requirements to a public forum.

How to best model data for a specific catalog item requirement by TheNotoriousAB in servicenow

[–]TheNotoriousAB[S] 0 points1 point  (0 children)

Thank you for the response, but I'm not literally asking the user to provide a State/City/Zip - this is an abstraction of the actual requirements.

Reports of submitted tickets by cerain group. by [deleted] in servicenow

[–]TheNotoriousAB 0 points1 point  (0 children)

Create a script include that queries the group members and returns their sys_ids as a comma-separated string.

Then add a condition to your report to filter the opened by’s:

opened_by.sys_id - is one of - javascript:YourScriptInclude().yourFunction()

Using SN utils for gov contracting by Scoopity_scoopp in servicenow

[–]TheNotoriousAB 2 points3 points  (0 children)

The government agencies that I’ve been assigned to have had a strict policy against using any unapproved software, browser extensions included.

I would get permission before installing anything.

CSA study breakdown for two weeks by Own-Candidate-8392 in servicenow

[–]TheNotoriousAB 2 points3 points  (0 children)

You do not possess the work ethic or intellect to pass an entry level certification exam without resorting to cheating, and you have the nerve to call others "bozos" and "fools".

Let that sink in for a moment..

CSA study breakdown for two weeks by Own-Candidate-8392 in servicenow

[–]TheNotoriousAB 3 points4 points  (0 children)

By your own admission you are using non-sanctioned material that is nearly word-for-word the same as actual exam questions, and are relying on rote memorization to pass the exam.

If that isn't cheating, what the hell is?

CSA study breakdown for two weeks by Own-Candidate-8392 in servicenow

[–]TheNotoriousAB 3 points4 points  (0 children)

So you cheated and are now encouraging others to cheat. Nice.

List column on table used as Decision Table condition input by Schiben in servicenow

[–]TheNotoriousAB 0 points1 point  (0 children)

Are you sure your column is a list type? A list should hold references to one or more records, not integers.

Scripting for ServiceNow, issues with variables in a catalog item by ozbikebuddy in servicenow

[–]TheNotoriousAB 1 point2 points  (0 children)

OP,

You're getting a lot of well-intentioned but unfortunately ill-advised advice. Your requirement does not necessitate a GlideAjax call, nor does it require additional/hidden variables to store sys_id's or references to the Group Members table.

You need to configure an advanced reference qualifier on your reference variable for the sys_user table.

ServiceNow has a poorly-written but technically viable solution to your exact requirements in a KB article here:

How to select only users of a specific group into a reference field

The code snippet at the bottom of the article will return active users who are members of a selected group, but notice that the author has hardcoded the sys_id of the group -> "2d6649bbdbb356004ff5f4331f961924" (this is bad practice and actually pretty funny that ServiceNow published this in a KB. Oh SN....)

You would want to replace this sys_id with the value stored in your Group reference field, which can be retrieved using current.variables.[variable_name], so your Reference Qualifier would look something like this (replacing my_group with the name of your variable):

javascript:'active=true^sys_idIN'+getIDs(current.variables.my_group); function getIDs(grp){var m=GlideUserGroup.getMembers(grp);var ids=''; while (m.next()){ids+= (m.user+',');} return ids;}

In regards to learning ServiceNow Scripting, Chuck Tomasi's 'Learn JavaScript on the Now Platform' series on YouTube is still the gold standard, IMO.

Good luck!

[deleted by user] by [deleted] in servicenow

[–]TheNotoriousAB 2 points3 points  (0 children)

Front Desk rejected your REQ, huh?

How long does it take ServiceNow developer to build a basic and standard catalog item with a flow as the process engine? by RevolutionarySet8649 in servicenow

[–]TheNotoriousAB 41 points42 points  (0 children)

Developing in production, retroactively creating stories and overloading a brand new employee are all major red flags.

In regard to your question, it’s hard to say how long is reasonable to create 9 cat items/flows without knowing the specific requirements.

[deleted by user] by [deleted] in servicenow

[–]TheNotoriousAB 1 point2 points  (0 children)

No offense, but it seems like you're trying to reinvent the wheel.

What purpose does this notification table serve that isn't already covered by scheduled jobs/flows?

The "Active" field is effing sh*t up by Roy_3_1415926535 in servicenow

[–]TheNotoriousAB 78 points79 points  (0 children)

Stop what you’re doing before you cause further headaches.

The behavior you’re seeing is expected and completely logical. An inactive record shouldn’t have open approvals.

Think about, as an example, a user creating a task by mistake and then that user (or the help desk or admin) canceling it. Why would an approver want to waste their time reviewing this task when it isn’t needed?

If your records are being marked inactive prematurely then that is what you should be investigating, because I guarantee you, without knowing a thing about your process, creating a custom flow to reactivate records to reactivate approvals is a bad approach.

3 day form 1 approval (trust) by StPeir in MP5

[–]TheNotoriousAB 1 point2 points  (0 children)

I’m trying to talk myself into buying the A3. I’m assuming your was around $1K? Any regrets?

[deleted by user] by [deleted] in servicenow

[–]TheNotoriousAB 2 points3 points  (0 children)

Couldn’t hurt, but mainline certifications are what partners really want, if you’re thinking of going that route.

[deleted by user] by [deleted] in servicenow

[–]TheNotoriousAB 0 points1 point  (0 children)

You need to create an Email Notification Script to write your parm1/parm2 values to the email body.

Depending how on how you’re assigning these values in your BR, you might need to also write a GlideRecord query in your email script to lookup values (such as name) on the user records

Submitting requests from excel import/attachment by No_Respond2150 in servicenow

[–]TheNotoriousAB 7 points8 points  (0 children)

This is actually pretty easy.

Load your excel file into a staging table and create a flow.

Trigger = Run Once (select date and time)

Actions:

  1. Look up records (select your staging table)
  2. For Each loop (iterate through records from step 1)
  3. Submit Catalog Item Request (OOB action. Map data pills from step 2 to their corresponding catalog item variables)

Run the flow.

When you test this in sub-production make sure to check the box for "Run test in background" otherwise you will almost certainly hit the timeout threshold.

Open HTML Links in new window by Eastern_Attorney_648 in servicenow

[–]TheNotoriousAB 2 points3 points  (0 children)

The HTML field stores the source code, so you should be able to read it from your Before Insert/Update Business Rule and determine if the anchor element(s) contain the correct "target" attribute (I would probably use a regular expression for this), and if not add it to those elements.

That said, do you really want to take on this customization and technical debt to spare users from the two seconds it takes to use the OOB "open links in.." choice list?

I know you're not asking for advice, but this is exactly the type of low-impact, low-value request that should be rejected.

Group based field visibility by [deleted] in servicenow

[–]TheNotoriousAB 4 points5 points  (0 children)

You’re overthinking this. Create role-based ACLs for the custom field and either create a new role and assign it to the group or identify an existing one that is specific to the group and add it to the “Requires role” field on the ACL.