Hi i search a function that search in appian database if PID exist or not

Hicham,

There is no function that does this, but you have some options. Using an execute process report smart service you can filter on an All Processes report on a column defined as process id. If any results are returned, then you know the process id exists.

Alternatively, if you are using data stores and have defined a particular type to store the process id, then you can use query rules to search for a particular process id.

hi Michael
Thank you for your response.
I am trying to develop a PM with form in which an entry number, and PM must check if this number is in appian database as PID or not et return boolean.
I do not want to use a report

Hicham,

You can develop a custom function, as one is not already in place. Alternatively, the method I have mentioned (and Sathya in your previous post) to use a report will also achieve the same result.

If you want to make the call as an expression rather than the Execute Report Smart Service, there is a custom plugin called Get Report Content (under Shared Components --> Expressions) that will allow you to query a report as an expression. Since it's an expression you can use it directly on a form.