Using Updated as a query filter for lookupobjects

[Ste404]

Hi there,

I want to put into a query for a lookupobjects call a limiter to only return records that were updated within the last 4 hours.

So I have this for example

ObjectType = Laptops and "Name" IS NOT empty AND "Model_d" IS NOT empty 

but when I put any sort of variant of 'AND Updated #####' the query fails.

Can I use updated as part of a query for lookupobjects?

[Joseph Chung Yin · Accepted solution]

@Ste404 -

Yes, you just need to add the following to your JQL 

updated >= -4h

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

[Dawid Joshua _TechTime_ · Accepted solution]

Hi @Ste404 ,

Try this:

<your query> AND updated >= -4h 

[Ste404]

ah gaaaawd I was forgetting the -

<insert facepalm here>