I am using the IFM Manager and would like to update a PV. I am doing a report an

bduff over 11 years ago

I am using the IFM Manager and would like to update a PV. I am doing a report and need one of the user profile properties saved in a PV.

I have successfully be able to use other functions such as touser(), and tostring().

I would like to get the following query to work
UPDATE <ID> SET PV <pvName> = [user(<PVofTypeUser>,"customField1")]...

Discussion posts and replies are publicly visible

0 priyal.patel
Appian Employee
over 11 years ago

Are you getting any sort of error output when you try it?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 nareshs over 11 years ago

u can try this..
UPDATE <TABLENAME> SET PV<pvName>=[user(<PVofTypeUser>,"customField1")]...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 bduff over 11 years ago

@priyal.patel - I get the following error
class java.lang.NullPointerException Edit
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 bduff over 11 years ago

@nereshs, the Pv is not stored in a table
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel