Search results by user ID 7199

SQL override to display picture on grid

kumara — Tue, 21 Mar 2017 17:10:34 GMT

trying to display Picture on grid cell using SQL override like below

SELECT viewPicPartList.Picture FROM viewPicPartList WHERE viewPicPartList.PartNo = viewAgentPriceList.PartNo

but it is displaying System.Byte[ insted of showing the picture in the overide cell

Re: case diaglogue

kumara — Wed, 13 Jul 2016 12:20:09 GMT

Hi Ben.

thanks for the clarification on this issue.

i have managed to get this customize the way i can edit the exsisting case dialog in the edit case window.

thanks again

regards

kumara

How to run some action set when screen load?

kumara — Tue, 12 Jul 2016 17:28:07 GMT

i want to run some actionset when the screen is loading first time.

how can i do that?

Re: case diaglogue

kumara — Tue, 12 Jul 2016 17:20:30 GMT

any update on this mater. i just want to remove some activity we wrongly recored and deleted later from the exsisting case dialog.

if not it is look not profesional if our customer can see deleted activity from his portal.

Re: LIKE Operator OR Contents Operator

kumara — Mon, 25 Apr 2016 18:47:38 GMT

Hi Ben

thanks for the quick respond.

acturly this data is not in the grid controller. i just want to select it from the table stright.

this serial No are uniq if it has only one serial in one feild i can retrive it but if it has more than one with the space between i cant retive it using normal rettrive from table option.

ex : as you can see in raw 7 serial number feild it has many serial NO if i seach with one of it ( 3594401) it need to identify that and give me the SO NO as a return.

thanks in advance

LIKE Operator OR Contents Operator

kumara — Mon, 25 Apr 2016 10:30:32 GMT

Im trying to get So No from below table witch has the serial numbers seperated with space if it has more than one.

can anyone tell me how can i use 'Like' or 'content' Operators and retrive the SO NO

Go To So	SO NO	Item	Qty	Serial NO	Delete
Go To So	15/16-1205	17 - Ink / Solvent (Assembly):17260-01-HA	2	H144326AA281681A17	Delete
Go To So	15/16-1205	17 - Ink / Solvent (Assembly):17181-HA	1		Delete
Go To So	15/16-1202	17 - Ink / Solvent (Assembly):17260-01-HA	1	H144333AC161681A17	Delete
Go To So	15/16-1202	17 - Ink / Solvent (Assembly):17181-HA	2		Delete
Go To So	15/16-1201	09 - Print Head:09008	1	3536429	Delete
Go To So	15/16-1200	42005	1		Delete
Go To So	15/16-1200	37159-06	1	3610 3595289 3593308 3594107 3594401 3594040	Delete
Go To So	15/16-1200	37159-06	1	3670 3595888 3594427 3593410 3593337 3595728	Delete
Go To So	15/16-1200	37027-01-02	1		Delete
Go To So	15/16-1200	36053-02	30		Delete