How to find the fv! row number?

"c10" is a column value, not a row.  When data is queried via a!queryProcessAnalytics, it returns all column data in properties like "c1... c10" etc; it's up to you to figure out what those map to.  Luckily for us, if we view the entire formatted queryProcessAnalytics output, we can see that it also returns a separate chunk of data (not usually used in paging grids) that defines the "labels" for the different columns; these labels correspond to their configuration within the original Portal Report that the data is being sourced from.

The easiest thing for you to try first would be to run the a!queryProcessAnalytics call in a new Expression Rule editor and see what it gives you, and try to get used to the data structure and what the different pieces are.  It's a little bit convoluted to be sure, but it's not too much to grasp for most designers I think.

Hi Mike,

Thank you for the reply. I read somewhere that I need to download the process model instance to see the XML where the local id is referenced as the c number location. Do you know anything about this?

I will run the a!queryProcessAnalytics.

Thanks,

Roberta

robertab0001 said:

I read somewhere that I need to download the process model instance to see the XML

I think that's far more effort than what is really necessary (and i doubt you'd find anything useful - i wouldn't even know what to look for).  I'm fairly familiar with the "c##" column properties that are generated by this style of query as I've dealt with it in the past.  Question for you: you copied the column definition before, but where is this grid getting its data currently?

Someone else did it initially. I can see the list of process instances in the Appian Process Report Designer but as dumb as it should, I don't know how to export a specific instance in this; let alone to know if this is where I am supposed to download this XML document.

I did run the process analytics query as you mentioned, but it seems I will have to do some digging as most of the columns are numbers.

When you run the Query Process Analytics by itself and get the whole data set, you should see a property called Column Configs.  The following is an example of the data set returned when querying a user's task list.  Note the ColumnConfigs at the bottom -- there would be something similar in every Query Process Analytics call.

When you run the Query Process Analytics by itself and get the whole data set, you should see a property called Column Configs.  The following is an example of the data set returned when querying a user's task list.  Note the ColumnConfigs at the bottom -- there would be something similar in every Query Process Analytics call.

Oh my goodness, Mike! genius!

Sometimes I wonder if I am the only one that struggles so much.

Thank youuuu!!

Trust me that I've been through the same struggles but I've been at it for >8 years - the stuff I share is stuff I had to figure out (often alone), so I like being able to prevent other people from having to struggle past the same old stumbling blocks