I’m attempting to automate HDCase creation using a UD08 BPM, and using information pop-ups at different points in the BPM flow to see what values various fields have.
When inserting a Field from a DataSet, I get different results depending on whether I select Field Query or Table Query to pull the Field value.
After selecting either Field Query or Table Query, the Field selection interface looks the same, and the inserted hyperlink also looks the same. It appears that at this point using Table Query gives the correct results, whereas Field Query has some Fields blank.
Anyone know what the difference is between using Field Query and Table Query ?
I’ve seen it happen as well where table and field query don’t match up. I think they react a little differently to added/updated rows, vs existing rows (ones with no row mod). I never really got to into finding the specific difference and I was able to get what I needed working. It was annoying though.
To check what’s going on, try using Show Mesage and insert 4 Separate Table queries, one for each filter of Added, Updated, Deleted and Unchanged records. Strangely, you will only see the Added records, not Unchanged if you select all the filter options. Do the same for th Field queries.
I’m guessing that there is an Unchanged record that has less information in it, so make sure the query you use has a RowMod <> “” to get rid of these.