Scripting

Warning: the understanding of this is advanced but implementing it is easy.

You don't need to worry about ID as it will take care of iteself so the INSERT becomes:

insert into HD_TICKET_FILTER(USER_ID, NAME, FIND_FIELDS) values (blah)

Aside: I think 'incrementingvalue' is working for you because are essentially doing is inserting a string into an integer column and cast('incrementingvalue' as char) = 0 and the system will just ignore your 0 and increment it.  

Let's pretend that you wanted to "push this value to" (your words) a group of users that are in a label labelx.  I am not going to change anything about this filter except WHO uses it.  If i want to change the filter I will change it in the UI. 

However, I am not satisfied with pushing this filter one-time to a group of users.  I want to both:

1. "Push this value" to a user group so they can start to use the same filter
2. Maintain this filter - meaning any changes that user 1371 makes to this filter I want the others to inherit it.     In this way 1371's filters become a "template"

If that is the the case then this is what you want to do. 

Create a ticket rule:

• * Frequency: some schedule (not  on ticket save )
• * select query:  in this rare case it doesn't matter since we're going to ignore any pre-requisites and blindly copy / overwrite what is already there with our template

  select 1

• * update query:

   replace into HD_TICKET_FILTER(ID,USER_ID, NAME, FIND_FIELDS)
  select 
      ifnull(FILTER_CHK.ID, 0) OLD_OR_NEW_ID,
      TARGETUSERS.ID,
      FILTER.NAME,
      FILTER.FIND_FIELDS
  from
      USER as TARGETUSERS
          join
      USER_LABEL_JT as UL ON UL.USER_ID = TARGETUSERS.ID
          join
      LABEL ON LABEL.ID = UL.LABEL_ID
          and LABEL.NAME = 'labelx' /* our group of users */
          join
      HD_TICKET_FILTER as FILTER ON
   /* our template filter */         FILTER.NAME = 'Closed Tickets Only' 
          and FILTER.USER_ID = 1371
          left join
      HD_TICKET_FILTER as FILTER_CHK ON FILTER_CHK.USER_ID = TARGETUSERS.ID

   

Sorry for the complexity of the query but since HD_TICKET_FILTER does not have a unique index on the FILTER.NAME and FILTER.USER_ID columns combined (it should but doesn't) I had to jump through an extra hoop to get it to work. 

edit: just made it easier to read that's all