All workflow is bound to the fieldid. If you drop and recreate a field, with the same id, it will be bound to all the same workflow (given that you don't open the workflow, acknowledge the error you get about missing fields, and save it).
Renaming a field (to match the name of a recently delete field) will not cause the workflow bound to the old name to attach to the field. Axton Grams On 6/7/07, patrick zandi <[EMAIL PROTECTED]> wrote:
** seperate question: since you are answering.. I just imported all the diary fields (long) into another diary field (log) if I just delete the old diary, and rename the new db name to the old one.. Will this work.. I cannot remember if all workflow is tied to the Fieldid or fieldname. thanks. On 6/7/07, Axton <[EMAIL PROTECTED]> wrote: > > ** I've implemented this using the cursor_sharing parameter (SIMILAR). > Similar is recommended over force if you search the KB, although the > articles are against really old versions. It makes a huge difference in > Oracle in relation to (1) hard parses and (2) shared pool size. This does > two things on the Oracle side, reduces cpu overhead, reduces memory > requirements. > > It would really be better if Remedy were altered to use bind variables > natively, but this will never happen. > > Axton Grams > > On 6/7/07, patrick zandi <[EMAIL PROTECTED] > wrote: > > > > ** > > Alternatively, you may set the parameter "cursor_sharing" to "force". > > <https://remdev2.testbed.rl.af.mil:1159/em/console/database/instance/initParameters?event=findParameter&target=ARS10.adm&type=oracle_database&initParamName=cursor_sharing&newParamValue=FORCE&backURL=/em/console/database/instance/hdm%3Ftype%3Doracle_database%26task_id%3D2489%26target%3DARS10.adm%26event%3DfindingDetailsReload%26findingID%3D11&messageText=ADDM%20recommends%20modifying%20parameter%20cursor_sharing%20from%20EXACT%20to%20FORCE.&messageType=info> > > Action Investigate application logic for possible use of bind > > variables instead of literals. > > Rationale At least 12 SQL statements with PLAN_HASH_VALUE 1942213815 > > were found to be using literals. An example is SQL statement with SQL_ID > > "dybpwnnkz45af" . > > SQL Text SELECT C536871112 FROM T262 WHERE C1 = 'WP0011693'<https://remdev2.testbed.rl.af.mil:1159/em/console/database/instance/sqlDetail?event=doLoad&target=ARS10.adm&type=oracle_database&sql_id=dybpwnnkz45af&planHashValue=1942213815&refreshChoice=HIST_CUST&pageNum=1> SQL > > ID dybpwnnkz45af<https://remdev2.testbed.rl.af.mil:1159/em/console/database/instance/sqlDetail?event=doLoad&target=ARS10.adm&type=oracle_database&sql_id=dybpwnnkz45af&planHashValue=1942213815&refreshChoice=HIST_CUST&pageNum=1> > > Rationale At least 12 SQL statements with PLAN_HASH_VALUE 1942213815 > > were found to be using literals. An example is SQL statement with SQL_ID > > "4s8y4x7jf2mbg" . > > SQL Text SELECT C536871112 FROM T262 WHERE C1 = 'WP0010719'<https://remdev2.testbed.rl.af.mil:1159/em/console/database/instance/sqlDetail?event=doLoad&target=ARS10.adm&type=oracle_database&sql_id=4s8y4x7jf2mbg&planHashValue=1942213815&refreshChoice=HIST_CUST&pageNum=1> SQL > > ID 4s8y4x7jf2mbg<https://remdev2.testbed.rl.af.mil:1159/em/console/database/instance/sqlDetail?event=doLoad&target=ARS10.adm&type=oracle_database&sql_id=4s8y4x7jf2mbg&planHashValue=1942213815&refreshChoice=HIST_CUST&pageNum=1> > > Rationale At least 12 SQL statements with PLAN_HASH_VALUE 4064886972 > > were found to be using literals. An example is SQL statement with SQL_ID > > "4vv1kb5twgab0" . > > SQL Text SELECT C536871111 FROM T197 WHERE C1 = 'TT010174'<https://remdev2.testbed.rl.af.mil:1159/em/console/database/instance/sqlDetail?event=doLoad&target=ARS10.adm&type=oracle_database&sql_id=4vv1kb5twgab0&planHashValue=4064886972&refreshChoice=HIST_CUST&pageNum=1> SQL > > ID 4vv1kb5twgab0<https://remdev2.testbed.rl.af.mil:1159/em/console/database/instance/sqlDetail?event=doLoad&target=ARS10.adm&type=oracle_database&sql_id=4vv1kb5twgab0&planHashValue=4064886972&refreshChoice=HIST_CUST&pageNum=1> > > Rationale At least 12 SQL statements with PLAN_HASH_VALUE 4064886972 > > were found to be using literals. An example is SQL statement with SQL_ID > > "bwvq3h65kwaj3" . > > =========================================== > > Has anyone Implimented this.. ??? and or has Remedy Recommended this > > ? Cursor_sharing :? > > -- > > Patrick Zandi > > __20060125_______________________This posting was submitted with HTML > > in it___ > > > __20060125_______________________This posting was submitted with HTML in > it___ > -- Patrick Zandi __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
