Is there any way I can change the lookup at the Company ID login page.
The client has 100+ companies and is used to sorting by ID . Is there any PV I can change so it shows the ID first and then customer can then select the ID first.
Thanks
Sammy
Hi Sammy,
This list is populated on the SQL side and I don't think there is a PV list or anything typical taht can be updated.
Thanks,
Adam LeonardTechnical Support Engineer
**This posting is provided "AS IS" with no warranties and confers no rights.
There needs to be a SQL "instead of" trigger on tables for SELECT statements... LOL.
We have this same problem. 100+ companies. No filter on the logon screen. And we can't sort on CpnyID.
|̲̲̲͡͡͡ ̲▫̲͡ ̲̲̲͡͡π̲̲͡͡ ̲̲͡▫̲̲͡͡ ̲|̡̡̡ ̡ ̴̡ı̴̡̡ ̡͌l̡ ̴̡ı̴̴̡ ̡l̡*̡̡ ̴̡ı̴̴̡ ̡̡͡|̲̲̲͡͡͡ ̲▫̲͡ ̲̲̲͡͡π̲̲͡͡ ̲̲͡▫̲̲͡͡ |
First you have to modify the store procedure 'company_active' that is on system database. And after that, you have to edit the PV, on a csv file and re-import it with the new changes.
The store procedure and te PV must to be equals.