Prev
Next
Forums Lawson Design Studio

Portal Page questions-security and conditional REC-STATUS

Sort:
You are not authorized to post a reply.
Author
Messages
drhoades44
Advanced Member
Posts: 46
Advanced Member
1/23/2009 7:16 PM

    I have a Portal Page with vendor invoices as Data0 and Payments as Data1. One of the fields in Data1 is CBT-REC-STATUS.

    1.  I want to show the values that are related to the numbers in the table field--not the numbers. I'm relatively new to Design Studio, so maybe I'm making it difficult. I looked at XML and it looks like any conditional handling would require DTD or XSLT so that's out. Is there a Javascript solution, and if so, could someone show me an example?

    2. How do I get security set on the page? I logged in with a test-log in set for one company's access to data and I got an error and it seemed to lock up and the data that appears on load is someone else's data (not good). Any solutions for this?

    Thank you so much for your time.

    John Henley
    Senior Member
    Posts: 3348
    Senior Member
    1/24/2009 6:39 PM
      For #1, it's kind of a hack/pain, and you'll need to do it by editing the XML source, as you can't do it via the Page Designer/API builder.

      1) in the DME query (qry), Append ",xlt" to the field, e.g., "CBT-REC-STATUS,xlt".
      2) Then in the FIELD tag, change the NAME attribute to "CBT-REC-STATUS,xlt".


      Thanks for using the LawsonGuru.com forums!
      John
      John Henley
      Senior Member
      Posts: 3348
      Senior Member
      1/24/2009 6:45 PM
        For #2, security for a data query is based on table/file security (assuming you're using LAUA security).
        Thanks for using the LawsonGuru.com forums!
        John
        You are not authorized to post a reply.