Hello ProjectWise Community,
I am attempting to set/use a SQL Statement (within the Value List section of a custom Attribute; called dc_File_Type, which is used for Document Codes) to leverage the value of another Document Attribute (used in a Lookup Table) for comparison against the Folder Description.
Here's the setup:
Lookup Table (FDOT Lookup Table - Document Codes Environment; SQL Table Name = FDOT_Lookup_Table_Document_Codes)
*Note: Attribute Names for the Lookup Table are: lt_Code, lt_Description, lt_Filter_A, lt_Filter_B, etc.
Folder (FDOT CAD Drawing Files Environment)
SELECT lt_Code, lt_Description FROM FDOT_Lookup_Table_Document_Codes WHERE lt_Filter_C = 'File Type' AND lt_Filter_A LIKE '%$VAULT.DESCR$%' AND lt_Filter_D = 'Drawing Files' AND (lt_Filter_B = '$EDIT#da_Project_ID$' OR lt_Filter_B = 'ALL') ORDER BY lt_Code
*Note: da_Project_ID is another Attribute which corresponds with a Project (ex. 123456)
*Note: If I use lt_Filter_A = '$VAULT.DESCR$', it works just fine.
Has anyone had success using the LIKE operand, and specifically with the %string% option? I am hoping to achieve a True result for the above conditions, where the String is Discipline (obtained from the Lookup Table) and "match it" to the Folder Description (Something Discipline something).
Any assistance will be GREATLY appreciated.
Can you try to do test with a more simple statement?
e.g. SELECT lt_Code, lt_Description FROM FDOT_Lookup_Table_Document_Codes WHERE lt_Filter_A LIKE '%$VAULT.DESCR$%'
I've just tried to use this simple statement SELECT o_itemname FROM dms_doc WHERE o_itemname like '%$VAULT.DESCR$%' and it worked just fine. So I wouldn't say that using this '%$VAULT.DESCR$%' is an issue.
Also what PW Integration Server and PW Explorer versions you have?
Sooo sorry for responding to this post so late.
I did try your suggestion and am getting the same results as before the change. Do you think that it is/could be a SQL Database Version thing? We are running SQL Server 2008 R2. Not for much longer though.
We are still running ProjectWise Integration Server V8i (SELECTseries 4) Version 08.11.11.590. Not for too much longer though. Also, ProjectWise Explorer version is CONNECT Edition Version 10.00.02.320.