Filter and remove duplicates contents of Dropdown list in create new

ginacargile

Based on the current code I have listed here:
https://datatables.net/forums/discussion/37068/saving-a-dropdown-field-value-and-and-id-in-the-same-table?new=1

My dropdown list has values like "Door", "Door 1", "Front Door", "Front Door 1", "Side Door 1" and I need to cut the # value off the end's and then remove duplicates.

I've looked at GetFormatter for server side. I figured it would have to be done client side, but, what event and how exactly?

Thanks!

allan

Are you using the Field->options() method to get the options, or something else? There is a formatter option for the options, which you can use to modify the labels.

Allan

ginacargile

Yes, I'm using field .options. I don't know how to use the formatter to format the values the way I want. ?

using (var db = new Database(dbtype, conn))
                {
                    tempInstanceNames d = new tempInstanceNames();

                    response = new Editor(db, "tempInstanceNames")
                   .Model<JointempInstanceNamesModel>()

                   .Field(new Field("tempInstanceNames.InstanceNameID")
                   .Options("tlkInstanceNames", "ID", "InstanceName")
                   .Validator(Validation.DbValues(new ValidationOpts { Empty = true }))
                   )
                   .Field(new Field("tempInstanceNames.LocationSpaceID")
                       .Options("tlkLocationSpaces", "ID", "LocationSpace")
                       .Validator(Validation.DbValues(new ValidationOpts { Empty = true }))
                   )
                   .Field(new Field("tempInstanceNames.SubLocationSpaceID")
                        .Options("tlkSubLocationSpaces", "ID", "SubLocationSpace")
                       .Validator(Validation.DbValues(new ValidationOpts { Empty = true }))
                    )
                     .Field(new Field("tlkInstanceNames.InstanceName")
                        .Options("tlkInstanceNames", "ID", "InstanceName")
                       .Validator(Validation.DbValues(new ValidationOpts { Empty = true }))
                    )
                   .LeftJoin("tlkLocationSpaces", "tlkLocationSpaces.ID", "=", "tempInstanceNames.LocationSpaceID")
                   .LeftJoin("tlkSubLocationSpaces", "tlkSubLocationSpaces.ID", "=", "tempInstanceNames.SubLocationSpaceID")
                   .LeftJoin("tlkInstanceNames", "tlkInstanceNames.ID", "=", "tempInstanceNames.InstanceNameID")
                   .Where("tempInstanceNames.LocationID", locationID)
                   .Process(request)
                   .Data();
                }

ginacargile

I didn't realize you could do an inline select! I found this link.
https://datatables.net/forums/discussion/27856/editor-net-field-options-method

If there is a better way, please let me know.

Full code here:

.Field(new Field("tlkInstanceNames.InstanceName")
                        .Options(() => db
                        .Sql("select distinct SUBSTRING(inn.InstanceName,0,PATINDEX('%[0-9]%',inn.InstanceName)) as label, SUBSTRING(inn.InstanceName,0,PATINDEX('%[0-9]%',inn.InstanceName)) as value FROM dbo.tblInstances i LEFT JOIN tlkinstancenames inn ON i.InstanceNameID = inn.ID WHERE SUBSTRING(inn.InstanceName, 0, PATINDEX('%[0-9]%', inn.InstanceName)) IS not null ORDER BY label,value")
                        .FetchAll()
                        )
                    )

Thanks!

ginacargile

Thanks

allan

For complex queries that looks about as good as it gets :-)

Allan