Check Object Existence

RE: Check Object Existence

Mike Schmitt — Wed, 16 Oct 2024 12:28:04 GMT

Now that this plug-in has been archived, everyone should replace the functionality using the Content Tools plug-in, namely using the "Get Content Object Details By Id" function.

This function can check for the mere existence of an item at that ID, e.g.
[embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:9aca1b6b-b3f1-4dde-acee-7d9efc256139:type=java&text=getcontentobjectdetailsbyid%28ri%21id%29%20%3C%3E%20%22No%20object%20with%20this%20ID%20has%20been%20found%22]

but also, it can be used (in one pass) to check specifically for Document or Folder IDs, e.g.
[embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:e36b67de-b036-4ea7-93ce-d6f74902c061:type=java&text=find%28%0A%20%20%22Type%3A%20Document%2C%22%2C%0A%20%20getcontentobjectdetailsbyid%28ri%21docId%29%0A%29%20%3E%200%0A%0A%2F%2A%20or...%20%2A%2F%0A%0Afind%28%0A%20%20%22Type%3A%20Folder%2C%22%2C%0A%20%20getcontentobjectdetailsbyid%28ri%21folderId%29%0A%29%20%3E%200]

As always, I recommend staging your own "helper expression rules" to handle null-checks and other housekeeping at the same time as calling the rule, to facilitate re-use and code-readability. See my slightly older comment here for an example recipe.

RE: Check Object Existence

ianjesusg0002 — Sun, 17 Jul 2022 05:34:42 GMT

can anyone help me with this? Thank You [emoticon:6d505171faa4497c85c5ca27290c555d]

RE: Check Object Existence

Arpit Pipersaniya — Fri, 13 May 2022 08:56:42 GMT

[mention:f81052d71c6f44b99e15a76dec63b379:e9ed411860ed4f2ba0265705b8793d05]
Is this compatible with 21.4v of Appian Cloud?

Threw this error yesterday:
=isobjectexists("Document",pv!documentZIP) (Expression evaluation error at function 'isobjectexists': The passed parameter(s) are of the wrong type. Received the type com.appiancorp.common.xml.JaxbConversionException: JAXB was not able to produce a value for typed value TypedValue[it=3,v=[Document:533750]] as java class java.lang.Long.)

And when I checked the following manually in an unnamed ER:
isobjectexists("Document",533750)
Then this returns true.

Any suggestions, please?

Thank you.

RE: Check Object Existence

Richard Michaelis — Wed, 09 Jun 2021 05:56:15 GMT

Short information:
If you check for an ID and there is no object of the defined type with this Id, it will create a log entry.
I tried this function to search for all groupIds in a system.
Idea was: loop and enumerate all IDs and then return the ids which are existing. yeah....

-> I made our tomcat crash as i was creating 5 GB and more in log files because most groupIds i was checking are not in Use -> log entry -> huge log size in a short time.

RE: Check Object Existence

isaace — Thu, 20 May 2021 19:41:46 GMT

thank you so much for this plug-in! I'm really surprised that there isn't a "native" function that does this. Solves a major issue I've had between different environments that have duplicated tables, but not duplicated folders/documents :)

RE: Check Object Existence

Mike Schmitt — Wed, 05 Aug 2020 16:29:27 GMT

Just checking in to confirm this still apparently works fine in 20.2, and appears to be nice and snappy.