How to write a search that will determine if a lookup file has been updated? Thanks. ... View more

Hi. I have a search result returned as the following: name type col_1 col_2 col3 ==== ==== ===== ===== ===== N1 T1 A A C N1 T2 A B D N2 T1 D D C How to count numbers of "A", "B", "C", and "D"? For example, the result looks like this: new_field count ========= ===== A 2 B 1 C 2 D 3 Any helps are great appreciated. Thanks. ... View more

Hi. I have a search query returning the result as the following format: Application Service Owner Location Status =========== ======= ===== ======== ====== app1 srv_1 John Loc_1 1 app1 srv_2 John Loc_1 2 app1 srv_3 John Loc_1 3 app2 srv_1 Peter Loc_2 1 app2 srv_2 Peter Loc_2 4 app2 srv_3 Peter Loc_2 5 And I want to convert "Service" and "Status" into columns with this format: Application Owner Location srv_1 srv_2 srv_3 =========== ===== ======== ===== ===== ===== app1 John Loc_1 1 2 3 app2 Peter Loc_2 1 4 5 Does anyone have any ideas? Thanks a lot. ... View more

How to get all possible entries from two lookups? For instance, lookup_1 and lookup_2 lookup_1 application ========= app1 app2 app3 lookup_2 service link ====== ============== s1 link1 s1 link2 s2 link3 And the end result should be: lookup_3 application service link ========== ====== ==================== app1 s1 link1 app1 s1 link2 app1 s2 link3 app2 s1 link1 app2 s1 link2 app2 s2 link3 app3 s1 link1 app3 s1 link2 app3 s2 link3 ... View more