I had defined a custom content type, and I am trying to define a filtered lookup column. I can select the list from where to pick up the column I need, but I can't find any example of the needed format of query string. I can filter the list manually by appending "?FilterField1=columnName&FilterValue1=myValue" to the list URL. Where can ...
I have a database issue that i currently cannot wrap my head around with an easy solution. In my db I have a table that stores event values.. 0's and 1's with a timestamp. Issue being that it is possible for there to be the same event to occur twice as a business rule. Like below '2008-09-22 16:28:14.133', 0 '2008-09-22 16:28:35.233', ...
I've thought about this too much now with no obviously correct solution. It might be a real wood-for-the-trees situation, so I need stackoverflow's help. I'm trying to enforce database filtering on a regional basis. My system has various users and each one is assigned to a regional office. I only want users to be able to see data tha...
I'm using VBScript (ASP Classic) and SQL Server; I'm trying to have a section on the website where you can see a count of products at certain price levels. Something like: $50 - $100 (4) $100 - $500 (198) $500 - $1000 (43) For the love of me I cannot figure out a good way to do a query like this. I mean... I know how to get the numb...
I want the lookup field to be filtered to only display titles from the current document library (meaning the document library that the user is currently in). I cannot specify the document library b/c I don't want to have to define a new lookup column for each new document library...instead I'm hoping to do this as a custom content type ...
I'm working with Sharepoint 2.0 (WSS2) and need to create a lookup field that draws the name of an Issue from an Issue List. The trouble is, it does not appear that I can filter this lookup so that only the current version of the Issue is pulled up. The result is that I have several selections for the same Issue that appear in the look...
From the following code: dvdList = Dvd.objects.filter(title = someDvdTitle)[:10] for dvd in dvdList: result = "Title: "+dvd.title+" @ "+dvd.price+"." When does Django do the lookup? Maybe it's just paranoia, but it seems if I comment out the for loop, it returns a lot quicker. Is the first line setting up a filter and then the fo...
I am trying to improve the performance of a SSIS Package. One thing I got startted with is to filter the reference table of the Lookups. Until now, I was using a table as a reference table for that lookup. First improvment was to change the table to a SQL clause that is selecting just the columns I need from that table. Next, I want...
I have two tables in a restaurant search done in php. All the information about the restaurant type, facilities, cuisines are in entered to Table2 -'stack' with reference to their restuarant id in the table 1. How do i run a query so that i can get all the restaurant that serve chineese and also serves dinner and also have parking? This...
In this thread a user had problems with the lookup filter being missing in an acess database that had a SQL server backend. The problem was easily solved simply by checking on an option in the current database settings that allowed ODBC fields to also provide lookup filter dropdowns. For those confused, the lookup filter is the excel l...