Is it possible to write a query where you can do ItemCode = Item No/Technician ?

[former_member817803]

Its mainly as an example, but my end goal is, I don't want them to be able to sort the sales order line, so im trying to write a query, if they were to double click on any of those columns, it would give them an error message.

So is it possible where if to set Itemcode = Item No/Technician? Not the values in the item code but the name of itself.

So everytime i click on "Item No/Technician", it would then give you an error message which I can write up. But if I was to click on the values inside of the Item No/Technician, it would not be affected whatsoever and only the column names itself. I would like to apply this for all the column names if theres a way or I would have to manually do each one which isn't that bad.

What I've gotten so far is set up a b1up where if you double clicked on the item no/technician, it would give you an error message but if you were to double click on any of the values inside the item no/technician, it would also still give you an error. Thats the part I am trying to avoid where the error message should not pop up if i click on any values inside the column

[kai_f]

Hello Tommy,

you said your end goal is that it should not be possible to sort the table.

And you already got so far that you got an error when the row is being doubleclicked.

So it should be possible to only give you an error or stop the action if the row = 0.

[former_member817803]

So when I did row 0, it included all the rows, row 1 is the first line and etc. I also tried -1 and it didnt work. Im not sure why row 0 included all the rows when its stated on there to be row 0 specifically

[Johan_H]

Hi Tommy,

I think that can only be achieved with the UI API, and it would be a considerable development project.

Can you please explain why you do not want users to sort this table?

Regards,

Johan

[former_member817803]

when you sort the table and save it like from 10-1, and the. You reopen it back up, it would say 1-10 instead of the 10-1. It more of a visual problem and not the order itself. Being able to sort and save jt that way causes problems. So if theres a way to block sorting all together and only be able to use the values inside the column would be great. If you have anyone else that can help with this question it would be greatly appreciated

[Johan_H]

Hi Tommy,

Ok, could you please elaborate on what those problems are? Could you perhaps describe an example scenario where a user sorts a table, and what (problem) happens next?

Regards,

Johan